Records

Hi, I would need to colorise a a!linkField. I've tried with a!richTextDisplayField() and a!richTextItem(color: ...) but it does not work. How would you do (if it is possible)? a!gridColumn( label: "contract", value: a!linkField( links: { a!recordLink( label: ..., recordType: ..., identifier: ..., ) }, align: "CENTER" ), align: "START", width: "NARROW_PLUS" ), Regards

Hi, I'm trying a simple code using an Interface containing a RecordType based grid, and I need to pass the 'fv!row' to an ER to make some fields calculations/traitements for the current row. In this example (below), all works fine because I've used the workaround to add the column "year" in the grid (showWhen = false, because I do not want to display this column in my example). If I remove this column from the Grid, it seems that the "year" field is reset to null in 'fv!row', so the ER can not work with this field anymore as it is always set to null. Could you tell me why there is such an issue ? passing RecordType 'fv!row' automatically casted into CDT seems to work yet. How would you do to make it working (removing definitively the "year" column) ? *** Interface : a!formLayout( label: "Grid with RecordType", contents: { a!gridField( label: "Vehicles", labelPosition: "COLLAPSED", data:

I have a Web Service backed records with SYNC. It seems that any change to the model, like adding a field causes reference change to the identifiers. they become ciphered through out the application, like:     value: ri!record['recordType!{b5a3ddfe-bf55-4e0a-899f-94116fd09520}DE SuperReport.fields.{982f3d1f-3e61-43e0-a22f-9d692ff770af}'] Please advise.

I have created a sync/web based record type. However after changing the underlying data in the source, I do not see an option to modify the  model.  Pleas advise. 

Hi everyone i am new at Appian and i m trying  to understand how i display the labels and the choice values that comes from a DB . into a dropdown and save it in a rule input after its throwing an error that i dont understand. can someone explain what is my error and what is the better solution for doing this ?  thank your

I have this error message in the record  type, I tried to change the number of row per page but not worked And the source data around 6500 raw. Anyone know the solution? Thank you

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?