Discussion Categories

local!combinedCriteriaResults: a!flatten( { local!test1.criteriaResults, local!test2.criteriaResults, local!test3.criteriaResults, local!test4.criteriaResults } ), Local variables show there is two items with the same criteriaCode. How can I remove one item and leave the other with the same code?

Hello everyone, we're facing a problem with the dropdown component used from Appian mobile, since it doesn't close the suggestions after pressing on the desired value but it requires the user to click back button. This UX is not very comfortable or intuitive for the end users. Any suggestions for alternative ways for handling such a use case (other than using a picker). I am aware of this older thread with the same problem: Appian Community  Thanks in advance. 

Hi, I have a variable of type document and another of data entity type where I need to store the documents, in all the process models I have this: but in just one case the documentId is not filled hence I am getting an error when trying to use the cmcDocument variable. In database it is inserted as expected: the instance:  I don't know what can be the problem as in other process models it is working and there is no difference between those processes

Which types of objects can be called using the "rule domain" prefix? A.   Connected systems, records, expression rules, and interfaces B.  Decisions, expression rules, interfaces, and integrations, C.   Process models, integrations, expression rules, and constants

My application is specifically for a local where the decimal symbol used is comma " , " and not a period " . ". So, the decimals will be inputted by the portal users as `5,55` instead of `5.55` So my current code is the following: a!textField( label: "The amount of money for payment", labelPosition: "ABOVE", instructions: "", helpTooltip: "The amount of money for payment", value: if( local!variant_value_for_payment > 0, a!currency( isoCode: "BRL", value: local!variant_value_for_payment, format: "LOCALE" ), null ), saveInto: { a!save( local!variant_value_for_payment, todecimal(save!value) ) }, refreshAfter: "KEYPRESS" ), I've read the a!currency docs and the main question for the best solution for me should be: → How may I be able to forcely make the system reads "100.50" and recognizes as " 100.00" and keeps that format? Thanks from now on

