Foundation

can we create 2 scheduler's in one PM ?

I am getting the error: Details:  Invalid Cast: Cannot cast from type 'Document' to type 'Content Constant' (Data Inputs) When trying to replace the constant contents, which is a constant that is a list of Documents. How do I fix? It doesn't work for replace version yes nor no. 

Hi, I'm trying to replicate the image column in the Acme exercise. But this expression: if( a!isNullOrEmpty( fv!row['recordType!{99497132-80a2-4706-85d8-9d65360812d4}VehÃ%ADculo de W2690.fields.{664fc039-9187-4150-90ce-6d589788d0c2}image'] ), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row['recordType!{99497132-80a2-4706-85d8-9d65360812d4}VehÃ%ADculo de W2690.fields.{664fc039-9187-4150-90ce-6d589788d0c2}image'] ) Is showing me this error: "Expression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 87]: User Does Not Have Rights to Perform this Operation" What am I doing wrong?

Is there any built in functions or smart service to retrieve the list of table names, number of tables, number of columns in all table and the list of all columns in a table from Appian Cloud Database?

can some one explain why jpa annotations are mainly used in appian and tell me some scenerios where it is most useful

Hi everyone, Below is my code: Child interface grid column within gridField():  a!gridColumn( label: "", align: "CENTER", value: a!localVariables( local!showLinkClosedCase: contains( ri!chosenCloseCase, fv!row['recordType!A.fields.{caseId}caseId'] ), a!richTextDisplayField( value: a!richTextIcon( caption: "Close Case", icon: "calendar-check", link: a!submitLink( showWhen: not(local!showLinkClosedCase), saveInto: { a!localVariables( local!case: rule!QRY_getCase( id: fv!row['recordType!A.fields.{caseId}caseId'] ), if( or( a!isNullOrEmpty(local!case), contains( { cons!CASE_STATUS_CLOSED,

Hi Guys, Do anyone know if we have any replacement function for getgroupuuid(). This function was supported in plugin People function version 1.10 jar but now we need to update it to to 1.16.0 jar. I do not see the support of getgroupuuid() in version 1.16.0 as written in https://community.appian.com/b/appmarket/posts/people-functions---plug-in

I know this is a very basic concept and I predominantly understand the purpose of a Primary Key and a Foreign Key. But as I've been learning the concept of a Unique Key came up and I was unable to find a resource that gives me a clear understanding of the purpose of a Unique Key. I would love it if someone co explain the difference while comparing it to Primary and Foreign Keys potentially with some examples if applicable.

I am using this expression in process output to create cdt data but it while appending the value its creating one null record. How can i remove the null record in this expression.Thanks todatasubset( reject( rule!APN_isBlank, append( rule!NTD_generateGTComments( GTComments: index( pv!gtData, wherecontains( tointeger(null()), pv!gtData.CommentId ), {} ), taskAssignee: pv!taskAssignee ), rule!NTD_QRY_getGTComments( gtValueId: pv!gtData.gtfieldvalueId, activeFl: "A" ) ) ), a!pagingInfo(1, - 1) ).data

I am trying to update name and age in variable X using Y data. Code below  a!localVariables( local!Y: { a!map(id:1,name:"test1",age: "60"), a!map(id:2,name:"test2",age:"70") }, local!X: { a!map(id: 1, person: {name:"test1",age:"50"}),       a!map(id: 2, person: {name:"test2",age:"20"}), a!map(id: 3, person: {name:"test3",age:"30"}), }, { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Button", style: "OUTLINE", saveInto: a!save( local!X, a!update( local!X, { wherecontains( tointeger(local!Y.id), tointeger(local!X.id) ) }, { local!Y} ) ) ) }, align: "START", marginBelow: "NONE" ) }) But ended up getting this  , Can you please help me correct this, I only wanted to update the name and age inside person list for the id 1 and 2 

25th March 25th June 25th September 25th December for every year on these dates i have to send email, but how can i write the logic to check that send email in the table i have date column for that i have to check this date and send email  the requirement is - Email notificaiton to be scheduled to send where the  Callback comments are not given in every quarter(last 3 months). and System to check if callback comments are present in the last 3 months and make the list of those data and send email  to check callback comments are given or not from last 3 months we can use column updated on - on each time we write comment updating the date in updated on column

Hi  I have came across one scenario where the mail has to be sent to 57 users who were copied in BCC (using for each loop to get users and email of those users) while sending mail the process was errored at send mail node saying failed to send mail and checked in tomcat logs for reason there is no details in logs for error later from 57 i have split to half users and sent mail once and triggered again it worked and same i have done for second half of users it worked at a time for 57 users it didn't worked so could you please confirm is there any limitation of number of users if it was the case how we can handle this situation Thank you

Hi All,In some processes, we can see actor name coming as administrator and for some we can see its coming as the person who started the process. This is occuring for subprocesses. Any reason for this difference in behaviour? Where does this originate from??

Is there an advantage one over the other? In my current project, using the index with the dot is questioned as bad practice, requesting to always use the index() function, my question is, is this really necessary? what are the reasons? I understand that sometimes it is good to control the default value and set a null.

Hi, Users are getting following error after task completion on task page after submitting the task. This is happening intermitently. "403 Access Denied. You dont have permission to view this page." We are querying a task report and displaying Task list in an interface. User clicks on task link to get access to the task.  User accepts the task and submits the task. On Task submission, sometimes user gets this error. [Screenshot attached] No errors in stdout logs. Did anyone experienced this issue before ? If yes, whats the resolution. Thanks.

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. 

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 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

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 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!