Foundation

Hi i am new to appian , I have been working on a activity where I have to generate document through ms doc from template smart service. This document generation was happening in a subprocess from there I am greeting the generated document id to parent process I am not sure whether this flow going right or not .Now I need to update this id to record for particular user like based on their profile id I need add this document which they will be able download through interface which will be another big task for a beginner . Can anyone guide me?

.

I have a record type list - saved in local!displayitems it has 9 items and i am displaying it in the grid when I select the rows in grid it gets saved in the local!selectedrow variable  now, i am doing some manipulation and updating few fields in the selected rows and then wanted to save them to the local!display items upon button click , here is teh code, can you tell me what is wrong , since displayitems is nested , i flattened it a!forEach( items:a!flatten(ri!displayItems), expression:{ a!save(fv!item[recordtype.fields.preparedBy'], a!update( fv!item[recordtype.fields.preparedBy'], { index( fv!item[recordtype.fields.procedureReferenceId'], ri!selectedrows[recordtype.fieldsprocedureReferenceId'] ) },{ri!selectedrows[recordtype.fields.preapredby]} ) ) error:

I am using Export Data Store Entity to Excel smart service node. Could anyone please let me know if there is any way that queried value can be inserted into custom cells where the text is "Pull from variable".

We need your suggestions/inputs to implement the following use case: - Send confirmation link in email to Appian user - Without login, when the user clicks on the link in the email, we need to update the status in the Appian database (without opening any Appian pages) Please let us know the approach to implement this. Also, let me know in case you need any other details.

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