Discussion Categories

Hi All, I want to understand matrix for role segregation and activities that one can do as basic user vs sys admin . Generally  I want to create a matrix for business presentation defining global user vs sys admin access matrix. Can anyone please help. Thanks Bihitak

I am using process report. Recently I encounter the below error in the log. Can you pls advise on what would be the best option I should follow to remediate this issue without changing the default time limit? The report generation was cancelled by the system after 2224 ms.The time limit for generating a report is 2000 ms. (APNX-1-4275-008)

Hi, Iam getting error “An error occurred in executing an Activity Class” for ‘Docx from dynamic template”smart service .The plugin which used needs to be updated.Is the issue will resolve after updating this plugin?If its not please help me to resolve this as we faced this issue from aug 19 onwards and it is working fine before that, Attached the screenshots of node outputs ,node inputs ,system logs for reference.

Can anyone help me on this : - You need to remove an unused field from an existing record type Product, which has data sync enabled and is backed by a database table. What should you do? A. Delete the field from the record type and optionally delete the column from the database table. B. Delete the field from the product Custom Data Type (CDT) and perform a full resync of the record type. C. Delete the column from the database table and perform a full resync of the record type. 

Hello, is there any way to round the corners of a progress bar or a bar chart in Appian?

When you click the add button, the CardLayout component is duplicated along with its fields. Consequently, the dropdowns in each card layout are showing the same selected value as the dropdown in the first card layout. How should I handle saving the data to ensure that each dropdown maintains its own selected value?  a!localVariables( local!count: 1, local!destChildFields: a!map( status: { description: "Status", type: "integer", questionSet: "global", required: false, enum: { 12, 13, 14, 15, 16 }, enumLabels: { "To Do", "In Progress", "Escalated", "Withdrawn", "Resolved" }, typedesc: "Single-Select" }, subStatus: { description: "SubStatus", type: "integer", questionSet: "global", required: false, enum: { 17, 54, 21, 18, 19, 10019, 10021, 10018, 95, 10016, 10026,

Hello Team, As you all know that few of the functions from 'People Function' plugins are deprecated and can be removed at any time. Can you please help me with the replacement of functions with Appian out of box function. Below if the list of functions which have been used in our code, aregroupsaddedbyruleareusersaddedbyruledoesuserexistgetadmingroupspaginggetadminusersdirectpaginggetadminuserspaginggetallgroupsnamesgetdirectadmingroupidsgetdirectgroupmemberuserspaginggetgroupprofilegetgroupuuidgetmembergroupsdirectpaginggetmembergroupspaginggetmemberusersdirectpaginggetmemberuserspaginggetuseruuidgroupprofilerecordtypesourceisusermemberofallgroupsvalidatenameforuser Please let us know if anyone has already implemented code to replace above functions.

Is there a good way to convert a list of items with no more than 1 item in it to a single item? There are 2 ways I know of, both have minor issues depending on the context.  1) use an index such as array[1] to get the first value of the array - This works, but requires some null checking in case the array is empty as it will bug out if that is the case. 2) use cast, but this requires knowing the type ahead of time, and if that's not possible, neither is this casting method.  Is there any other way I'm missing? Some hidden fromList() function I haven't found yet?

Hi All, I have this new kind of issue. I have created few interfaces and expression rules in an application and recently while I am trying to edit these objects I am getting the 403 error message saying that "Access Denied. You don't have permission to view this page". I was able to edit it one week back and now also, I am able to edit the interface in design mode without any issues and saving them. Issue is only with the expression mode. Issue seems to be occur only on my application objects even if I tried duplicating the old interface/expression rules. Security of the objects also looks good & i have Admin access on the same. Let me know if anyone else faced the same kind of issue earlier and steps to resolve the same.

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