Foundation

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

Hi when the process hits the Post comment to feed entry smart service it was errored out saying like below: An error occurred while trying to post a command or hazard to feed(entry id(1.840,280) Details: The supply feed entry (1,840,280) is not accessible (APNX-1-4181-100)  Kindly just on this

Hi Team, i have a user task which has to complete by a set of Users in a group. i used MNI in other tab for the task and selected as shown below but when i debug the flow its working same as group. i mean once a user is accepted this task. its completing. could you please help me in implementing  a user task which has to complete by a set of Users in a group(Everyone in the group have to compete the task )

I am trying to determine the shift based on datetime. Here is the use case: Shift 1: 07:00 - 14:59:59 Shift 2: 15:00 - 22:59:59 Shift 3: 23:00 - 06:59:59 However, it’s not working as expected according to the current code that I have ( Please see the attached screenshot) . The date in Appian writes with GMT adjustment  .

I am getting an Invalid Process Parameter error in my interface, and i made sure that the parameters have the same name and type in both process model and Interface. what might be the reason of this error ?  a!startProcess( processModel: cons!GeneratePDF, processParameters: { customerNum:ri!customerNum, descriptionReason:ri!reqDetails.reasonDesc, data:ri!DocDetails, }, onSuccess: {a!save( local!pdfId, fv!processInfo.pv.CreatedPDF )} ), 

We have a use case where we want to try and show a pop up in an interface, and then based on the action performed in that pop up we want to save specific values. For the pop up we're calling a recordActionItem in a recordActionField. Is there a way to pass values back out of the record action once it's been completed and access them in the interface? And is it possible to somehow call a list of saves in the interface after the record action has been completed as well? Thanks for any help!

Hi, I noticed that in write records it only saves primary key, what if i want to use other fields in next set of forms do i have to query record or there is a way ? Regards  Chandra

Hi Guys, What is the most effective way to do error handling for multiple parallel API calls while loading the interface. Currently My code look something like this. a!localVariables( local!users:rule!APN_GetUsers().result.body, local!items:rule!APN_GetItems(id).result.body, local!info:rule!APN_GetBasicInfo(id).result.body, local!summary:rule!APN_GetSummary().result.body, {} ) If one of the API fails I will show some error in card. But how to effectively do this ? I need to this in multiple interfaces. [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]

Hi there, I have the following information in a paragraph, need to send this information in the email body. in the "send email" smart service, tried this: substitute(tostring(pv!newComments), "cha(10)", "<br>"), it does not work, all the informaiton are in one line in the email body. could anyone know how to do it? thanks. L

When I click on the link in row in read only gird, I want to open the summary interfacebut the code does not work, what is the problem?

When I click on the link in row in read only gird (the data from cdt not record Type), I want to open the summary interfacebut the code does not work, what is the problem?

Hello Everyone , I have one issue in process model it saying  "Document Does Not Exist or has been Deleted) (Data Inputs)" we have added a condition like documents exist or not if exit we are taking document name by using Document() function . when we validate the document by using  getcontentobjectdetailsbyid() we are getting below result. "Content Object [Name: Bill.jpg, UUID: _a-0000eae4-0751-8000-9d71-011c48011c48_24018957, Parent: Temporary Documents Knowledge Center, Parent Id: 7, Type: Document, Latest version: 1, State: Invactive Published, Internal file name: N/A]" but I'm not able to find any document in MY KC. and it is saying "State: Invactive Published," what it mean and how we can fix this issue ? Thanks  Saikumar

Hello Everyone, Does Appian allows the user to upload any password protected document into its cloud instance?  We have a requirement to upload the password protected file but when we try to do it through File Upload field or simply add it as a document within the application objects, it throws the following error: "File could not be uploaded. Please try uploading it again" Note: We do not have any restrictions applied in our Admin console in the "File Upload" section. Thanks in Advance, Nandini

Im getting Cannot index type Number (Integer) into type (DOCUMENT_DETAILS) - which is a cdt.  local!indexNum is  just a local a!radioButtonField( label: "Radio Buttons", labelPosition: "ABOVE", choiceLabels:rule!SKJ_GetForm( {} )['recordType!{228c141f-e2f8-4a93-bf0d-0dfed8c9c6b4}SKJ Form.fields.{af4b3fdd-a9a3-4ea7-82d9-8f16e323e35f}descEn'], choiceValues:rule!SKJ_GetForm( {} )['recordType!{228c141f-e2f8-4a93-bf0d-0dfed8c9c6b4}SKJ Form.fields.{d69bf265-893b-4707-965c-3512e6e1c9bd}itemCode'], value: ri!DocDetails[local!indexNum].docForm, saveInto: { ri!DocDetails[local!indexNum].docForm }, required: true, choiceLayout: "COMPAC

i want to cover the black space below the comment with column. And when we expend the comment then column size get auto reduce. 

I have a grid column which should be displayed based on a condition. When the condition is true it will show a grid as below. and when the condition is false it should not show anything but instead it is displaying as below. I haven't configured anything to display something like this in the interface.  Can someone please help.

HI everyone,  I'm building a process model to write a record to record type table. I have two nodes for my process for now, one is script task and one is write to record. At script task node, I use a!map function and hard code data like below. When I start process for debugging, I get the error (key can not be null). However, my key has value. I wonder do you have idea how to fix it ?

Hi everyone, I have a column storing Date Time values but is now Varchar type in DB, eg. 2022-09-12 03:53:33 (varchar(19)). I want to format it to 9/12/2022 03:53 AM Any recommendation? Thanks a lot for your help :)

Deploying application first time from dev to test environment giving error in record type. Below is the screenshot. I have checked this record type is present in the deployment package but still showing missing precedents. Also, connected system is also part of the deployment. Do we need to deploy connected system individually first and then need to deploy rest of the package?