Foundation

The following: IMHO, the low code security row should be dynamically converted to a security expression whenever I switch to it and vice-versa. It would save a lot of time. By the way, is it really possible to apply such a security rule into a security expression?  If so, how could I convert this into a security expression? Thanks.

Hello Everyone, We allow users to enter the amounts in the editable grid using the textbox component. (saving these values in the CDT decimal field) And displaying the total amount and validating the total column against other values. Values entered are : 430603.1013871.55117011.6523402.33 Would like to know why the sum function is not giving the value with the correct precision.   And also to calculate the sum with correct precision, do we need to use Fixed?

Hey,I am exploring some thing new in Appain functions,Supose if user enter 1+2+3+4+5 in a text box then is there any function to evaluate this and give me the sum of all those numbers as 15.Thanks in advance.

We have tables we want to create record types from but the tables can have millions of records in them and we only need to filter for certain rows. We're trying to find a way to filter the rows we need in the sync filters but there's a lot of limits on what we can use in the Sync Filters expression. Appian doesn't seem to allow rules or constants but we were able to make use of a!executeStoredProcedureForQuery() to call an SP which would specify the records we want to filter for, as per below: a!localVariables( local!totalCount: tointeger( tostring( index( a!flatten( index( a!executeStoredProcedureForQuery( dataSource: "jdbc/Appian", procedureName: "SND_getPksTotalCountToFilter", timeout: 30, inputs: { a!storedProcedureInput(name: "p_workflow", value: null) } ), "results", null ) ),

Hey guys,I am exploring the validations stuff in the interface in appian.I have 2 text fieds in the interface, I have set up validation on the 2nd text box, if the 1st text box value is equals to Hi then I am showing a validtion on the 2nd text box.So here, If I enter Hi in the 1st text box then validation is showing up only when I enter something in the 2nd text box. Validation was not showing whenever I enter Hi in the 1st text box and levaing the 2nd text box empty.Let me know If I am missing anything here.Thanks in advance.

Tried using the Log Reader Plugin but it does not read logs from all servers. Any suggestion is appreciated. Thanks 

Hi everyone, I need to build a team dashboard for managers and directors, where the team data is stored in a single record type. This data includes fields like username, personal number, manager's personal number, and email ID. I’m currently passing the email ID to fetch the personal number of a user, and then using that personal number to find the manager's personal number in order to get a list of employees under that manager. This process is repeated for up to five levels, as directors report to managers and each manager can have multiple employees under them. However, after implementing this approach, the performance of the UI has slowed down significantly. Can anyone suggest a more efficient alternative to improve the performance while maintaining the same functionality?  Below is the code for your reference. 

Hello Everyone, I need to build a team dashboard for managers and directors, where the team data is stored in a single record type. This data includes fields like username, personal number, manager's personal number, and email ID. I’m currently passing the email ID to fetch the personal number of a user, and then using that personal number to find the manager's personal number in order to get a list of employees under that manager. This process is repeated for up to five levels, as directors report to managers and each manager can have multiple employees under them. However, after implementing this approach, the performance of the UI has slowed down significantly. Can anyone suggest a more efficient alternative to improve the performance while maintaining the same functionality? Below is the code for your reference.

