Community

Hi, when I am configuring the record type I am facing this error,can anyone help me to solve this error. I searched in my data store and Db and varied twice still facing this error

I have list of value, how to add lists of variables to back end of database, click one button, add or update many rows.

Hi,I'm working with the following task,I have table(table1) has a one to many relationship with table2. In my view, I have my 1st table(table1). Eg: CustomerName column in table1. When I click on that, I should get the rows of orders in table2 with same CustomerName.What are our suggestions for completing this task? Eg: In Order fullfilment app, When we click on a customer's name, we'll be able to see all of their orders.

a!queryEntity( entity: cons!AS_DataStore_Ratings_Pointer, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "productId", isGrouping: true ), a!queryAggregationColumn( field: "rating", alias: "rating_average", aggregationFunction: "AVG" ) } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "productId", operator: "=", value: ri!productId ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: false ).data Hi! so i have this query which return the average of a value from an ID, but not all items  have rating and when i. use it in a foreach i get this error: Interface Definition: Expression evaluation error at functio

Hi, I'm new to Appian. I'm trying to explore order fulfillment app.  In the customer's tab, when we click on the customer details we get the related sales order details. I'm trying to do the same but cannot map in table form. Could you please guide me through the steps.

Hi everyone, Can anyone please guide me how to merge columns in a grid layout as shown below:

Hi Everyone, I need to update multiple tables through the update button in interface. Can anyone please guide me how can I achieve it. If possible, please share any example to implement this. Many Thanks!

if(isnull(or(ri!a,ri!b)),{},a!forEach( items:rule!KONE_Development_CSE_TENDER_PHASES_Search_Rule(ri!a), expression:a!localVariables( local!csetenderphases:fv!item, a!forEach( items:rule!KONE_Development_CSE_TENDER_Search_Rule(local!csetenderphases.tenderId), expression: if(local!csetenderphases.tenderId=fv!item.id, if(or(fv!item.statusId="3",fv!item.statusId="4"),{},{ a!update(data:local!csetenderphases,index:"user",value:ri!b) }) ,{}) ) ) ).list.user ) As title, i need transfer all value to be correct form to be saved thank you all

As title, there are two difference from java or python with appian, one is there is not under_score marks for a list, such as list[0], the a!forEach seems can't apply with number, such as for(i=1,i<100,i++),  also there seems a!save(target:) can only save into one row of value, if I want to update a list, how should I do other than process model, thank you.

So I'm building a store in appian and i want the user to be able to rate a product and I want it saved so then ofter i can show an average rating of the product, what should I do in order to save the rating of the user in the database after i click the star icon or after i click a button to save the rating? i already have a database set up. Or if thats not possible is there any other way to do it?

Hi everyone, I have the requirement to display the attachments stored in a folder, whose unique names are present in database. I would like to provide a link to user in such a way that the name is displayed in the interface and when user clicks over it, the attachment gets downloaded. Thank You.

Hello, Appian. What should I do if I want to use another local web server and web application server in Appian? Thank you!!

is it possible to break a forEach? 

