Records

Ran into an issue where any writes to record A were failing because record B had a sync issue. Record B was the Event Type Lookup for Record A, which was why record A writes were failing. The error in our logs is below: It sounded like the issue here: (+) Appian Community, however the difference was that our scheduled daily sync for record B passed just that same morning. No updates were made to record B, and no new data was added to record B recently enough to cause the issue. In addition, while there was a warning icon next to Sync History for record B, there was no history of any failed syncs, and once I manually synced, the error and issue went away. I'm not sure what happened how to go about checking what kind of invalid data popped up. Anyone ran into this before? TIA

What is the main difference between a!queryRecordType, a!queryRecordByIdentifier and a!recordData. When to use a particular one?

I'm setting the Record-Level Security and I have this Expression: if( a!isUserMemberOfGroup(username: loggedInUser(), groups: cons!MIN_Administrator), /* Show all records */ null(), /* Show only records that belong to the particular company*/ a!queryFilter( field: 'recordType!{5608cfad-fc67-4a81-93b5-722c9b55f2c5}MIN Test API.fields.{d1b51e83-1de8-430a-8d7c-e6e433601ad4}company', operator: "=", value: "*CompanyNameAsAParameter*" )) If the current user belongs to the Administrators group, they'll see all records; otherwise, they'll only see those whose "company" field has a specific value ("*CompanyNameAsAParameter*"). This value will vary depending on the logged-in user. Is it possible to pass this parameter from the interface, or is there a workaround?

I have a Record Type with a large data. When I add it to a Site I can see all the records but I want every user see only their related data using a particular field ("user"). I'm using the showExportButton and showSearchBox properties and if I filter the RecordType I lose them. Is there any way to filter the data for every user and continuing using all the parameters of the Record Type? Thanks!

As you can see, I'm creating a new Record Type from a Webservice. I get de data properly. But when I try to sync the data in the Record Type I get the following error: Type could not be inferred due to inconsistent types for field(s): discountPercentage I think the format is ok. Do you why I getting the error? As you see bellow in the Expression Rule commented code, I map the fields formating the decimal fields but I don't to do so because I would map all the fields. Any idea to solve it? Thanks!

Hi  I have related records : Purchase Orders - item code, qty Items - item code Pricing - item code, price, effectiveDate An item can have multiple prices so there is a 1 to many relationship. I am wanting to use the custom record field on the Purchase Order record to calculate the cost of the Purchase Order ( Purchase Order. qty * latest pricing for the item) I have an expression rule that returns the latest price for an item however the custom record fields does not allow us to use expression rules. Also, since an item can have multiple prices, I am not able to get the latest price from just using the . notation from the related records. I need to have the cost in a custom record field , as I need to aggregate the cost by supplier. Please advise on a way to achieve this. Thanks

Hi, I'm using email to trigger process model. By setting public events in process model, I'm able to get data into process variables. When I'm trying to write it Records, I'm getting below error. The input "Records" refers to an invalid record type. The record type does not exist, has been deleted, or the user does not have sufficient privileges to access the data. I understand that record types doesn't have permissions. But how to provide permissions is what I need know. Thanks in Advance. Thanks, Sadhu Surendra

We have a record with a large complex Security Expression defined in Record-Level Security. When querying this record using an a!queryRecordType, the query takes ~1,500ms (90 rows, ~ 16 columns) When querying using a!recordData in a gridField, the query takes over 13,000ms To make the test fair, we have have kept just 1 column in the grid showing the ID of the record, and have not defined any sorting, no filters are applied for either query When the record level security is turned off,  a!recordData in a gridField takes 253ms to run. What might be causing a!recordData to perform so much worse when record level security is turned on?

Hi All, We have below requirement, please read and assist me on this. We have 2 Event data:                                1. Request Event data                                2. Task Event data We need to merge above 2 dataset and show details in a single page with using Event Timelines patterns/components. Can you please check and assist how we can achieve? When we are taking Event Timelines patters with selecting records type then, we can select only one record type as a time under Event Timeline components but we need to take both records type and then make the relationship on script level. Please provide solution for achieving above. Thanks in advance. 

Hi All,We faced one issue during deployment to production. We have an API which triggers a process model and we are saving into database using write to records. Yesterday we added a new column to that record and it was getting deployed. During that deployment window, we received some cases via API. Details were getting written to database but while trying to query data, no data was being retrieved. The record was being updated and sync was occuring during that time. This is the first time we are facing such issue. Has anyone faced similar issue? Any reason this might have occured??

