Records

It seems that CDTs created in Appian and/or created from database tables then modified in Appian cannot be used with Generate New Action wizard in Record Types. It also appears that we cannot use CDTs made from scratch in Appian with Generate New Action wizard in Record Types. What is the root cause here? It seems as soon as you touch CDT from within Appian editor you cannot use it for Generate New Action wizards anymore (the Replace with existing object feature is not available or not working). Please advise. Related: Generate new action assistant Appian Community

I recreated the Record Type for my project to troubleshoot an issue with some fields not displaying, and now I'm not getting this "Generate Interface" button to automatically configure a Summary view. Is there a dependency I need to clear for the Record Type to recognize that there is no interface?  

Hi!, i´m trying to use the new action assistant, but each time i use it it creates a new cdt for each action, and it doesn´t allows me to choose my cdt. It´s rare because now you can create a record from a cdt, and then auto create a form to add record ¿but with another cdt?

I'm trying to review data offline for a scenario if user was to go to a location without internet connection but still wants to be able to review his data. Can I populate a grid field with the data from a record type that has data synced or do I no longer have access since I'm offline? In documentation it mentions to load everything onto a local variable and access the data from the variable. But by doing this I'm having trouble making user filters when using the local variable instead of the record type.

Currently getting the error below Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 29]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Team Lead"] has encountered an error. Expression evaluation error at function 'user' [line 29]: Null argument not allowedany ideas on how to solve this issue

what happen with CDT if we add extra column with database table?

How to have Record Level Security for my Appian Application where it restrict some users from editing a Record via a Site URL.

I couldn't get my DataStore to to republish a DataType association that's been around for a year. Finally, I created a new DataType from the same view and compared the downloaded xsd's Old one: <xsd:appinfo source="appian.jpa">@Column(name="isMultiplePlan", columnDefinition="TINYINT")</xsd:appinfo> New one:<xsd:appinfo source="appian.jpa">@Column(name="isMultiplePlan", columnDefinition="BIT")</xsd:appinfo> The view hasn't changed. It's still a TINYINT(1). Is BIT new with the MariaDB version? Thanks, Colin

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: