General

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 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 )

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 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

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?

Hello All, i am trying to filter the record which has been created in the 1st half of that particular month. So basically,  I have a record with a column "Created on" (Data type). on this column, i have to apply the filter to get the records which have been created in the 1st half of the month. For eg. if record created on "11/10/2023, it is created in the 1st half (Before 16th October and so on.

Hi I need to implement a use case, where I implemented links to view document and download document links. So that, I can capture the user response and use it for audit purpose. Like how many times document is viewed and how many times document is downloaded.  When user clicks on view, I have used documentViewerField and users can able to view. For pdf documents, users can download the document from the pre-defined options on the component. Like (download, print) etc.  Is there any way to hide those options? Like disable download or disable print option.  Kind Regards Rahul Gundu

Hi my query is working fine for the last 9 months and now it is showing errors as below: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DetailViewDT3872], query: [queryentity expression], order by: [[Sort[AccNumber asc]]], filters:[null])  I built a new constant and it still did not work. Could you please assist why it is starting to show this error and how to fix it? this is my query: a!queryEntity( entity: cons!Detail_View, query: a!query( selection: a!querySelection( columns: {a!queryColumn(field: "AccNumber")} ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true ).totalCount

Hi Team, I am Looking forward to learn Advanced topics like data analysis and prediction Algorithms in appian by implementing the below Explained Proof of Concept (POC). 1.Data Analysis and Prediction of sales: The progressive stock control, quote to buy, and conveyance system designed for Organization XYZ utilizes data Analysis and predictive algorithms to upgrade stock levels in light of past sales and future forecasts. 2.Quote to procure: When goods become scarce, the system first investigates internally for spare parts, producing items if parts are available. If not, it autonomously puts in orders for spare parts with providers, assessing cost and delivery offers from numerous vendors to make an informed judgement. 3.Logistics: Once procurement is finalized, the system meticulously plans shipping, streamlining paths and techniques of transportation to guarantee on-time delivery of components. I need you inputs and suggestions to learn and implement this POC. Regards J

i have a use case, where i need to display two arrays - a before and after if you will. local!array1:{"Dog","Cat","Mouse"},local!array1:{"Dog","Cat","Mouse","Elk","Rat"} ideally i'd like to display them in a grid, so that the user see's a nicely formatted list - which I can then add some functionality too. Something like :----BEFORE---- AFTER-------------------------------------------Dog     ----- Dog -------------Cat     ------Cat ---------- ----Mouse ---- Mouse ----- ----NULL ------- Elk ------------Null ------- Rat ----------However / whatever i do, i keep tripping over that the gird only really wants to parse one data array. if i try using the two different arrays in the row then I soon trip over having different array lengths.Any ideas ? 

this error am getting, unable to figure it out

I would like to convert the following XML to a CDT. I have no problem capturing the values in Key, LastModified, and Size using torecord(). However, I do not know how to create a field in my CDT to capture DisplayName using torecord() since it is nested in Owner. Please let me the best way to get the data in this XML. <Result><Key>Mock_Doc.pdf</Key><LastModified>2023-10-06T02:19:06.000Z</LastModified><Size>38864</Size><Owner> <DisplayName>Tracy</DisplayName></Owner></Result>

What is Environmental Constant ?

Hi All, How can we avoid tabbing for Help Tool Tip. Like in a section layout implemented tabbing but this tabbing is also getting applied to the help tool tip of the text fields and drop-down fields, how to avoid this tabbing to those help tool tips. Any suggestions?  Thanks In Advance, Gousii

Hi Team, When Appian is down for maintenance do what will happen to the processes? Will they be queued or fail?

What is the right way to index a specific field?  im getting index error (Customer can only be indexed into using square brackets or the index function)   

 Hi team, Iam building a logic where i have two lists as listed below, now i want to check data[1] i.e, wifi Router Demand value 500 with all (5 items)count values in Items[1] . and same data[2] with items[2] with all 5 count values in items[2] and return the sparepart Names that are less than demand value. 1. data: [product=Wi-Fi Router, Demand=500, productid=]; [product=Wi-Fi Extender, Demand=7, productid=] 2.items:{ {{Sparepart: "Wi-Fi Module", count: 100, productid: 1}, {Sparepart: "Antenna", count: 100, productid: 1}, {Sparepart: "Power Supply Unit", count: 100, productid: 1}, {Sparepart: "Ethernet Port", count: 100, productid: 1}, {Sparepart: "CPU Chip", count: 100, productid: 1} }, { {Sparepart: "Wi-Fi Extender Module", count: 20, productid: 2}, {Sparepart: "Extension Antenna", count: 30, productid: 2}, {Sparepart: "Power Adapter", count: 15, productid: 2}, {Sparepart: "Ethernet

Good morning, I am trying to configure the Send Meeting Request smart service but it is giving me the following error: "Unexpected error. (APNX-1-8000-000)" and the configuration is as follows: From Email Address-->"prueba@email.com" From display Name-->"prueba" to-->"prueba2@email.com" Has anyone had this same problem? Regards and thank you very much in advance!