I have the local variable called "encargo" to get a single record from a RecordType filtering by an id key. I want to get all the fields of the record type. Is there any way to tell it to the "fields" parameter or have I to list all of them instead?: local!encargo: a!queryRecordType(  recordType: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian',  fields: {    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{48d20aa7-6bfb-42ac-9ea0-0396fafa7ffd}fechasolicitud'  filters: a!queryFilter(    field: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    operator: "=",    value: ri!id  ),  pagingInfo: a!pagingInfo(startIndex: 1, ba

Felw amount fields i have created as DECIMAL in Database, but it got mapped as INTEGER in Appian record. How to get decimal as a datatype in Appian as well? What should be the source field datatype to achieve this?

The Appian product works with its own database in which it stores its internal process data or Record Type synchronization, right?So, if we want to have a database in which we store, for example, Master or audit data, is it advisable to use the Appian databaseor create another one for the project we are developing?Thanks.

Hi all. I'm starting a new app and I have big dilemma because I don't know if is better to use CDTs or Record Types. I won't connect directly to a database to get/post records but I'll connect to a webservice to do so. You have to keep in mind that the records can be added/modified/deleted from Appian calling webservices or from other non Appian applications. So, If I use Record Types, I'll get the refreshed records without sync every few minutes? Has anyone experience about this topic? Thanks in advance.

Hi Everyone,I have a table with one column type as JSON datatype and using to save the data through write to records. Now I have to export this table data into excel file and share it everyday so I have created a CDT for that table.In CDT it is defaulted to text even I have given longtext datatype. Now there is an issue with the data as the database table have more than 4000 characters the CDT is not allowing more the 4000 so my data into excel is not exceeding more than 4000 characters.Please suggest how to handle this or any alternate better approach.

Can I create Service-Backed_Record with POST API which returns data on input parameter, How differently it works from GET API. What could be the possible I may face if I use POST API for Service-Backed_Record.

Muy buenos dias  estoy realizando el curos de APPIAN y el comunity no me esta dejando crear nuevos recorda Type ya no aparece esta opcion como antes en la imagen adjunta les muesto como apareceia antes y como esta apareciendo ahora  Alguien me podria ayudar por favor ?  quedo super atenta 

HI. I attempted to do a rather large import of an application over our PP environments version. I looked over a record that had some Record Related Action name changes to it. Testing it afterwards, only half of the related action name updates took on import.  I confirmed the record was modified on import. Has anyone ever had this happen before?  I have no way to deploy proper changes due to this.

Yesterday I created a record from a Record Type list action. I can see the record in the database and when I open the Record Type View I see the record as well. My doubt is why I can see the record if the last sync was last month. As far a I know, when you use a Record Type it is necessary to sync the data. Is there any way you can configure an automatic sync or sometrhing like that? Thanks.

Please suggest  how can we calculate years given by days using record types

We have two separate databases: a legacy one (Oracle) and a current one (MariaDB). We do not want to import the legacy data into the current database. However, our customer wants to be able to search records across both databases. The requirement is to connect both databases to our current application and build a search interface on a single page. There is no relationship between the two databases; the cases exist independently in each database and need to be merged for the search. Is there a way to connect both schemas and build a unified search interface? How can we solve this problem using Appian?

Hi, I have a 2 record with one to many relationship. I am trying to write the parent and the related records. The child record will have multiple values . Each value should get inserted in different rows. When I tried foreach loop for the related record it is storing all  the values in the same row of child record. Please help me with this

Created new record type for subscriber Added relationship with base record type Eventhistory eventType event thread configured. flowed below steps  On the base record type, edit the record events configuration: Go to Events. Click EDIT. Configure the following Subscriber properties: there is no option to add subscriber record and unable to see the subscriber icon on event history in summary view  anyone implemented please post your suggestion  @Everyone  we upgraded now to 25.1.  while enabling subscriber am facing issue a!eventHistoryListField [line 736]: Unable to write to or delete from the source due to a data integrity violation. Error Details: Field 'ID' doesn't have a default value anyone faced the same issue, any suggestions or inputs helpful thanks in advance   

I have a process that needs to store entities and alerts in different tables. Flow of the process: First, I need to save the entity using the Write Record Smart Service. After the entity is saved, I need to get the ID of the created entity. Using this ID, I will then save the corresponding alert with another Write Record Smart Service. Question: Is there a way to get the ID of the newly created entity directly from the Write Record Smart Service, without having to perform an additional query from the record or database? Here is the example of process:

Hi all, I'm a bit new with custom record fields, so I'm probably doing something wrong. I have header and detail records (with a one-to-many relationship connected with a detail reference to the header key), and that data flows throughout the system just fine.  But I added a real-time aggregation / sum custom field (for totaling amounts in the detail record for presentation) and am having trouble getting data into the new fields. When pressing the 'Test' button in the Edit Custom Record Field screen, I see data grouped and summed as needed which is great! After saving the new custom field, the 'Data Preview' test button does NOT return any data in the new field, and that is also the case with an interface that references this. I've done resync on both records.  The new custom field exists on the detail side of the relationship and when defining the field, I use the format: headerRec.detailRec.amountToBeSummed. I've a