General

The query editor is a super quick and handy way to get queries all put together, but I was curious why it doesn't function for queries on data sources other than data store entities? The logic needed when we code it manually is ultimately very similar. Not being able to use the editor for a record, for example, seems particularly weird as records are supposedly the fastest/best way to get data in Appian. Yes, I can put in filters and whatnot in the record itself, but then I end up having to make separate records every time I want to change what data comes back, which seems silly. So that leaves me with manually generating all my record queries (or anything else I want to query that isn't a DSE).  Is there something I am missing? And if not, can I request that we expand the functionality of the query editor to all queries instead of just the single subset of data store entities?

Dear All, We have a requirement to setup a new Dev environment (v20.2) .We have more than 50 + application to export from old env into new environment. Some of the applications (contains 1000+ objects). When we try deploying via compare and deploy option . The system throws with 500 error as below HTTP Code: 500APNX-1-4198-000 Error Evaluating UI ExpressionExpression evaluation error [evaluation ID = YU5ZGJIV] : [valid:false,syntaxError:false,value:Expression evaluation error: An error occurred while executing a save: Expression evaluation error at function a!dod_api_app_checkResult [line 66]: The specified environment is not available] Any suggestion/Steps or best practices to import large application which contain more than 1000 objects ? Anybody faced similar issues.Please help

In Appian release notes of 21.4. Removal section contains Process start forms and user input tasks can no longer be configured using in-line expressions. To configure new forms, directly select an interface and map inputs to your process variables. Existing expression-backed forms will continue to work as designed. What does it really mean?

I have a Parent Page with a list of records.  - When a user clicks on the record, it opens to the edit page where users can make changes to record and hit save. - But the changes are not showing up on the parent page? How do I refresh the records on the Parent Page?

Hi,  i have multiple dropdown field... i made that to reusable... it's working in other places and only in one place it's showing error for choice vales  error can anyone help with this? Thanks

When you make an expression, the name and rule inputs show up in the little help box in the bottom left corner much like native appian functions. The expression's description also shows up. I was wondering if there was some way to make descriptions for the rule inputs. 

Hi everyone, Hope everyone is doing well and safe. As I am new to Appian, Could anyone of you help me for this question, is it possible to apply recursion concept in appian ?what is recursion in appian? how it will work? Thank you all in advance! Regards, Kiran Sajjan

I want to write an expression rule to compare two values:  first value is from rule input and second value from a db table field.If the values are same ,then another field(column) of my db table must be set to inactive or 0.

https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2021-44228 Is Appian affected by the log4j vulnerability CVE-2021-44228?

Hi,I have a requirement, where the client need to customize Appian Login Screen,if anyone who has worked on it, could you plz help me on this.Change the login page from the default Appian login Page to the standard Organization authentication page (For Example: when I log into workday, or myLearning or other... I get the screen attached to this ticket).Can the login page be specific to one application??

Hi Team, QueryEntity is not fetching data correctly, below is my code: a!queryEntity( entity: cons!TEMP_TABLE, fetchTotalCount: ri!fetchTotalCount, query: { a!query( selection: if( rule!APN_isEmpty(ri!columns), {}, a!querySelection( columns: a!forEach( ri!columns, a!queryColumn(field: fv!item) ) ) ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "clientId", operator: "=", value: ri!clientId ), a!queryFilter( field: "requestorName", operator: "=", value: ri!requestorName ), a!queryFilter( field: "engagementNumber", operator: "in", value: ri!engagementNumber ), }, ignoreFiltersWithEmptyValues: true() ), paginginfo: if( rule!APN_isEmpty(ri!pagingInfo), a!pagingInfo(startIndex: 1, batchSize: - 1), ri!pagingInfo ) ) }).dataIn the test output, it is returning the result as infinity symbol for a particular column which is number(integer), shown below: My table in the backend

I am facing below error on task submission: Previously, this issue was not occurring. We have checked the security for all the related objects. Everything seems to be fine.

Actually is this for me or somebody also facing this 403 error? 

Hi, Can someone help me here. Line1 code in the below attached image is giving proper expected output (Email). Where as Line2 is returning an error. Any idea what went wrong.

The interface for my grid field has all it's data queried before losing connection and stored in a local variable. Then for the grid field's data parameter, it's getting it from the local variable. I have this interface as a start form in a process model, so I may make it an Action on a site. When I test this out on mobile and disconnect myself it stops working. I followed the guide in Appian documentation not sure what I'm doing wrong? Is it because it's not a form, I even gave it a cancel button. 

Hi Team, I have 2 interface one is parent and another is child interface. From child interface i am submitting the form and found that value is not passing from child to parent. I am using same rule input for both parent and child. help me on this to get the solution. Thanks,

I want to write an expression rule to compare values of a rule input and value from a db table field.If the values are same ,then one of the fields(column) of my db table must be set to inactive or 0.

Hi , saveInto is not working for the below code a!paragraphField( label: "Comment", value: ri!comments, instructions: "(" & 255 - len(ri!comments) & ")", saveInto: a!save(ri!comments, save!value), refreshAfter: "KEYPRESS", validations: rule!PDR_validateTextOnSize(enteredText: ri!comments, size: 255), required: true(), readOnly: false() ) when I write anything in paragraph field the value is not save.

Hi guys,  I think I am close to the solution, but I've been stuck with this for a while and figured asking cannot hurt. I am creating an interface which is supposed to show the user data from another User Input Task and have them confirm it has been input correctly. For this I use a read-only grid which I configured according to the Appian tutorial. However, it displays the data in only one row, albeit separated in the pre-defined columns (so e.g. it will say for Underlying "Underlying1; Underlying 2" in one cell). The data is pulled from a CDT as a rule input. It contains "flat" data like single booleans, but also arrays. For this exercise, only arrays are concerned. Do I have to manipulate the data beforehand or am I missing something major? My code: a!gridField(  label: "Fixing Levels",  labelPosition: "JUSTIFIED",  data: ri!product_cdt,  columns: {    a!gridColumn(      label: &q

Hi, Is there a way to use local variables in a rule that is used in reduce function When called from UI? When Using from UI it says that I need to configure  refreahalways for the local variable ..... Thaks in advance, Gil

Good morning, We need to have a webApi that receives a document and a json input with other data in the body. I have been reviewing the document upload template of the webApi and in the body it only lets you add the document.Does anyone know if what I need to do is possible? Greetings and thank you

Hi I am working on Appian version 21.3. I have created an extraction process referring to the below link: https://docs.appian.com/suite/help/21.3/create-doc-extraction-process.html The process looks like this in my case: The CDT is: My concern is, out of all the values only 2 values are extracted and 1 value is semi extracted. The PDF file I have created manually. Want to understand why all values are not extracted despite not much values are there in the PDF. PFB the Appian Reconcile form that pops up as a task for me: Thanks in advance!!

i am trying loop through the each row in the excel but foreach is not working .

Hi Team, We need to show four tabs in our site's homepage and all the tabs are different interfaces which are interlinked. The first tab/page is a action whose context is a process model with a startform. How should i configure it in the 1st tab page. Below is my code for tabs UI: So here I am trying to call the process model for first page with a!startProcessLink but i is not working. Can anyone please suggest what should be done here? Thanks.

hello, I'm currently on Appian version 21.3 and i want to upgrade to 21.4 can you please help me, I don't have any experience in upgrading appian version