Foundation

Hi Appian DevsI have a situation here to explain, please look at the two interfaces below:Interface 1: Add new templateWe can add new template here,I have to validate my text field which is "Template Name". In this, I have called a expression rule where the name of all templates is being fetched from the database. And then, I am able to validate it by checking if the text filed value input by the user does not already exists in the database or not. Case 1: Add New Template: The validation is working fine for the new addition of template.Case 2: Edit Template from template dashboard: In case of edit, the value of the text field is coming pre filled from the rule input. So, even if I change it to a new value, I am not able to validate it for already existing templates using the expression rule.Can you please suggest me a method to streamline the edit case.

I have a document with 10 pages and I was able to extract pages 1 to 4 using Extract PDF Pages smart service (Start Page = 1 and End Page = 4). The new PDF which got generated has 4 pages. I would like to know whether there is any functionality / service available which would allow me to extract only pages 1 and 4. The new document generated should be having only 2 pages.

Can someone explain what's going on here?  If I try to get the output for the following string:  fn!char(65020) & " 21,245.00" the result I get is:  ﷼ 21,245.00 however if I try to get the output for the following: fn!char(65020) & "ABCD" the result I get is:  ﷼ABCD Can someone explain to me why it's essentially the same expression, but the symbol is on the right with the number and on the left with the letters?

Can we assign a task to a group or to a particular member through interface without using the process model??

I have a requirement where in interface m showing a field in a grid which is not part of CDT . But when I generate document it can only take fields passed in CDT.so I need to pass this extra field as well in excel . Is there any way I can pass the extra field value to the excel

Hello, Any one familiar with this type of error? An error occurred in executing an Activity Class. Log information: 2022-04-05 01:01:31,051 [ThreadPoolTaskExecutor-11056] ERROR com.appiancorp.process.workpoller.WorkItemListener - The following exception occurred while attempting to complete work item [[WorkId: 360, EngineId: execution02, Request: UnattendedJavaActivityRequest:10705 as svc_appian_prosvc_axxxddro_devops by svc_axxx, Response: null]] - Exception: javax.resource.spi.work.WorkCompletedException: java.lang.StackOverflowError    at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:247)    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)    at java.lang.Thread.run(Thread.java:748)Caused by: java.lang.StackOverflowError    at java

Interface Definition: Expression evaluation error in rule 'kt_qry_getanalystassignmentreport' at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [KT_VGenerateReportAnalystAssignmentDT23979], query: [queryentity expression], order by: [[Sort[NtdId desc]]], filters:[null])

Hey Guys, I have a process  model pictured below to reassign tasks. I am using a recipe that I created in a previous app that worked. This process model appears to work flawlessly. The reasignee and task id are updated and stored into their process variables correctly but the task simply isn't reassigned. No errors are thrown and the process model completes without stalling  or failing on the xor gateway or the reassign task node (these are the only two nodes). I have literally nothing to go on since there is no sign of any error. Just that the assignee for the task in the process report simply does not change as it should. 

