Foundation

Hi All, I have a parent process A where I have wired another process B as a sub process. When I look at an instance of process A, I can see that the start process node takes 11 second to execute (I am looking at the process node > response time in the process details tab). When I look into the instance of process B, I can see that the response times for each and every node does not add up to 11 seconds (adds only up to 7 seconds). I would assume that in this case, the response time for individual nodes should be added up. Does anyone know how does the calculation of the response time is done? Thanks, S

Can we execute VB script in Appian? Is any type of custom code execution possible in Appian? If not what are the workarounds? 

is there any way to create an record type without Primary key ? As i am getting the data from web service

I had created a process model to add employees, leave request, and leave approval. in leave approval, it doesn't get the employee id by itself. I had configured everything. it is showing an error in the expression rule... that the value should not be null... the value is not null at the table... I had checked with the expression rule... it gives the data by entering the id...  but here its showing error.

Hi Community, I got an issue regarding "Export to Excel" button in the record type. The button is clickable but no action happens. However there are 16,000 rows there and the source is data type. Also, it happens to some users but it fails for me. We are all using chrome (although I checked Microsoft Edge and it is the same). Could anyone suggest a solution please ? Thanks in advance.

I have a custom VB script which I need to execute using Appian. Does Appian have resources to do so? What are the steps I need to take to execute the script?

Is it possible that when authentication with SAML is successful, it triggers a process or a rule where any type of logic can be applied using the user's information?

