General

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 

Hi, I am trying to populate a filter using FitNesse for Appian. The filter seems to be inside a frame, I am able to verify that the user filter is present but when I add script to populate record type user filter, it returns error that it could not find the filter.

We recently noticed a issue in production that the excel is populated with random duplicates for any record intermittently. User is filtering out the data on SAIL and clicks on EXPORT button. We can see the filtered data in the excel but few records are duplicated in excel which does not exist in view or SAIL. We ran the query entity explicitly to determine the data and it is correctly retrieved as per the filters applied. So there is no pattern as such to figure out why this issue is occurring. And this is only observed in Production and not in lower environments. As we are not manipulating the data anywhere, I am guessing the issue must be with the view, especially with primary key. We are currently guessing that the issue might be with the way smart service is sorting out the data based on filters applied in excel report. We are using Export DSE to Excel smart service. We are using a view with SELECT ROWNUM ID and mapping this ID as Primary Key with @ID annotation on CDT. But we are

Any one tried this card layout method to handle layout forms. I am facing issues in clicking on the below 'yes' and 'No' options as card links on the below layout form. I tried with all the relevant existing Fitnesse methods below to click on 'Yes' and 'No' options on the form attached:    click on card CARD_LINK_NAME or CARD_LINK_NAME[INDEX] click on card CARD_NAME or CARD_NAME[INDEX] in card choice field FIELD_NAME or FIELD_NAME[INDEX]   Nothing seems to work. Any thoughts or views on this?  Many Thanks

Hi Guys, i've tried implementing the post deployment process model feature and was able to get the details of deployment from 'deployment uuid' which is passed by appian to process model by default. But the post deployment process runs only for direct deployments and we need to run our custom code test on manual deployments too. So, is there a way by which we can get the deployment uuids of all the deployments happened during a day, filtered by date so that using those i can create a scheduler which performs quality check on all the deployments once a day. or is there any api using which we can retrieve the deployment details in an environment. Thanks in advance.

Team, I have below code : a!localVariables( local!data1:{"test1<br>","test2<br>"}, local!data1) Output is list of text strings "test1<br>"(Text) "test2<br>"(Text) I want the output to be in format "tetst1<br>test2<br>" Basically i am formatting a data before sending into email template but it is appearing like below , i want the semicolon to be removed. Test1 ; Test2 It should be like below Test1 Test2 ANy suggestions ?

Hi, We are using microservices architecture in our enterprise and all data related tasks are performed using rest APIs. We want to use Appian as UI layer for our application. So my first question is it Appian recommended for such scenarios, when all data related operations (Get data, add, update data) will be performed using API integration? If yes, Will Appian features like Data Sync, Records relationships useful/supported while using Open API connected systems for records?

Good afternoon, We are using the send file over node to put a file in an sftp. But when we run it, it tells us this in the log: com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.sftp_conn=Error establishing SFTP connection. Confirm your hostname, username and password. See application server log for more details. Error Message: java.net.ConnectException: Connection timed out (Connection timed out)]                And it says that it is caused by Caused by: com.jcraft.jsch.JSchException: java.net.ConnectException: Connection timed out (Connection timed out)                 at com.jcraft.jsch.Util.createSocket(Util.java:349)                 at com.jcraft.jsch.Session.connect(Session.java:215)              

At what stage of Appian Delivery Methodology we repeatedly do backlog refinement. Is it the Build or the Optimize stage or am I missing something?

Hi Appian Developers, I hope you all are doing well and safe. I have created a Facebook group for Appian Developers so that people can understand about Appian technology outside too. Please join the group at https://www.facebook.com/groups/appiandevelopers to share the questions/answers and contents about Appian. Regards, Shubham Kumar

i'm trying to get the billNo of this invoice object   but when i try to retrive it  i get null values if  i use  the index function  if i don't use index function i get an error saying the error that i just wrote in the subject  the only way for me to get this information is just getting all    the values  how could i  get just one value ? bellow i'm gonna let you some examples of  what i see.