Records

Here is my expression: a!localVariables( /* Loop checks against passed in value of type to pull values from specific requirementActivity match */ a!forEach( items: ri!requirement.requirementActivities, expression: if(contains(ri!activityType, fv!item.type), 'type!{urn:com:appian:types:UW}UW-Requirement-Activity'( key: fv!item.key, type: fv!item.type, creatorId: fv!item.creatorId, creatorFullName: fv!item.creatorFullName, createdDate: fv!item.createdDate, commentText: fv!item.commentText ), {}), ), ), activityType is Text Array snippet of rule in play: local!requirements: { a!forEach( items: local!requirementsResponse, expression: a!localVariables( local!receivedRequirementActivity: rule!UW_GetRequirementActivityByType( requirement: fv!item, activityType: "RECEIVED" ), local!waivedOrAcceptedRequirementActivity: rule!U

Hi All, I am having a page where i am having a Grid called from the Record. The record filters which are used for filtering the dataset should be used for other grid which should be using the same filters of record applied to the below grid too. In other words i need to use the record filters called in a grid used for filtering the other grid. If this is possible please let me know.

Hello,  I'm doing a simple read only grid with the source from a a!QueryRecordType to my record type. The issue I have is when I try to setup the sort I get an invalid field identifier error. I tried removing the column in the record type and add it back in but I get the same error but with a different identifier ID. Here is my code  a!gridField( label: "Read-only Grid", labelPosition: "ABOVE", data:rule!ISM_QueryTop20PublishedDocuments(), columns: { a!gridColumn( label: "Documentid", sortField: 'recordType!{6c3f65fe-917f-4366-b480-020d7dbaa2e0}ISM DocumentRecord.fields.{30e1db97-bb69-4765-a270-0e6592c6a736}documentid', value: fv!row['recordType!{6c3f65fe-917f-4366-b480-020d7dbaa2e0}ISM DocumentRecord.fields.{30e1db97-bb69-4765-a270-0e6592c6a736}documentid'] ), }, validations: {} ) Here is the error i get Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation I

We are using an On Prem version of Appian.  We have 3 databases, 2 MS SQL Server instances and NEO4J. We need to get some of the data out of the 2 SQL Servers that are supporting Appian into NEO4J with an ETL process. One blocker we are running into is linking the User back to records. We have found the dbo.usr table that holds User information. But when we add LastModified columns on tables created via Appian, we are getting some type of hash type code that does not link back to the User table.  How do we query one of these hashed user id values and link it back to the User table in order to bring the actual User info into our ETL process?

Hi all, I am using readexcelsheet function to read the excel sheet and perform validation at row level to identify the duplicates, checks to identify whether the mandatory fields are present or not  . And then populate the value on read only grid with the errors for each row  before uploading to Database .  When we are uploading file size of ~100 KB , the code is getting executed successfully and the grid is getting populated after the validation and we are able to load the valid data in the DB  . However, the user wants to do a bulk upload of 96K records (~ 6MB file) ,in that scenario, it fails on the site level  and gives "403 error- You don't have permission to view this page".  We tried uploading 10K records ( file size ~300 KB ) and got the same issue . We tried to execute the readexcelsheet function without any validations and then also it gave the same error on reading 300 KB file  . Is there any file

Hello, Client wants to have Decimal(18,9) in SQL db as this DB is being used by others as well. But when we try to insert it using Appian either it converts to exponential or gives error as CDT field we have created decimal type. If I am doing todecimal then also it gives error. Please let me know what shud we do so that atleast 18 digits we can save , I know Appian dosnt support 9 percision after decimal so it would be hard but if someone could suggest workaround so that we can save in DB decinal (18,9). Not all the values are comming from Appian interface , few values we are fething from third party system also. Thanks, Pooja

I have deleted all my data from database table .But it is Available in my records. how to delete the data from the records

After sending an email to a person to fill out the form how can we check if the person fill the form and data in the DB is saved or not(give some smart services in-process model)

Error -  Expression evaluation error [evaluation ID = e326c:9b40c] at function a!recordList: An error occurred while retrieving the data for "SBA_ PostRecordType". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000) Steps I choose -  Created Interface to update records in database, Database is updated by this process model later when records are getting re-loaded, appear this Sync Error issue, what i have tested that data has been updated in database - later I manually sync data, record list is started working fine  -  any help will be appreciated Thanks & Regards Shree

Hi Everyone, Is there a way find out duplicate combinations in Appian DB Table and delete them. For Example there is a table with columns Name and Place  NAME PLACE John Newyork Tom Washington John Newyork Robert Boston Now how to find out the duplicate combination for John and Washington and keep only one record of that combination Thanks

Hi, I've have a use case where the customer load some data through uploading to Appian an excel sheet. The requirement is implement the load process with two main steps: 1) Load excel data to temporary tables, validate data and inform user about the data read, number records to be updated/inserted, errors found if any. 2) User gets these information on a form where he can confirm or cancel data load. In order to implement step 1, I've written a rule expression that loop on the data saved on temporary tables and make some validations. One of this validatiions is check for the existence of every loaded Id in the current data, in order to know if we have a create a new record or we have to update an existing one. Lets call this rule checkRule, full code follows,: a!localVariables( local!cargaUFGs: rule!TGSS_GetDatosCargaByDSE(dse: cons!TGSS_ENT_CARGA_UFG), local!idsUFGsActuales: tointeger(index(rule!TGSS_GetUFGS(pagingInfo: null),"idCliente",{})), cast( 'type!{urn:

My constant has 7 values in this format: Description: 111 - test123 112 - hello 113 - goodbye Values: 111 112 113 I am trying to create a user filter called "Blank", where the record would pull all data that is not 111, 112, or 113. I tried a foreach statement that loops through the constant and set the operator to <>. However, I get this error when I do: function a!gridField: Cannot apply operator [NOT_EQUALS] to field [xoStatusId] when comparing to value [TypedValue[it=101,v={936,937,938,939,940,941,942}]]

Hi , I want to update the local variable of the type List of Cdt based on a condition. For eg. myCDT:{{name:"Albert",age:30,Dept:'Sales',Sal:10000},{name:"Beth",age:28,Dept:'HR',Sal:2000},{name:"Cindy",age:35,Dept:'Finance',Sal:2000},.................} Dept:{"HR","Sales"} I wanted to update the Sal of myCDT list found in the Dept variable.   I know we can do it with foreach() function, but I have to map each field in the CDT. I have around 50 fields in my actual  CDT   Is there another way to implement this ? Please suggest. Thanks in advance.  

I need to build an interface with 100 Editable Columns and all the columns need to be searchable & editable.(Like a table with 100 columns and we should be able to input something and search / modify the data and submit to DB).Which approach is suitable for this requirement? Should i go with Record Type / Editable Grid.(I am aware that the performance may be slow due to 100 columns. But business want to evaluate how it looks like and see the performance)

Hi , I want to update the local variable of the type List of Cdt based on a condition. For eg. myCDT:{{name:"Albert",age:30,Dept:'Sales',Sal:10000},{name:"Beth",age:28,Dept:'HR',Sal:2000},{name:"Cindy",age:35,Dept:'Finance',Sal:2000},.................} Dept:{"HR","Sales"} I wanted to update the Sal of myCDT list found in the Dept variable.   I know we can do it with foreach() function, but I have to map each field in the CDT. I have around 50 fields in my actual  CDT   Is there another way to implement this ? Please suggest. Thanks in advance.  

As i said i´m trying to update certain rows on my table, and i have a list with the key and the field I want to update. I´m trying to do this from an interface each time i click on a button. But on a!writetoDataStoreEntity, i just can update one row each time, but i only have one button to do it all. So, any posible solutions to this problem?, thanks!

I am trying to create a vehicle record but I didn't find 'aavehicle'. I have checked in database for aavehicle. I didn't find. How can I found please help me.

Dear all,  I have updated the possible values ​​(by changing the linked constant) of a record type field. The problem is that the data already stored for that field is not updated with the new values, but remains with the old ones. How can I change the records already archived? Thanks

Hi, I have a dataset of 150k record that needs to be updated nightly. We get this data through an API. From the payload we will parse the data and map it to 5 individual CDT's and then write to the db. How should I design this whole process?

Hi, In the below Summary view of a RecordType, I have a document ID which has been uploaded using fileUploadField.  I have this saved in the database.  Now, while showing the details, I would like to show the document name instead of id. Can someone help on this. When I tried like document(ri!employee2.coverletter, "name"), nothing is displaying.

Hi, I am getting below pink error. The data is being fetched from a view and its an intermittent issue. Need your suggestion on this.

I just started trying to use Record Sync and Relationships and wanted to sum amounts from another table that have a many-to-one relationship with an Id in the main record type. However, I only want to add rows that are  isActive = 1 or by some other kind of categorization. Is this doable with a custom expression ? Since the template doesn't have any filtering options.

Is there any way we can use related record type field or expression rules while creating custom record field in a Record type with data sync on? When I am creating a new custom record field and trying to write my own expression, it's not allowing me to use any expression rule. Also I am not able to use any field from the related/mapped records.  It is restricting me to create user filter based on custom record field. Any help would be appreciated. Thanks in advance.

I'm looking for a way to make it possible to page through a list of records from the view of a single record - that is, to add in BACK and NEXT buttons at the bottom of a single record view rather than returning to the list to reselect the next. I understand from previous posters that this may be possible if you can access the list's index of the selected record, then decrement or increment into a local variable so your BACK and NEXT buttons will take the user to the correct record. I have saved the queried list of records to a local variable. How does one access the index values of the records in that variable? Should I instead work from a read-only grid? fv!item will give me the entire record but no value I can reliably decrement or increment to get its neighbors, and fv!identifier will give me its unique identifier, but as records are constantly added and deleted that is also unreliable.

I have this expression rule : a!localVariables( /* Loop checks against passed in value of type to pull values from specific requirementActivity match */ a!forEach( items: ri!requirement.requirementActivities, expression: if(contains(fv!item.type, ri!activityType), 'type!{urn:com:appian:types:UW}UW-Requirement-Activity'( key: fv!item.key, type: fv!item.type, creatorId: fv!item.creatorId, creatorFullName: fv!item.creatorFullName, createdDate: fv!item.createdDate, commentText: fv!item.commentText ), {}), ), ), And I'm using it in my interface : a!localVariables( requirementsResponse: rule!UW_GetRequirementsByCase_RDS("SomeKey"), local!requirements: { a!forEach( items: local!requirementsResponse, expression: a!map( type: fv!item.name, status:fv!item.status, orderDate: fv!item.createdTimestamp, orderRe