i am creating record type (Source as web service )Also Created one expression rule as written in code snipet a!localVariables( local!result: rule!JTV_intCustomFieldsGET(), local!rows: if( condition: index(local!result, "success", false), valueIfTrue: local!result.result.body.values, valueIfFalse: {} ), a!forEach( local!rows, a!map( projectId: index(fv!item, "projectIds", {}), customFieldName: index(fv!item, "name", {}), customFieldId:index(fv!item, "numericId", {}) ) ) )But it returns output like this by doing like this project id will be blank in record type or i have to to join array to make it comma separated in record type ..... But out put required is like  MapprojectId 18800(Number (Integer))customFieldName"2nd Outreach"(Text)customFieldId28306(Number (Integer))MapprojectId 12405(Number (Integer))customFieldName"2nd Outreach"(Text)customFieldId28306(Number (Integer)) MapprojectId 11000(Number (Int

I have a process model that opens an interface to "update a request."  I called the process, passed the parameters and the rule expression to fill the form of the previously entered data which the user is going to update. when i click edit, the interface shows up , but when i click next or cancel or any other button, it says " Action completed "  and then closed the interface and returns to this page.  Next or cancel are not the end of the form , next is supposed to take me to the next slide,  and the button works perfectly on the page that i am calling using the process model.  "Next" is supposed to take me to the next slide to make the user update the data. 

I am getting this error screenshotted above when trying to click a link field setup for editing/updating a user. I will show the block of code from Line 52 and on within TB_QE_getPodCodes that it says it is complaining about. Does anyone know why this might be occurring or point me in the right direction? Thanks in advance! a!queryEntity_22r2( entity: cons!TB_ENTITY_PODS, query: a!query( selection: if( a!isNullOrEmpty(ri!selectionList), null, a!querySelection( columns: a!forEach( items: touniformstring(ri!selectionList), expression: { a!queryColumn(field: fv!item) } ) ) ), logicalExpression: if( not(local!checkAllFilterNull), a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(field: "id", operator: "in", value: ri!id), a!queryFilter( field: "podCode",

Hi All , In the attached Screenshot, two values are shown for the project ID, and I want the custom field name to repeat itself twice and the custom field id to repeat itself twice as well.  I've added code snippet to what I've currently written for reference  and  Output should look like this  map project id  list of number(integer)-2 items   18800 (number(integer))    12405 (number(integer)) customFieldName  list of (Text)-2 items    "2nd Outreach" (Text)    "2nd Outreach" (Text) customFieldId. List of Number (Integer) -2 items    28306 (number(integer))    28306 (number(integer)) a!localVariables( local!result: rule!LGH_intCustomFieldsGET(), local!rows: if( condition: index(local!result, "success", false), valueIfTrue: local!result.result.body.values, valueIfFalse: {} ), a!forEach( local!rows, a!map(

Hello, We have Rich Text Editor to take input from user which can contain special character . We are using stripHtml() to get the text and later on we are comparing the text with Regex to show validation on RTE.The issue we are facing with stripHtml() is that it is leaving some characters as html encoded in the returned text. But we require the character itself.How can we handle such case for all the special characters? For reference -In the output, the special character ( š ) is coming as html encoded whereas the other character which  is <, can be compared using regex.We need the output as - "š<"How to handle all the such characters which will be coming as html encoded? Is there any other function which we can use to achieve the above result ?

While executing PM i am getting error how can i resolve ?a!localVariables( local!currGrantWorkflow: rule!GAI_getWorkflow(workflowId: ri!workflowId).data, local!refDecTree: if( rule!SCO_isBoolNotEmptyAndTrue( local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{5febe064-3783-49f6-ac2c-1f69ce22e5b5}isCustomWorkflow'] ), null, rule!GAI_getRefWorkflowDecisionTree( currStatusId: local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{7cd66171-e9d3-45ae-9967-fe88fbd9f594}fkWorkflowTypeStatusId'], taskDecisionId: ri!taskDecisionId ).data ), local!customDecTree: if( rule!SCO_isBoolBlankOrEmptyOrFalse( local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{5febe064-3783-49f6-ac2c-1f69ce22e5b5}isCustomWorkflow'] ), null, rule!GAI_getCustomWorkflowDecisionTree( currStatusId: local!currGrantWorkflow['reco

Hi All, I have a requirement to upload attachments to a target folder location and assign them before perform submit on UI screen. Is there ant way I can achieve this? Thanks in advannce.

Hi everyone, I would like to export my app from dev to prod environment. In the 2 different environments there is a folder with the same name but containing different files. I would like to delete the current app in prod and replace it with the updated version of dev, but keep that specific folder that already exists in prod, then replace the same folder of the app imported from dev to prod with the files I need, keeping the same UUIDs of the documents contained in it and also the other information. It can be done? Or can you download a folder from a specific development environment on the local PC and then upload it as a zip file to the desired environment without changing the uuids? What is very important for me is that the uuids do not change. Thanks in advance

i want to highlight these two duplicate values when a user enter a duplicate value. Please suggest me validation code.

Hi Team,I have a few doubts in start node triggers. My requirement is to trigger a process model when certain conditions are met. So, what we are doing is we created a interface for users to schedule the process when to occur. we storing the date & time in separate constants. Try 1: then in the process model start node trigger we added a time recurrence to daily and it's time to value from the time constant = pm!timezone and checking whether the date constant is today or not in timer conditions (advanced options) and delay to 0 mins. each time after the trigger the process model will update the date constant to future date. Issue: working for the first time only(while publishing) after the constant update its not working.Try 2: process model will trigger daily at 00:00 , a xor to check whether its today or not, and a script task with scheduler (delay until the datetime mentioned in the constant). Issue: if the user sets the schedule to 06:00 but trigger star

In my "Request " CDT  , i have a field named "branch" of type number.  I am trying to display the branch ID  on the interface , from the query "GetRequestData".  value: rule!GetRequestData(ri!documentID).branch, ri!documentID holds the ID of the request.  when I test the query it returns the data correctly, but on the interface it doesn't show. when i debug the process model it shows ((Cannot index property 'branch' of type String into type List of Variant))  i don't quite understand the error message. how can i display it correctly ?    

a!localVariables( local!selectedPermission, local!selectedArea, local!selectedComponent, local!selectedDepartment, local!departments: a!refreshVariable( value: rule!MECMS_getDepartmentList(activeFilter: true), refreshOnVarChange: { ri!refreshInt } ), local!area: a!refreshVariable( value: if( rule!APN_isBlank(local!selectedPermission), null, rule!MECMS_getRefArea( selections: {"id", "value"}, permissionId: local!selectedPermission, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ).data ), refreshOnVarChange: { ri!refreshInt } ), local!component: a!refreshVariable( value: rule!MECMS_getRefComponent( selections: {"id", "value", "areaId"}, areaId: if( a!isNotNullOrEmpty(local!selectedArea), local!selectedArea, if( rule!APN_isEmpty(local!area), -1, local!area.id ) ), pagingInfo: a!pagingInfo( startIn

I have created a PM to get Json data, next I have created a webApiPost Start Process, I have tested the request, status code:200, after filling the body {} with json data, is passed to a process variable. But the purpose is to store all the data with mutliple table, through one CDT.

How I know what are the new objects come in Appian 23.3 and 23.2 versions  Please share me docs.appian.com page link for new release of 23.3 and 23.2 versions

I have "requestID" as a foreign key in 2 tables "attachment" and "Document"  i passed it as process variable through a task script. When i debug the process it works but it saves the foreign key "Null".  what might be the reason? 

Hello  How to pass the Values of the local variables to the Docx????   a!localVariables( local!data:ri!DocData, local!name:rule!SKJ_GetCustomerByAcc(AccountNum:ri!Number), local!resonDes:ri!resDes, /*to collect the data*/ concat( /*Parent */ "", /*Name*/ "", local!name['recordType!{a0871cca-bd3d-4d03-b9ce-d1652bfa9dc0}SKJ Customer.fields.{b06eb39c-bf2f-4bb4-b283-cdbb894e406d}name'], "", /*Reson Des*/ "", local!resonDes, "", "", datetext(now(),"yyyy/MM/dd"), "", /*for each*/ a!forEach( items: local!data, expression: "" ), "", ), )

Hi, Please suggest some links or videos where i can learn how to create Suite page, test page and what is significant. how to maintain test scripts  for an applicaton. Thank you in Advance.

a!localVariables( local!maxData: a!queryEntity( entity: cons!ISP_DSE_CAPACITY_CONFIG, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "startDate", isGrouping: FALSE, aggregationFunction: "MAX" ), a!queryAggregationColumn(field: "distCenter", isGrouping: true), } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "distCenter", operator: "=", value: ri!dc, applyWhen: a!isNotNullOrEmpty(ri!dc) ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: false ).data, local!date: tostring(index(local!maxData, "startDate", null)), a!queryEntity( entity: cons!ISP_DSE_CAPACITY_CONFIG, query: a!query( filter: { a!queryFilter( field: "startDate", operator: "=", value: local!date, applyWhen: a!isNotNullOrEmpty(local!date) ), a!queryFilter( field: &q