Discussion Categories

Dear experts, I have a PM with user input task, in task form, I define one submit button, which submit is true, validation is true, in this task form, it have a child interface, which have a paragraph field which required is true. However when I keep this paragraph field as empty and press the submit button, user input task completed, PM completed, no validation here. What maybe the possible reason here?

I am working on build an application: step 9 of the Acme Auto App. Currently working on the Process Model.  When I save and publish I get 2 errors: The first one says that "there was an error in an expression in at:" but gives me no further information. When I click on it it takes me to properties but I don't know where to look. I checked the troubleshooting suggested on the lesson but did not find anything. What can I do to fix it? The second it says the process model contains a variable that it does not reference. I'm assuming this is because I will reference this variable later but I am no 100% sure. Is that correct? Thanks in advance, Gabriel

Hi, Please suggest how can i fetch first 100 rows using export data store entity to excel. In filters input we can use only a!queryFilter and a!queryLogicalExpression. Thanks

1) I am using appian community account. I need to change my first name but 'Update' button is not enabled in edit profile 2) Is there any way to download certificate from appian community account

Hi Everyone, Can anyone help on check box content extraction using appian AI. It seems like AI is not reading check box content. Do we need any specific configuration for reading check box content? Thanks in advance

hi,  I have an editable grid and save the selected rows in the a variable local!selectedrows, has fields {id:1, name:"test1, age:"60"                  {id:2,name:test1,age:"70"} have another variable  local!displayitems has a nested list .    {id:2,name:test1,age:"70"} is present inside the second index and 5 th item    please suggest how to write code for this.  my intent is i have to update the selected Row into the display items by indexing it upon button click.

Hi team, I have a use case where I need to delete old data. Imagine I have three tables: employee, address, and documents. To delete an employee, I need to store documents and address in history tables then i need to break the dependency (foreign key mappings) from documents and address . Then, I need to move the employee details to a history table before deleting the employees. So, I have a process model which executes these steps in individual query database nodes, like moving details to the history table using inserts, then breaking dependency using update, then moving employee details to history using inserts, and finally deleting employees using delete. These tables are just examples; I'm doing a similar process which I cannot fully explain here. The thing is, my production table has 110GB of data, so performing this operation for 3k employees took more than 3.5 hours. So, I planned to process in parallel using startprocess MNI. It is wo

I am working on the AcmeAuto app and got the following error:  Expression evaluation error: Syntax error. Details: Expression evaluation error : Invalid character found in expression: “ (8220). I copied the code provided on the guide but perhaps I did something wrong?  code provided: this is what I changed: Any help appreciated.

For each request, we have an audit history that I'm displaying as tabular data with 2 rows per page. However, this creates an issue: if I show only 2 rows per page, the remaining space on the page looks empty. On the other hand, if I display 3 rows per page, it doesn’t fit well if any row contains a large amount of data.Below I have attached reference code for this:Note:We have to display header and general info after page breakany Alternatives for this,a!localVariables( local!requestAuditLog:rule!EPR_QE_V_getRequestAuditLog(requestId:ri!requestId,actionNotIn: cons!EPR_ACTION_LIST[1]), local!tableHeadings: { "Date", "User Name", "Action Taken", "Note" }, " "&if(a!isNullOrEmpty(local!requestAuditLog),"No Notes avaliable for this request", " AR Notes " & local!tableHeadings[1] & " " & local!tableHeadings[2] & " " & local!tableHeadings[3] & " " & local!tableHeadings[4] & " "&a!localVariables( local!rows: a!forEach( items: local!re

Hi  I want to achieve such a grid, wherein there will be 1 value in the left row and can have multiple values in the right row denoting that values Mango -> Cherry belong to fruit type  Can this be achieved using any of the grid components available ?

Hi, Is there any way to increase tooltip character limit. As of now I can see it is restricted to 200, is there any way to increase it? Thank you.

Hi All,I am calling 2 values from my record type in the DATE and TIME format and I want it to produce the amount of days in between the dates.Saw this suggestion in a previous post in regular date format: tointeger(tointervalds(today()) - tointervalds(today()) but did not work from the date due to not able to calculate different in seconds?

Hi Folks, There is a requirement to reset the password dynamically for a user, but I don't see any specific smart service for this purpose. Regards, Ghanashyam

I am trying to get data from Salesforce. The connected application is functional on Salesforce (tested on Postman) but, I get this error in Appian Unable to retrieve access token The following error occurred: invalid_grant authentication failure whenever I test the connection of the connected system. Can someone please help me out with this error?

Hi Folks, Can I hide the count in below grid. FYI. I am getting data from array of maps. Regards, Ghanashyam

HI everyone,  Could you help explain me how below code works? The character "_" is new to me and I cannot find any documentation for it.  apply( contains( index( local!childTask, "id", null ), _ ), index( local!parent, "id", null ) )

Hi All,  We are currently on Kafka version 2.6.2 and using the Kafka Tools plugin(1.4.1). we are planning to migrate to Kafka version 2.8.2 or higher. I would like to know if the plugin supports this version. Thanks!!

Data in reference tables can differ across environments, which directly leads to have different primary key values of same reference data in the tables across environments. But, knowing this fact, still some Appian applications use primary keys of reference data as constant, for example primary keys of workflow statuses are referenced using constants rather than their text value. If while deploying or during data migration, primary key changes, then code written using those constant references may break. What is the best approach to code for above use case?

Helo......Just curiosity, what is the limit or best number for entities that can be added in one Data store, I searched in docs but can't able to find the answer. Thanks in advance 

Hi , Is there any plugin to convert html file to docx file? I see document utilities (plugin from aspose) says they have this option. But they only have docx to html but i need the vice versa.

Hi Champs, There is a requirement where we need to send a link to the user so that they can directly click the record action instead of record summary page. Is it possible? Regards, Ghanashyam

How exactly does a write to data store work in the background? - For a single row, it will surely run 1 insert query, what happens when the data is an array? for each row will it run a single query or multiple ones?

We are trying to assert a specific payload onto an SQS queue from Appian to be picked up by an external tool and processed.  Given that Appian doesn't have an AWS SQS interface natively,  we've been trying to use the SNS Rest API to apply our payload onto an SNS topic and let a filter feed it to the SQS queue.However we're having a lot of trouble configuring our Message Query Parameter and our MessageAttributes.Does anyone have a sample POSTMAN, or even a screen shot of a successful Appian -> SNS integration with a message body and message attributes?  Any help that can be offered will be gratefully received.

Hi, Please suggest some ways through which I can avoid multiple users accessing same record at same time . Thanks

Hi everyone, do you know if is it possible to remove completely the header row into gridLayout component? I want to remove the entire header row, not the label only. If it is not possible, do you know other components that allow you to do this? Thank you