Discussion Categories

Hi everyone been struggling with this for a while, Is there a report or log that can return all process models in an application and the number of nodes associated with each? Thanks, Andrew

I am trying to navigate between 3 pages with a "next" button, i also need to highlight the circle that indicates the page i am currencly in ,  ex:   I declared a local variable for the "NextPage" and gave it a value, but it seems to be null ,  The error i am getting is " Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!stampField [line 47]: Cannot compare incompatible operands of type Number (Integer) and type Null." why is it not saving the value of the local "NextPage"? local!acc, local!requestDetails, /* Defines whether or not to collapse the side nav */ local!stampNav: false, /* The selected navigation section */ local!activeStampNavSection: 1, local!NextPage: 1, local!MaxPages:3, /* The navigation sections */ local!stampNavSections: { a!map(name: "Customers Details", icon: "user-circle"), a!map(name: "Request Details", ic

so i  have a requirement. here can see for the collateral type and description need to generate two separate documents. but here i have to check for the customer collateral type is their or not if type(451) is present then generate 4 docs in 2 colms.  we need to show the it gird how is in the requirement  can someone plz let me know how to proceed. i have checked for the customer the type is present or not then next steps am not getting

Hi all, I have in assumption that to write existing data into db using write record SS we only need the primary id and the field which need to be updated. But i am getting error  as there are couple of columns which were marked as required, so i have to add those columns as well along with primary key when using write records . Can anyone suggest if am missing anything or this is how it will work?

Is it possible to redact text from a textField component? I found some plugins for document redaction, but this wouldn't be a document, it's a field that users can fill out and oftentimes will include sensitive information like SSN, account #s, DOB, etc and need to be able to check to see if it includes any private information and redact if necessary. 

Hello all -  I have a process model, where the first task is to call the database for a view (image1). This view has a unique column that is saved to a CDT with other columns (roleid and rest of columns). I save the output of the query database results to an array variable that has the view CDT. My next task would be to iterate through the array variable to update the table that matches the roleid. How can I loop through each array with roleid from the variable and match it to the table roleid? I don't think using a Query Database with the following is correct as the variable propert doesn't seem accessible. Thank you for your help.

Hii I have created SQL query rule based on filter and integrated in process Model and there i have called export to excel SQL smart service when I am downloading on the basis of filter it is working but only small letter value is working capital letter value is not working when I am downloading the report through export to excel. How we can get on the basis of capital letter. What I need to do in SQL query.

Q1.  what is difference between null, empty,blank Q2. can I use for  a!isnullorEmpty() for removing/checking null,empty and blank or apply different functions for checking them.

Hiii, i want to fetch multiple string value seperated by semi colon through query in one column like (123456;234565;456789;234567;124567). How we can do that

Hello I have this setup: - Inner interface that allows to view or edit a record, but it has no buttons - There are outer interfaces that include the inner one, adding to it action buttons or extra fields - The inner interface calculates a field (e.g. cost=number of parts * cost of each part). The result of this calculation is shown to the user in the inner interface, but it also should be stored in a field of the record type. The problem I have is that the inner interface cannot save the calculated cost to the record rule input, because it has no buttons and therefore it can't use a single a!save. The calculated field is shown to the user in a readonly or disabled textField, but its saveInto is innefective when its value changes after the calculation. saveInto works only when the field is enabled and the user types into it. The outer interfaces can update the record type using a!save in its buttons, but they must repeat the call to the calcu

I am trying to implement send e-mail activity. The instance is working fine with no exception or error but I haven't received any mail.

a!localVariables( local!priceId: http!request.queryParameters.pgenId, local!docId: http!request.queryParameters.docId, local!entities: a!forEach( items: local!pgenId, expression: a!queryEntity( entity: cons!DS_ENTITY1, query: a!query( logicalExpression: { a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "priceid", operator: "=", value: local!priceId ), } ) }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: true ).data, a!queryEntity( entity: cons!DS_Entity2, query: a!query( logicalExpression: { a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "docId", operator: "=", value: local!

Can someone help with example. How to do batching in Query. I have clear understanding of how it works but need clarity while implementing.  Eg: create a query entity rule such as : a!queryEntity(entity: cons!entity, query: a!query(filters{whatever filters you want},local!pagingInfo(startIndex: 1, batchSize: 100)))after this what i need to do? I need to fetch 7000 records

Hello Experts, Not able to find the Appian Connected Systems - Document Vector Database, is it pinecone CS? Cheers, Kalai.

Is there a limit on the number of packages which an environment can contain?

Hello! I'm curious whether or not the amount of data we pass in and out of an Expression Rule has any impact on performance. Consider the following scenario. I have a pv!recordType process variable, with three fields: recordType.field1, recordType.field2, recordType.field3. I want to use two of those fields in an Expression Rule to obtain an Output to use later in the Process Model. When configuring rule inputs for the Expression Rule, I am facing two options: 1. Pass the whole pv!recordType into the Expression and access the fields within the expression, resulting in one rule input "recordType". 2. Create two separate rule inputs, "field1" and "field2", and access the process variable fields when passing data into the Expression Rule. Now my question is basically this: is there a real difference between these two approaches, or is it a matter of convention?

Hi folks, I want to know if Appian has got an anonymous reporting features(whistelblowing) by the user of an application/site, like this one in the link: Compliance & Government Affairs Hotline Solutions - Life Sciences | Appian. I don't find anything unfortunately, not in the documentation neither in the support section. Does anybody has some idea? Thanks in advance

The expression rule below should return a list of dictionary containing loanAmount and monthlyPrincipal. It gives me a strange Expression evaluation error : with no specific errors. If I change ri!loanAmount <= 0, to be ri!loanAmount <= 28824, it works for some reason. Not sure why and not sure what's going on. This rule has a rule input called ri!loanAmount of type number(decimal) which I am testing with 100000 as a test scenario to make this work.  Any ideas what's going on? If there are any other ways to get this to work without doing recursion, please let me know. a!localVariables( local!principalPayment: 100000, local!interest: 15, local!loanTermYears: 30, local!periodicInterestRate: (local!interest/100)/12, local!periodicInterestRateModified: 1+local!periodicInterestRate, local!periodicInterestRateModifiedToPower: power(local!periodicInterestRateModified, local!loanTermYears*12), local!xx: local!periodicInterestRateModifiedT

Hello, Is there any way we can automate the plugin discrepancy problem across all env (DEV< SIT< UAT< PROD) ? we are facing issues while release time, get to know that plugin version is different in Production env as compared to UAT. This is causing delay in release. i want to create an automated utility which get plugins data from Production env and compare UAT and PROD plugin, warns beforehand about all the discrepancies. or can we set privileges to certain developers for plugin upgrade in lower env. So that every developer can not update plugin in lower environment. 

Hi, I have link as below . To make it more noticeable to the user I would like to add a border to it and make it look like a button. I tried to use cardlayout but it is displaying like in 2nd image. Can someone help me how to display border just order the richtext link, not the entire row. a!cardLayout( contents: a!richTextDisplayField( value: a!richTextItem( text: "Add Meeting Minutes", link: { a!startProcessLink( processModel: cons!RGRACSLBL_PROCESS_LEAD_LAST_APPROVAL, processParameters: { requestId: ri!requestId, labelChangeCountryId: ri!labelChangeCountryId_int, fromHQ: if( local!requestDetails.workflowType_txt = cons!RGRACSLBL_LabelUpdate_WorkflowType[1], true(), false() ), labelChangeRequest: cast( typeof(

HII  i am getting this error - Expression evaluation error [evaluation ID = NYEY6] in rule 'gai_displaybatchrecordsummary' at function a!gridField [line 59]: Cannot update Map using null index (APNX-1-4522-005) How can i resolve this  i have added my code a!gridField( showWhen: a!isNotNullOrEmpty( ri!record['recordType!{43099841-b468-444e-97af-bc369b79a6fc}GAI Batch.fields.{c835857e-c9ec-40d4-a818-f2d8593b1100}batchNumber'] ), label: "Batch Details Grid", labelPosition: "COLLAPSED", data: a!recordData( recordType: 'recordType!{975fa1c0-6a6a-494c-bdf3-1b0d87ea07e0}GAI Batch Detail', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{975fa1c0-6a6a-494c-bdf3-1b0d87ea07e0}GAI Batch Detail.relationships.{3cd6a92f-954f-48e2-

Hi All, I have a query in export dse to excel. How many characters or word count can be exported in one column of excel? Thanks!

I have a requirement where based on condition I need to fetch the table name so am storing it in Data Store Entity Type. Am able to fetch the value, but I need to convert this to table name. Can some one help how to convert it. Do help with code or if we have any function Eg: Am getting value in Process Model in Pv!table: 473c45d0-5c99-4665-a335-f772838ccb37@2232 but I need to display exact table name. Note: table is of type Data Store Entity

Hello, I have stored different values of a grid in my local variable local!DatosLineas (read-only fields which result on querying another record  + extra column which must be completed by the user).  I want to "write" some of the fields of my local variable in another record fields. For example, the id_pedido of my local variable (which has been created by querying another record, "CPF_Lineas_Pedido") would be the id_Pedido in my other record ("CPF_Lineas_Recepciones") In this case, I don´t know how to match the fields and write my new record with the data of my local variable. I have to point that the INFO SHOWN IN THE VALUE OF EACH FIELD CORRESPONDS TO THE PREVIOUS RECORD (CPF_Lineas_Pedido), but I want to save the values in a NEW RECORD (CPF_Lineas_Recepciones) My code is below: a!localVariables( /*mirar para incluir columna extra en variable local*/ local!DatosLineas: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-42

We are getting an error on PROD saying "Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator". Checked the failed sync reason and it says "Unable to sync due to system failure".  And Event type for this error is "Write To source". This happened only on one particular day (17th September) and there is no error before or after that day.  We debugged and did not find any exact reason why it happened. The only reason we can see that there was some activity happened on DB side on that day and one of our scheduler Process in Appian runs everyday which updates the data in DB in batching of 65 rows so due to which this error might came. Can anyone please suggest on which logs we can refer to look out for root cause of this failure and find that this issue happened cause of some DB connection or any other reason. In tomcat-stdout.log also did not fou