New to Appian

What is the use of Foreign key while creating a CDT in Appian? Please give a brief understanding on the same with an example.

Hi Everyone, I have created an interface which have grid rows. The fileds are populated from two tables, so I have created a view for that. What I need to implement that if a record is entered into one table, the corresponding fields from other table needs to be updated. Can anyone please suggest any solution for this? Thank You 

So i have a page I just want one group to see, in the visibility expression of the "add page" i have:  a!isUserMemberOfGroup( username: loggedInUser(), groups: a!groupsByName("AS Buyers")) but i can't see the page anyways any help?

So I'm using an interface with multiple tabs co-depending on one another, but when i make changes in one, in order to see the changes I need to refresh my browser, is there any way possible to update those variables without refreshing the browser? for instance i have a local variable that receives data from a CDT and in another tab I delete a row from my CDT but if I don't refresh the page, that row is still displaying. Any help? 

How do we selet or deselect a checkbox using Selenium Appian I have already tried methods like fixtures.populatefieldwith etc. can anyone direct me to the appropriate method/usage withAppian Selenium framework?

Can anyone give me some examples on how to implement this in my interface save into button? is it a!deleteFromDataStoreEntities("Name of CDT","local variable where i have all the information i want to delete")?  I've seen the documentation but isn't clear enough and has no examples.

Hi I am using Appian Selenium framework where it uses Labels to identify an element for ex: for clicking something I use this code fixture.clickOnMenu or fixture.clickOnButton etc However, I have a Comments field (Paragraph widget). Not sure how to go about adding data to comments field FYI, I have already tried fixture.WriteText but it failed to identify comments field

Hi! So i just created a local variable and i want to imput diferent types of data in there, but the default data type from the local variable its type text, then when i a!save items into there i get this error: Interface Definition: Expression evaluation error [evaluation ID = 6ef8d:9e3c3] : An error occurred while executing a save: Expression evaluation error at function 'append' [line 446]: java.lang.Integer cannot be cast to java.lang.String I think if i can change the data types of the local variable dictionary I can go arround the error, any help?

I've posted a previous discussion but still no response, while I wait I am trying a different approach, im trying to input values into a writetodatastoreentity and i get this error: Interface Definition: Expression evaluation error: An error occurred while executing a smart service: An error occurred while trying to write to the entity "cart" [id=7626554b-fee0-459d-b2d8-732f6e1bc7f5@3179, type=AS_Cart_DataBase (id=3784)] (data store: AS Data Store). Details: java.lang.IllegalArgumentException: The list of records to be saved must not be null or empty: TypedValue[it=3785,v={}] Data: TypedValue[it=3785,v={}] I'm typing an a!save into the button saveinto I have 3 values and 2 0 like this: saveInto: a!writeToDataStoreEntity(cons!AS_DataStore_Cart_Pointer,{local!info.name,local!info.quantity,local!info.price,0,0}) am I doint something wrong?

HI! So i am trying to get an average rating from my database and insert it in a foreach so i can display the average rate for all the items that are populated using the same foreach. Here is part of the code: ), a!forEach( items: local!filtered, expression: a!localVariables( local!queryrating: rule!AS_Get_Rating(fv!item.id), local!ratestar: local!queryrating.rating_average, a!boxLayout( label: "", but i get this error: Interface Definition: Expression evaluation error at function a!forEach [line 63]: Error in a!forEach() expression during iteration 2: Expression evaluation error: Invalid index: Cannot index property 'rating_average' of type String into type List of Variant which is weird because "rating_average" is of type number, any help?

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]