Foundation

i debugged a process but it keep running for infinity and filling the database with the same row

I am trying to add an existing attachment dynamically to the "Send Email" task. These attachments were previously uploaded to the application and the attachment name and document are stored in a table. I have added documents previously that were static and had a constant name. Thank you for the comments.

Hi Champ, I need to have a checkbox where I need to show the hyperlink like below. Can it be possible? Regards, Ghanshyam

Hi, I have below kind of interface (editable grid) to upload multiple documents. By default, I am providing 1 row and when user click on "Add Document" I am adding additional.  I have a rule input which is of CDT like below I was able to insert "Document Type" value to DoCTypeCode and "UPLOAD" to DocumentID. But, I was unable to inert values to "DateAdded" and "AddedBy". I have to store "DateAdded" as loggedinuser() and "AddedBy" as now(). Is there away I can load default values into these columns in the page load or when the user selected "Document Type" dropdown. Thanks.

a!localVariables( local!additionalInfoRequired, local!cancelled, a!formLayout( contents:{ a!checkboxField( labelPosition: "ABOVE", choiceLabels: {"additional Info Required"}, choiceValues: {true}, value: if(local!additionalInfoRequired, true, null), saveInto: a!save( local!additionalInfoRequired, if(isnull(save!value), false, true), a!save(local!cancelled,false) ), ), a!checkboxField( labelPosition: "ABOVE", choiceLabels: {"additional Info Required"}, choiceValues: {true}, value: if(local!cancelled, true, null), saveInto: a!save( local!cancelled, if(isnull(save!value), false, true) ), ) }, buttons:a!buttonLayout( primaryButtons:{ a!buttonWidget( label:"Submit", submit: true ) } ) ) ) Hi, My requirement is when I check one checkbox, another checkbox

Hi Appian Devs,I have long length dropdowns in the interface belowPlease let me know what is the probable reason of this error on the interface.Thanks in advance

Hi!, I´m having this error: The save target must be a local variable that does not refresh on every evaluation or on an interval, a process variable, or a node input (or a rule input passed one of those three) I´m trying to start a process with start form interface in a  a!startprocesslink inside a button. Any posible answers? Thanks

Hi, is their any other alternative to between operator? bcz am querying data from db.. giving different o/p in UI same query i have used to query the data from UI so  a!queryFilter( field: "expiredDays_int", operator:"between", value: {rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 1 ).startIndex_int, rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 31 ).endIndex_int

Hi all, My question is: What kind of field would you use in an Appian interface to display [but not allow editing] of a field like "created by" and "created date" that you want to display but not allow user editing - such that the data from these fields is actually stored into the database. Details of issue: My colleague and I are fairly new to appian development and are working on a problem. She created an interface that that allows us to add and edit the rows in a particular reference table. The interfae [mostly] works - in that it allows you to add and edit rows in the database table. The problem we have however is that there are some fields, which are not supposed to be directly edited by users. For example: "Created by""Created date" Rather than the users adding values for these fields, we want them to be automatically set by the system by retrieving the currently logged in user and the system date. My colleague has been able to set the fiel

Hi, I am working on a process model which has a Create New User smart service and in that smart service, there is an option to send Account creation email which when turned on sends the user an email with Temporary credentials with predefined content. My current requirement is to change the content of the email. Is there a way to change the content present in Body of the auto generated Temporary Credentials email sent from Appian?

So I am working on filling up my information in an interface that later will be saved and it will turn that interface into a read-only interface so I can see all my user information. The issue is that once I press submit, the interface doesn't update the fields from each section of the interface until I press refresh on my browser, is there a way to update those fields when I change it into read-only or make the site or page refresh?

Im new to Appian, first step i want to create in my app is a login page, can anyone help me on this Help me to create a simple login page with user authorisation, error message if wrong user id and password or if user id is not created in the app.

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.