Hi Everyone, We have a editable grid with dropdown fields, second drop down(Evidence category) choice values purely dependent on first dropdown (Therapeutic area) selected value.I have configured the code like this but getting the above error. Can you please help me a!sectionLayout( label: "", contents: { a!gridLayout( label: "", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Therapeutic Area"), a!gridLayoutHeaderCell(label: "Disease State"), a!gridLayoutHeaderCell(label: "Evidence Category"), a!gridLayoutHeaderCell(label: "Evidence Need"), a!gridLayoutHeaderCell(label: "Priority"), a!gridLayoutHeaderCell(label: "IEP Code"),

Hi Everyone, We have a editable grid where we placed 2 drop down values. Second dropdown choice values and choice labels purely dependent on first drop down selected value.But we are getting the error. a!dropdownField( Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 label: "Therapeutic Area", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 placeholder: "---Please Select---", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 choiceLabels: index(local!therapeuticArea, "name", {}), Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 choiceValues: index( Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A

1. Synchronous Start Process - Here, documentation says, we get the output of the process variable from child process to the parent process. 2. Activity chaining in Sync start process - Here the documentation says, Chaining through a synchronous Start Process node means the original process will wait for other process to complete before continuing. Any activity chaining in the started process is not connected to the original process, so a broken chain will not return process variables to the original process. process variable will be returned to the parent process or not?. Please clarify 3. start synchronous process using start process vs sub-process As per this, if the parent child relationship isn't followed, how we are able to get the output variable as mentioned in point 1 documentation? If the Activity chaining in the parent and child are independent, why does the parent process waits for the child to complete? As per point 2, it s

In new 24.4 we have Synchronous and Asynchronous option for Start Process smart service . Then what's the difference between Subprocess Synchronous and Asynchronous things ?

Hi Team,I have One Requirement that isi want to display data in read-only grid from records and that data i want to download in CSV Format also if i want to upload new data i want to upload in CSV format,if it is possible please help me with it,those import and export options i have to display in buttons.

We have a form with multiple collapsible sections, and in some of these we also have subsections. When user clicks on submit, there might be errors in the subsections that are not visible to the user because the parent section does not have the "This section contains errors" warning. I've come to discover that it's because other subsections don't have any errors. Here's an example where this happens: Here both the parent and child show that there are validation erros. The moment I add a section without validation errors, the warning disappears on the parent:   I feel like this should not be the standard behavior and is something Appian should fix on their end. The only workaround I can think of is to have validations at section level, on the parent section. But that would display a red message box on the section that for me is not desirable. Any help here is appreciated.

Hi All, There is a requirement to a get document from the third party system, Can someone suggest a way what is the best way to get the document from the third party system? Below is the implementation that I know, Apart from these any plugins or any other things? 1. Third party systems will return url where the file is located. As soon as user clicks the document can be downloaded into the local system. 2. Thir party systems will return the document in binary format and Integration can convert binary to document from the respsonse.   Apart from this Do we have any other way to get the document from the third party systems? My Next question is  If other systems want to post a document into appian, how exactly web appi will configure it, how the request hader document format will be? Thanks in Advance!

Hi, In our Application, we read an email box and for each email - we should check if it has any attachments and uncompress them. We have a requirement from business to uncompress zip, eml, msg, rar files upto 3 levels in depth and extract data and attachments. Is there a plug-in to achieve this? Any help here would be appreciated. Thanks, Keerthi

Well, how am I supposed to reference the properties of this query in another process model? It is a dictionary, however I cannot reference a dictionary in a process model, so would it be supposed to convert the query to a map or what? By the way, it contains some wierd properties like c0, c1, c2...dp0, dp1, dp2... How could I cast this dictionary into a map then? Thanks in advance

Consider a scenario where we have two entities: Books and Chapters, with a one-to-many relationship (i.e., each book can have multiple chapters). I currently have a read-only grid that displays records based on the Book entity. One of the columns in this grid is called "Chapters", which displays all associated chapters in a bulleted list. Since a book can have more than 10 chapters, I'm currently fetching all chapters into a local variable and indexing them based on the Book ID to display in the corresponding grid row. This approach works fine for now. However, I'm concerned about performance if the chapter count increases more than 5000 Does anyone have suggestions on how to handle this scenario more efficiently?

Team, want to check on these 2 aspects, which we are attempting to leverage in our Appian solution implementation.   1) We are building a solution to retrieve specific data using XPATH from an XML and mapping it to a target location.                 We will be using the "xpathdocument" function in Appian to fetch the value from XML.   2) We will also be leveraging the below function to obtain our XML. i) Convert the json data we have into an Appian object ii) Then convert the Appian object into XML.   --- something like this ---   local!apoPbj: a!fromJson(ri!ipJson)   local!xmlObj: toxml(local!apoPbj, true, "xml") --- something like this ---   3) Data will be fetched from XML using the 'xpathdocument' method as we mentioned above.   This looks working good when tested. Question: 1) But I see currently "xpathdocument" method supports only

Hi all, We have a requirement to have custom fonts on specific interfaces... I read through the documentation and understand that this is not an OOTB feature. Admin console typeface will also not solve this issue as the fonts will be applied across all applications and cannot be referenced in specific components. How can we add custom fonts to specific interface components? Is this able to be done via a plug-in or some other means?

Hi All, We are getting below error in tomcat logs but unable to find out the root cause since process ID is not there. Please suggest how we can rectify this? ERROR com.appiancorp.storedprocedure.fn.ExecuteStoredProcedureFunction - Error executing stored procedure for data source [jdbc/businessds] com.appiancorp.storedprocedure.exceptions.MissingInputsException Thanks, Amita

Hello Team, We have a requirement to populate data into an excel template which will spawn for multiple sheets. This would be in a process model as we fetch the data to populate from a rest service. We were able to achieve populating data into the excel template using the using "Export Data Store Entity to Excel Smart Service". It works fine for regular mapping. But we are stuck with these 2 requirements.  1) We are were not able to dynamically insert rows into output excel sheet in this flow, when needed. There is a requirement to dynamically insert and populate rows in certain places (in the template), which we are not able to get through. 2) Also we are looking to see if there are any plugins or ability to dynamically delete redundant sheet from the output excel. Appreciate any inputs and suggestions.

I am an SQL Server Database Administrator and I will be migrating the Appian database from a stand alone SQL 2019 server to a clustered SQL 2022 server that has Always On Availability Group.  The Availability Group will be stretched across two subnets and will employ a listener for the application to connect. My question are: A: Do you see any problems with the configuration I am proposing for the SQL server set up - SQL AG and listener B: What features do I need to have installed on the SQL Server. C: Do I need the Client Tools SDK feature installed on my SQL server - I found it installed on the existing server D: What SQL Database permission are required for the Appian user that connects the app to the SQL server.  I like to work on the least privilege concept Please if you have the answers to these question or if you have a document that illustrates my SQL settings I would appreciate it I look forward to hearing from you Jeffrey

Hi All,       What is the Maximum number of nodes in Process Model?  Process Models contain no more than 50 nodes (limitation from Appian side). But i heard, maximum number of nodes is 38 in latest Version.can you pls confirm and send me the link.  Thanks in Advance!  Thanks, Kanna.R  

If a user belongs to two different application groups and both the groups are added to user start page (different application), which application start page will they see after logging into Appian?