Foundation

hi,  I have a custom check box written for my grid as i have nested loop , i a unable to implement the appian default selection check boxes.  here is the code,  a!richTextIcon( icon: "square-o", link: a!dynamicLink( saveInto: { a!save({local!selectedIndex},fv!index), a!save(local!selectedProcedure, append(local!selectedProcedure,fv!item)) } ), linkStyle: "STANDALONE", showWhen: tointeger(local!selectedIndex) <> fv!index, color: "SECONDARY", size: "MEDIUM" ), a!richTextIcon( icon: "check-square-o-alt", link: a!dynamicLink( saveInto: { a!save(local!selectedIndex,null), a!save(local!selectedProcedure, difference(local!selectedProcedure,fv!item)),} linkStyle: "STANDALONE", showWhen: tointeger(local!selectedIndex) = fv!index, color:"SECONDARY", size: "MEDIUM" ), This code actually , appends the index in the local!selectionprocedure  but when i unselect it , it actually removes the last

hi,  I have a child interface , that has a rule input just to update the data base. I am basically trying to select the rows from an editable grid and save them in this rule input which is not dependent on parent interface. it is handled internally in child interface.  Child interface rule inputs - ri!id and ri!selectedrows I am trying to configure this interface in the Landing Page ( Parent Interface ) , now from parent interface I wanted to pass only the id. how do I achieve it . I get an error, if I pass only id from parent .

Hello I've used the open task reports to get all the tasks assigned to a user, but the problem is if the user is assigned to multiple application they can see all the tasks in that report.Is there a way to show only tasks specific to application or specific to all the process models from that application and if you can provide some example would be much appreciated.Thanks in advance.

I came accross a behaviour where an appian object(integration) accessed by two different users having parameters data type in two different format Eg: user1 gets the data type format as "mm/dd/yyyy" and user2 gets the data type as "dd/mm/yyyy". Though their internationalisation settings are same and both users are accessing same object . What else could be the scenario for such behaviour? Above are images from two different users using the same objects.

Hi, We have on-premise environment. We`ve switched from Apache Tomcat to IIS as web server. Since then, when trying to open a site: .../suite/sites/hr-application/group/organization/page/employee-directory/record/...id.../view/summary we`re getting an error: DOCTYPE "... is not valid JSON appian Any idea, why this started / how to solve it? Kind regards, Nejc

When starting a process model from the web api, the process variable is []. Below I have attached the result for your reference.

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.