New to Appian

I want to show record when task status not equal to  1,Completed 2.Rejected 3.Cancelled should I used or () , or  not() conditions. I think or() should apply because at a time only on status come in task status not all status come

I am new to Appian. I cannot get the test result: :the cage field in the RPT_CAGE_Info variable contains the CAGE string returned by the robotic task   after finished the step "Add the Execute Robotic Task node" in the process model which is the step before "Add an XOR gateway" when following online training docs.appian.com/.../tutorial-retrieval-process.html .  I have checked all possible causes, but no idea. Your advices and suggestions how to debugging are very appreciated!  This is the result I got in PM history        

I am trying to explore the AI Skills option to extract a PDF document , While doing this I am using a!docExtractionStatus(pv!DocExtractionId)  to find the status of this extraction , it always comes as Invalid status  as i feel the id returns as text  459e03db-62f5-4a7c-bb96-9047e4391783 , Where as method used to find the extraction status looking for number how to change this  type and find the extraction status ? 

How I get download file name in interface

Hi, I want to fetch email address of the user, based on first name and last name. 

When I upload more than one files and then going to download thes files .only first file is downloading not all files are downloading. what sould I do so that all uploading files are able to downloaded................. code:--- a!localVariables( local!docData:rule!PM_getAttachmentDetailsByReqId(ri!requestId), local!docId:index(local!docData,"docId",null), local!attach:index(local!docData,"attachmentId",null),a!gridField( labelPosition: "COLLAPSED", emptyGridMessage: "No activity entries available", data: local!data,a!gridColumn( label:"Details", sortField:"details", value:a!richTextDisplayField( value:{ a!richTextItem( text:{ a!richTextItem( text:fv!row.details, showWhen:if( fv!row.action=cons!PM_TASK_NAMES[3], false, true ) ), a!richTextItem(text: "Download Attachement File :" , showWhen: fv!row.action=cons!PM_TASK_NAMES[3]), " ", a!richTextItem( text: a!richTextIcon( icon:"download" ), lin

Hi, I have a old CDT sno|sname 1|qef 2|abc I should create a grid field showing sno by default and enter sname against sno which needs to input by user. I should provide a validation on sname field if value provided is not matching with old CDT. How can I achieve this..

click on card not working in FitNesse 23.2.1. I would like to know what's changed with it.

hey! i am working with a selectable grid , when i select a row , i want to show one of the fields (currency) in in an intFeild, but the currency value is taken from another table(Currency Table), and then called using the relationship between the (Account) and the (SKJCurrency) tables, how do perform that using the index function, I tried using index twice but that didn't work.  If using two index is not possible , how should i do that ? and what's the right synatx , i cant find any exampls and i need to fix this issue asap. /*The Grid field where i called the currency table*/ a!gridColumn( label: "Currency", value: fv!row['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.relationships.{a0795917-dbcb-4e87-8928-253944204ea6}skjCurrency.fields.{de6af13f-a763-462f-9369-8cd8bbbf1075}descAr'] ), /*The int Fiel

HI,  I have struck at a point... I am working grid field, I have provided links for two columns in the grid field, By default column 1 link was enabled when I clicked and submitted data column 1 link had to be disabled. and the column 2  link has to be enabled After submission of column 2 data, the column 2 link also has to be disabled... Help me with a sample code  

While saving the process variable data in script task getting following error: Error writing to process variables (rank, for variable 'pv!sectionfieldmapping'., type, for variable 'pv!sectionfieldmapping'.) (Data Outputs)

How I make link for any page of my project . These are below  interfaces . I am in MyRequest page. How i visit to  last "Task " interface page from MyRequest page Work.....My new work.....My  task.....Task . "Work interface" is parent interface then "My new Work" is inside  the Work interface.Then "My task" interface is inside the "My new work" then Last "Task interface " inside "My Task" interface Ther are not in Records....

Hi all - I'm trying to create multiple rows in my record, using data that is stored as an array process variable.  But i'm getting all the data in a single row.  Could use some guidance. Here's what I've got: 1. My process calls a business rule which gives me the following output: List of Text String - 3 items "Asset Transfer"(Text) "Disclosure"(Text) "Identification"(Text) 2. I've tried storing both in a record input as well as a process variable, those fields look like this: 3. I'm using Write Record and would like to create one row for each of these, but instead I get one row with that exact list of strings. How do I get one row reach each item? Thanks in advance.

I am very new to appian , I am trying to calculate the value of " To Date field "  and show the date in the calendar , I want to add the number of days that i saved in the local varibale (local!days) to the current date to find the new date , how can i do that?  Here is what i wrote for the " days" field  a!integerField( label: "Deposit Days", labelPosition: "ABOVE", value: a!match( value:local!periodtype, equals: 1, then:{local!days}, equals: 2, then:{if(not(isnull(local!weeks)),(local!weeks*7))}, equals: 3, then:{ri!numberofmonths*30}, equals: 4, then:{ri!numberofyears*365}, equals:null, then:{false()}, default: then:{false()} ), saveInto:{local!days,a!save(local!despositdays,local!days)}, required: false, disabled: a!match( value:local!periodtype, equals:1, then:{false()}, equals:2, then:{true()}, equals:3, then:{true()}, equals:4, then:{true()}, equals:null, then:{false()}, default: then:{false()} /*DAYSSSSSS CODE */

What is the difference between a!queryRecordType()  and a!queryRecord(). In which scenario  I will use these  two...

I am a new bie into APPIAN.would like to know how  we can create CDT and access the COlumn from DB

when I used a!pickerFieldUsersAndGroups() in filter .It gives error during selecting Group  Error:-- cannot apply [EQUALS] to field [assignee] when comparing to value [TypedValue[it =5,v=414]. what operator should I used for it

Hi, I have multiple sites inside Appian and whenever my session is expiring and when I click on "Return to Appian" link, system is always routing to same site. Is there a way I can configure and ensure it will route to the respective site.

I have a requirement to copy data from one user form to another. If a user has made one order, it is saved in the database. I need a functionality where I can use the saved order's data to be copied to another form. Does anyone know how can I achieve this functionality?  Example would be very helpful.Thanks

Hello, We are installing a freshly new windows appian installation and when trying to generate the temporary licence to finish the setup we get the below licence error :  No k4.lic file exists. Any ideas ? Thank you

Hi, I want to put a condition that text field only accept Hebrew charecter, I tried to find correct regex to validate hebrew text, but did not find. Please suggest where can i find regex for hebrew text or is there any other way to do the same. Thanks & Regards, ShreeKrishna Tiwari 

I'm trying to add a section to your interface that will only display when the user selectsa maintenance request, and will display details for the selected request by repurposing anexisting interface object & this is the code. I'm getting syntax error mentioning "Expression evaluation error at function a!localVariables parameter 3 [line 63]: Invalid list operator 'a!sectionlayout' (expecting comma)" but all Parentheses are closed properly & commas were added as per syntax. How can I fix this ?

Hi All, How can we compare two text values for example "batting" is text1 and "bat" is text2 if batting compare with bat then it should write True. because bat word is there in batting word Is there any logic for this ?

Hi Team, What data type should be used if I want to store the data like this id,users 1, user1 2, user1; {user2,user3} 3, user1; {user2,user3}; user4 Operations: We can remove the users from list input: id, username -> 2,user1 output: 2,{user2, user3} input: id, username -> 3,user3 output: 3, user1; {user2}; user4

HII, I am getting an error when executing PM like :The entity name must immediately follow the '&' in the entity reference. i am using docx from dynamic template plugins[View:/cfs-file/__key/communityserver-discussions-components-files/62/DocTemplate.docx:320:240] I have attached my doc template  and code if( a!isNullOrEmpty(ri!appId), {}, a!localVariables( local!application: rule!GAI_getApplication(applicationId: ri!appId).data, local!fiscalYear1: local!application['recordType!{5f640b2a-afca-4569-92d3-9e2938c52816}GAI Application.relationships.{abdf1474-5557-4307-87ca-cebf6144aab0}gaiOpportunity.fields.{8140c1d1-fe02-45b1-b6bc-53f76502fad9}fiscalYear'] - 1, local!fiscalYear2: local!application['recordType!{5f640b2a-afca-4569-92d3-9e2938c52816}GAI Application.relationships.{abdf1474-5557-4307-87ca-cebf6144aab0}gaiOpportunity.fields.{8140c1d1-fe02-45b1-b6bc-53f76502fad9}fiscalYear'] - 2, local!fiscalYear3: local!application['recordType!{5f640b2a-af