Hi readers, I have a code for an interface which is working one way but it is not working in another way would like to know the reason  attaching the initial code and final code Initial code: Issue facing in lines 71 to 101 a!localVariables( local!QueryVMId: rule!IV_QueryVMDetails().VM_ID, local!QueryVMName: rule!IV_QueryVMDetails().VM_Host_Name, local!Temp: null(), a!formLayout( label: "Add New Server/Node", contents: { a!cardLayout( contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "VM_Name", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!QueryVMName, choiceValues: local!QueryVMName, value: local!Temp, saveInto: local!Temp, searchDisplay: "A

Hello All, I have an XML generated and based on a valid XML tag I need to display the data. «[#if doc.xml.A1 == "true"]» «@before-row[#list doc.xml.good.A2 as l]«${1}» «@after-row[/#list]» «[#else]» «@before-row[#list doc.xml.good.A3 as l]»«${1}» «@after-row[/#list]» «[/#if]» In my case the If condition is not working when called from DOCX template which is called from a DOCX From Dynamic Template through a process. I need to should 2 rows, but in the document it always shows 4 rows. Can anyone help to check conditional logic is correct? Thanks & Regards Girish

Hi, i have two dropdown field, when i select one some values related to that dropdown will be selected in next dropdown.. but after selecting values in both the dropdown when i try to change the value in first dropdown it throwing the error.. actually it has to erase the value in second dropdown and show the values to select  below i have attached the code and the UI this is the UI for ex: when i select stand-by lc and related detail i have to select after selecting the detail if i try to change the collateral type then it is giving error  when i try to change the collateral type then detail data need to erase how can i achieve this   a!dropdownField( /*label:"Collateral Type"*/ placeholderLabel: cons!CR_APP_TXT_PLACEHOLDER_VALUE, choiceLabels: touniformstring( rule!APN_distinct( index( ri!crREFCollateral_cdt, "collateralDescription_tx

Hi All, Facing this issue for particular users when using a process model as a link for an Interface card component. The error is . I am using it in a card in the interface Kindly Help. Thanks in advance

Hi All  In an editable grid we used a text field as a time enter field . Currently we want to do validations as follow in the text field 9:02 AM in the editable how to achieve this scenario.

Hello , I am confused with the sending of messages. I want to send a message to a specific instance, I don't want to send a message to all instances of a process model. The only way I found is creating a condition in which I evaluate if the instance that I pass as a parameter is the instance that I want to receive the message. For me this is not very efficient because all active instances will evaluate that condition to determine if the message is equal to the current instance.

Hello people! I hope you're doing well. Is there any way, video or documentation, where I can learn how to create a login page for my Appian ACME (Community version) Site?  For example, there is my site link like this:  But looks like an Appian login, not the ACME or my site custom login page.  Question 2, this means that if I create a user in my Appian ACME site that user will be allowed to access to the ACME Site? Thanks in advance! have an excellent day.

Hi, I have 2 tables pen and animal table , when i am adding the animal i am assigning the pen to the animal and the pen name are coming from pen table, i want to restrict user to add "3rd" animal if i have already set the capacity of pen to  2 animals only in pen table , any suggestions? while adding animal user should get the alert mst or validation like " pen have capacity of 2 animals only select diff pen".  

Hi readers, I would like to know if this is possible, i have a interface where it has a drop down which should have list of values from record types. example:  In the below table when entering data into Table-A it would be in a normal way; But when entering data into Table-B we need to enter ID_A as well right, So i am thinking to keep a dropdown in this place, where i can keep the list values present in  ID_A Table-A Table-A is as below ID_A(PK) Job_Role Company_Name 1 DBA ABC.ltd 2 SysAdmin ABC.ltd 3 HR ABC.ltd Table - B is as below Member_ID Name Phone_Number ID_A(FK) 1 SSR 1234567890 1 2 RC 0987654321 1 3 NTR 6789054321 2 4 RRR 1234567098 2 5 MB 0984562348 3

Hi, I am trying to use startProcessLink in a grid view Interface so that an user can edit the selected record by selecting a location Name. This is my first time using this method.  When I am selecting an entry, I am getting an error message:  An Error Has Occurred No process parameter found corresponding to override [name=pv!locationId]. Non-parameter process variables cannot be overridden. a!gridColumn( label: "Location Name", sortField: "description", value: a!linkField( links: { a!startProcessLink( label: fv!row.description, processModel: cons!BC_PM_ADD_LOCATION, processParameters: { locationId: fv!row.locationId } ) } ), My process model is working fine. So how and where do I fix it?  Please advice me.  Thanks

Hello good, I would like to know what is the difference between executing a thread in an end event node and executing a thread with the smart service start process and then terminating the process.

Need to use "Text Doc From Template Smart Service" for exporting more than 300 columns data from a table. Can anyone help me out how to configure this smart service and use it in PM which will give data in csv format or excel format.

Hi Appian Team, We have a functionality to save the data from the interface to the database where we are not submitting it to the parent table, but a temporary table or cdt and use the same process model as the submit and add the nodes for temporarily saving feature like save as draft. Basically customized "Save as draft functionality". Can anyone help us to implement this functionality , if you have come across similar features in any of your application. Thanks Sunu Sam

Hi All,     I want to write the logic for the below requirement  For example: ------------------ My Input is 1  Output should be : {2,3,4,5}    can  anyone share the logic  Thanks in Advance!

How can I assign a default value to a radio button and make sure that value is saved even if the user doesn't interact with a radio button component? for instance, if I have local!radioButtonDefaultValue: false I see that the No label is selected, when value field of the component is set to local!radioButtonDefaultValue but the value itself isn't saved automatically unless the user interacts with the radio button component. I want to save the false value even if there is no interaction with the component.

Prereq: Site, tested in Chrome and Edge. My use case starts in a site as the main user landing point. From here various actions and a pair of reports are presented to the user. Depending on the user's screen resolution the initial landing page may or may not scroll. Given the user has scrolled down the page, when they click on a task link (from a task report for example) the task opens up within the site framework but is not at the top of the task, instead, the interface retains the previous scrolled to position. This has been observed where the target form has been constructed in either formLayout or in headerContentLayout constructs. I cannot find a way to force the vertical page position back to the top of the form. Can anyone suggest a solution?

Hi All, We have data stored in our DB in text format. But data added can either be text or json. We would need to display the same in the interface in proper format. That is if data is in plain text we would show it as text and if it is in JSON, we would need to format it and show. For eg : if data is stored as "XYZ" then we would show either in Rich text editor/text field as XYZ. If data is stored as text (in actual it is a JSON) -  {"Field1":"Test","Field2":"value is "not editable" test it.","Field3":"314146282515","Timestamp":"2019-06-19T11:05:23.678+0000","Field4":"XYZ","Reason":"XYZ","Time":"2022-02-19T05:09:26.046+0000","Field5":"ABC","Field6":"yui","Value":"OK","Action":"","Field7":"[abcged]","Field8":"&