saveInto:{ if(or(isnull(local!searchDeleteUserRole),isnull(local!newUser)),{}, a!forEach( items:rule!KONE_Development_CSE_TENDER_Rule(), expression:a!localVariables( local!tender_Id:fv!item.id, local!status_Id:fv!item.statusId, a!forEach( items:rule!KONE_Development_CSE_TENDER_PHASES_Rule(), expression: if(fv!item.user=local!searchDeleteUserRole, if(local!tender_Id=fv!item.tenderId, if(not(or(local!status_Id=4,local!status_Id=3)), { a!save(target:ri!csetenderphases.user,value:local!newUser), a!save(target:ri!csetenderphases.id,value:fv!item.id), } ,{})

Hi All, I have a user case below, where in "comments column" should be editable based on click of a "edit" icon.  Below is the code snippet with in the grid. a!textField( label: "Comments" & fv!item, value: fv!item.commenttext, saveInto: { fv!item.commenttext }, readOnly: false(),     --->>>>>   how can I make the row editable when a user clicks on edit icon ? ),if( fv!item.status= "NON-EDIT", a!textField( label: "Action" & fv!item, value: "", readOnly: true ), a!richTextDisplayField( value: a!richTextIcon( icon: "edit", caption: "Edit", link: a!dynamicLink( value: fv!index, saveInto: { a!save() } ) ), align: "CENTER" ) Any help is appreciated [emoticon:c4563cd7d5574777a71c318021cbbcc8]

a!documentImage( document: if(isnull(fv!item.imageId), cons!NOIMAGE, fv!item.imageId ) is it possible to use fv!item with the isnull funcion? i am trying to place a image (cons!NOIMAGE) if theres no image in the database for that specific object but i get an error saying that document cant be null so I supose its returning a True boolean in the if statement 

Hi! i created a cdt with an imageID then in an interface i designed a file upload with the target pointing to a documents folder and a save into and value of ri!product.imageId, now on an approval interface i want to display those images, i tried this:  a!documentImage(todocument(tointeger(ri!product.imageId))).document but i get this as an error: Interface Definition: Expression evaluation error at function a!imageField [line 77]: An image gallery component [label="Item's Pictures"] has an invalid value for "images" at index 1. None of the values in "images" can be null.  Is it because i didnt save to the database yet or another problem?

a!forEach( items:rule!KONE_Development_CSE_TENDER_Rule(), expression:a!localVariables( local!tender_Id:fv!item.id, local!status_Id:fv!item.statusId, a!forEach( items:rule!KONE_Development_CSE_TENDER_PHASES_Rule(), expression: if(fv!item.user=local!searchDeleteUserRole, if(local!tender_Id=fv!item.tenderId, if(not(or(local!status_Id=4,local!status_Id=3)), { a!save(target:ri!csetenderphases.user,value:local!newUser) } ,{}) ,{}), {}) ) ) )

Hi! I'm new to Appian, I built a form where i can upload images, then i created another form for a supervisor to validate it before writing to the database, how can i display the images uploaded in the supervisor read-only interface? Thank you in advance

Hi, everyone Where can I find all the SQL codes used in Appian database which appeared in Associate Developer Practice Test. I'll appreciate it if some one can offer me a list of SQL or a URL. [emoticon:c4563cd7d5574777a71c318021cbbcc8]

I have a table have 50 columns, but i only need change one column of information of certain rows, i don't want to saveinto every column one by one, but one save that only columns, what shall i do for coding but not process model? Thanks

disabled:if(isnull(local!searchDeleteUserRole),true(),if(isnull(trim(rule!KONE_Development_userrolebackupexist_Rule(local!searchDeleteUserRole))),false(),true())), my rule is: a!queryEntity( entity: cons!KONE_Development_userrolebackup_Constant, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 5000 ), selection: a!querySelection( columns: { a!queryColumn( field: "name" ) } ), filter:a!queryFilter( field:"name", operator:"=", value:ri!name, ) ), ).data What I test from rule is always return empty, which I doubt is null value, however, if(isnull(rule!(local!value)),true(),false()), it should return true() since no value respond in the rule, but seems it always return false, so i doubt the rule always return with some not null value though it is empty. Which way I can make the empty value transfer to be null? Thanks

typename( typeof( 4.2 )) This some time return "Number (Decimal)", or return"数字（小数）"，how i can make it return English only?

Hello Everyone, I would like to display data from database view into interface without using grid. Can anyone please help me how to achieve this, the displayed must be editable as well. Thank You.

a!richTextIcon( icon:"arrow-down", link:a!dynamicLink( saveInto:{ a!save(target:ri!userrole.ROLE,value:fv!item.Role), a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name), a!save(target:ri!userrole.NAME,value:fv!item.KONE_user_name), a!save( target:ri!userrole.USER_ID, value:rule!KONE_Development_UserId(fv!item.KONE_user_name) ), a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME), a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME), a!save(target:ri!userinputsheet.Email, value:fv!item.Email), a