I am following the ESG Portal Application Tutorial (https://academy.appian.com/#/online-course-player/07769a88-b0b5-44ee-a08b-8f2200355f87) However, during Step 2 when I create a Portal and go on to create a Service account, I am simply unable to access the field. Furthermore, I cannot publish the portal that I created. Why is this? I believe it might be because I am a basic user instead of system admin but I do not know how to switch and give myself the correct permissions. Please help!

Hi team, There are two interfaces, namely interfaceA and interfaceB, and interfaceB is a sub-interface of interfaceA. In the sub interfaceB, two localVariables are defined, namely b1 and b2. In the parent interfaceA, there is a button. I want to implement a function. When the button in interfaceA is clicked, b1 and b2 in interfaceB can be operated. How to achieve it? Is there a recommended solution? Thanks a lot!

I have a question for those who took the ACD101 exam. ACD100 was revised to ACD101 in October 2023. The reference books currently published in this world are those of "ACD100" (no reference books named ACD101 have been found).  Are the questions asked in ACD101 similar to the content of the "ACD100" reference books, or are they completely different? I bought a reference book for ACD100 without knowing that the exam had been revised, so I am unsure whether I will be able to pass ACD101.

Hi guys, We've installed the Log Reader plugin and until recently it was able read the login-audit.csv file on all our environments. Now, the readcsvlogpagingwithheaders() function fails to return any values on our OAT environment, but works in all our others. I've noticed the path it's trying to read is different on this particular environment.  In OAT, it seems to be attempting to read the log file from: "/usr/local/appian/ae/shared-logs/login-audit.csv" Whereas in the others, it's reading from: "/usr/local/appian/ae/logs/login-audit.csv" Is there anything that could be causing it to try and read from a different directory, and is there a way to change this? It's causing significant issues at the moment and we need to resolve this as soon as possible. Really appreciate any help, Thanks.

/resized-image/__size/640x480/__key/communityserver-components-multipleuploadfilemanager/5d32e8f2_2D00_67fb_2D00_46e6_2D00_8cff_2D00_9dcc2b6c0050-89589-complete/pastedimage1712731195444v1.png I have a read-only grid that displays data retrieved using the record data function. The data appears as expected. However, I need to calculate the Total Amount based on the "Amount" column in the grid, and this total should be displayed outside the grid in another card layout. The issue is that using the record data function, I'm unable to access the data in a separate local variable to calculate the Total Amount. Although I can use the query record type function to obtain the data and calculate the total amount, this approach is not considered best practice. How can I calculate the Total Amount while using the record data function? Please Give me any Solution for this

Hi All I want to create custom search box for my main record type, whenever any user enter any value in the search box the data should be filter by the this value, this value should be compare with all the record types which have the relationship with my main record type  

Hi, Could you please help me with the below requirement Sample Table and Data RequestTable id name       email                 createdOn            createdBy1    N1   n1@mail.com 2020-07-27 13:15:30 n1@mail.com2    N2   n2@mail.com 2020-07-27 13:15:30 n2@mail.com3    N3   n3@mail.com 2020-07-27 13:15:30 n3@mail.com4    N4   n4@mail.com 2020-07-27 13:15:30 n4@mail.com2    N5   n5@mail.com 2020-07-27 13:15:30 n5@mail.com Conversation: id  reqId    message       sentBy 1    1            Xyz         n1@mail.com2    1            abc         reviewer1@mail.com3    1            pqr  &nbsp

i want to add comma to separate the numbers after clicking enter key the current output like: 98998997899 but my desired output should be : 9899,899,7899 How can i acheive this....

Hi team, I have a gridfield where a gridcolumn has a value who's character count can go upto 2500. I want to implement a functionality where i display only 200 chars and show a link "more". When I click on the link, either a popup appears where the entire 2500 char text is displayed or another site appears to display the whole value. How can I achieve this? I tried to use safelink, but I am not sure how to configure the uri to display the text. Can anyone please help me out. So far, i have achieved this,a!gridColumn( label: "Enter 2500 char text", value: a!richTextDisplayField( value:{a!richTextItem( text: left(fv!row.textValue,255) ), a!richTextItem( text:"..more", link: a!safeLink( ) ) } ) )

Hey Everyone, I am facing an issue while getting the groups for a user. We used to make use of function getgroupsformemberuser() from plugin People function version 1.10 jar We need to update the People function plugin to 1.16.0 jar but in this newest update, getgroupsformemberuser() is not supported. Replacement for getgroupsformemberuser() function looked a!groupsForUser() but result set of both is not matching. When I use getgroupsformemberuser(), I get 70 groups list which is absolutely perfect. When I match with the number of groups for loggedInUser from Users in Appian: It shows 70 users Means, getgroupsformemberuser() output matches with actual groups. But when I use a!groupsForUser() appian built in function, it return 72 groups: Conclusion: Output is not matching as it's returning 2 more groups which I don't have permission to view.  Is there any way that these 2 extra [NO PERMISSION] groups can be removed from this result set? I

Hi, I have a requirement where I need to add validation in editable grid Eg:  combination of (A+B+C+D) that should be unique for every entry but for D we need to add condition that all (A+B+C) should be unique, when we enter the data for D (or) it should throw error msg that having duplicate entries.

Using Version 23.1. When trying to start up, 3 of my engines are in CRASHLOOPBACKOFF state. When I look at the logs, it tells me that the engine was at transaction 235098772, but the transaction log ends at transaction 235097176. How is it possible that the engine has more transactions than the transaction log? Is there a way to resync the transaction log?

Does anyone know why apprian would show that a table has multiple primary keys, when the table only has 1 primary key, 3 foreign keys and an alternate key?

Hi Community,I am facing issue while using the SSH Key Pair authentication for SFTP. So when I am trying using Basic Credentials, I am able to establish the connection with Remote Directory and able to Send and Receive File. But for same username when I am trying through SSH Key Pair authentication I am getting error as "invalid privatekey: [B@41050c98". I have generated the Key Pair through Puttygen software, and the Remote directory Team has configured the Public Key on there end. Please if anyone have any idea regarding this help meThanks, Prathamesh

Hello all, Just checking to see if anyone knows how to sort a grid's field when the data property is not a typical query. Please see code below for what I mean. The grid displays as expected with values and all, but when trying to sort the fields I get the error in the Subject above. Are there any other ways to sort other than [recordType.field] or [recordType.relationship.field]? I did see an earlier post solution on here with similar error, but that scenario was quite direct working with recordData for the data property of the grid. Any input regarding this particular scenario would be much appreciated. Thanks a!gridField( label: "Grid for ", labelPosition: "COLLAPSED", emptyGridMessage: "No reports for this day", data: index(local!reportsPerDayOfLastSevenDays, local!selectedDay), columns: { a!gridColumn( label: cons!LABEL_NAME, sortField: 'recordType!{8360b17d-94c9-478d-af7a-8e685ada463b}LNU Rep Sched.fields.{f

Hi,  I need to get all the email addresses of the users in the application. I need this list in the dropdown field. Can someone please help here?Thanks in advance!

Do we have any possibility of writing merge custom cells using write to data store entity, Firstname, lastname, city and state are fields from DB. I want to write Name and address but name column should be a merge cell i.e. A1:B1 , same goes with address column. We have the possibility of doing this with the template i.e. keeping this template. But what if, we dont want to use a template then do we have any option.

Hi All, We are facing issue with Export to excel. while exporting we are not  getting data in to the excel sheet we have nearly 350 records only still we are facing this issue.If we give any filters then it is fetching the data otherwise it is exporting with no values in excel.Please find the screen shot How can we resolve this? please provide suggestion

You need to create a record type with data sync enabled. What are the supported data sources. Options:- A- Web services, Salesforce, Database B- Web Services, Process Models, Database C- Salesforce, Process Models, Database

Hi, I have a requirement of sending documents (filetypes like pdf, jpeg, xlsx, docx, ppt etc) from Appian to external system (AWS API) through integration object, so I want to know what is the maximum file size I can send it through an integration object. I have read in documentation that Appian supports file upload up to 1 GB, so will Appian supports sending file through integration object up to 1 GB as well? Also, if I want to upload a 1GB file through an uploader component, how much time the component will take to load the file into the interface from users local system. Will the users session be active till the 1 GB file upload to the interface completes? Thanks.