Records

Hello, I'm displaying a selectable read-only grid on an interface, and the grid is sourced from a record type (entity-backed).  Based on what row the user selects, I want to use various fields from that row elsewhere. I.e., a!gridField( ... selectable:true, selectionValue:local!mySelection, selectionSaveInto: { a!save(local!selectedRow, index(fv!selectedRows, length(fv!selectedRows), null)), a!save(local!mySelection, index(save!value, length(save!value), null)) } ) My local!selectedRow looks great.  But, when I try to reference this elsewhere, like: local!myselectedRow.name I get an error: "must be indexed by its corresponding record type fields or relationship". How can I index this as if it were a CDT? (which...since it is an entity-backed record, I would think I can treat it as a CDT of that entity type). My only workaround is to do a cast() within my saveInto, but I hope there is a cleaner way.

i have a requirement where  "close" related action should be visible when status is not denied and closed .  i kept this condition in  " views and action security " but the relatedaction is still visible on the request when status is closed/denied also

I have updated parent CDT(UK_AWTS_Requests) to add 2 new fields. While creating new version using xsd, I was getting below Info warning for one of the child CDT(UK_AWTS_REF_STATUS) present in it. I ignored above , created new CDT and promoted to Runway. However in Runway all the dependent objects are still referring to older version of CDT. Also all dependent objects are showing ^8 special character. Can somebody tell me what needs to be done in this case.

I have a requirement to add a new field, contained in a record, to an existing process report. In an interface a gridField with filters is used for displaying the task data, but cannot find a way to get this data in a way that makes it available for both new and previously started active processes. Process Report is tasks per process model Process Report is tasks per process model Process uses Records for data management () Requirement to get additional data from the Process into the Process Report Additional data is a value found in the Record Process reports cannot index Records Less than ideal solution has been to add process variables for any data point needed from the record These single data point process variables can then be seen in the process report Process report is displayed in an interface using a a!gridField() Data for the gridField is pulled using a!queryProcessAnalytics() a!queryProcessAnalytics() uses logicalExpressions in an a!query() to filter data Query filters

We are building a case management application that support many ad-hoc relationships among different record types. We are using data sync, but anticipate to exceed the 4M row limit eventually. What strategies should we consider for this? The documentation suggests adding source filters, which makes sense; but no longer will all the data be available in the record type. Do we move all queries to a!queryEntity but allow all writes to continue using a!writeRecords? If so, then we'd want to make sure all our record queries are in expression rules so they can be updated to queryEntity. 

Hi All, I have a scenario where I want to open a site with the record data context thought a mail sent to a user. The user will click on the site URL present in the mail and then he will be directly navigated to the exact context of the record data and the page where he want to go with the record data.Can we achieve this identifier scenario for a recordtype based site URL?

Greetings everyone, I had found a previous post from 7 years ago, however the solution found is not one that works for our use case.  We have a usage monitor application that pulls data from the csv files of login-audit.csv from the shared-logs. Currently, files of login-audit.csv are stored in a folder inside the application's Knowledge Center. I was wondering if there is a method to getting files from shared-logs into Knowledge Center folder. The plugins such as login reader and login information parser would not work in this case as the data is pulling from the folder in knowledge center already. I was wondering if this can be kept intact, and if there is a way to automate moving files from shared-logs to knowledge center. 

I have a one to one relationship between WorkItem and Lead where workitemId is a foreign key in Lead. I first create workitem and then pass its id to lead while creating lead. Conditions in table, workitemId is unique and not null. This has been working fine in previous version of Write Record Smart service but in new version it is not working and giving error for workItemId not being there. Lead: {leadId=505, workItemId=2843, qualityScore=4} This gives error: Unable to write to the source due to system error. Error Details: Field 'work_item_id' doesn't have a default value. Note: Same input still works with old version of write record smart service. In logs I see it creates prepared statement without workitemId field:  Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO `PRO_Lead` (`quality_score`, `lead_id`) VALUES (?, ?)]; Field 'work_item_id' doesn't have a default value; nested excep

Hi there, I have a desired requirement from a client about checking to see if two values are an 85% match. So for example, if a user entered ABC, Inc. for one value and ABC, Co. for another, it would be flagged. This is just one example, if the similarity of names was in the middle or end of the value, it would also be flagged. I just can't seem to wrap my head around any logic to make this possible. Any suggestions? Thanks!

Actually i am getting a csv  document from sftp to the staging table i am writing expression rule to count the data. so here i am getting a error memory threshold reached during output conversion. Can some one give perfect resolution for these. 

Hi All, We are using MariaDB. Is it mandatory to provide after keyword in alter table query while adding new column? We are moving from lower environment to higher environment. In lower environment, the columns are in a certain order and in higher environment, we are trying to add the columns in the last and not in the same way as lower environment. Eg: In lower env, table is like firstname, middlename, lastname. In higher environment, it will be like middlename, firstname, lastname. But both environment CDTs will be like firstname, middlename, lastname. Will these cause any issues??

We have a record type hooked up to a table.  Adding new records works well.  But, there is an issue with record edits.  The record gets updated in DB, but the auto record sync following the record update fails.  Here is data from error email: Problem: An error occurred in executing an Activity Class. Details: Unable to sync due to a system failure. Recommended Action: Examine the activity class to correct the error and then resume. Here is some relevant data from tomcat-stdOut.log: [http-nio-8080-exec-734] ERROR com.appiancorp.record.service.RecordReplicaUpdateService - Loading updates to synced record type(s) in ADS failed, invalidated record type(s): ...com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system failure. (APNX-1-4521-016)...Caused by: com.appian.data.client.AdsUserInputException: APNX-3-1000-030: Invalid transaction data. Cannot update the same entity multiple times in the same transaction. Invalid id(s): ... Note: E

Hello, Having two environments (PAM and PRO, both on cloud), I want to copy the database schema from PRO to PAM under the name "Appian_pro". After that, on PAM environment, I want to delete the "Appian" schema and rename the copied schema as "Appian", all of this to operate with Pro data on PAM.Would be possible to perform these steps? Thank you in advance. Regards

How to show Record Sync History on the interface as read only?

Would it be possible to remove any option from the dropdown on the filter? Also, we have created a ‘Custodian’ dropdown and are passing that value into the record filter to filter the records dynamically. However, there seems to be an issue when we export, such as not showing that value in the filter because that value is not part of the filters. Would it be possible to set that value programmatically?

Hi All, I have a scenario where I want to use the filter logic configured in a record type by calling the filter on the interface.The filter is functional in the record type object, and I do not want to query record type and add filters indectly by creating a dropdown and linking the filter to that.But, I want a logic through which I can directly call the record type filter on the user interface.Is it possible?

Hi All, I am facing issue with record sync while writing dataset to the database table using write records.This works fine if we sync record manually , data is inserted , we get the primary key back to the process. The record is a simple record with no relationship defined. Going through the community posts , this issue comes when we have BIGINT type of datatypes defined in the table. So need to verify how to solve this issue without changing primary key column from int8/BIGINT to INT, as we need to store the values greater than int4 range in the database. Is there any way to make this sync work?Kindly guide.Attaching the screenshot. Thanks

Hi there, I have a map type process variable (maybe name it as "vv") in a process model, with data like this: {returned=[mat=111, pt=5555, sc=44, bn=EEE],[mat=222, pt=3333, sc=44, bn=III],PopUpText=No records found, LoginStatus=true, connection=xxx} A CDT "returned" is defined with the 4 fields (mat, pt, sc, bn). And I define a CDT process variable "r1" which can store multiple values. can I use the following to get the "returned" data in MAP variable "vv" to CDT variable "r1"?  save pv!vv.returned  into: pv!ri could anyone know? thanks! Lin

Can I ignore case sensitive in Query Record Type as I do automatically in Query Entity? The record type I'm using has data sync enabled and I need to put a validation on a text field to give evidence to the user that there is already a line with the string he is typing. I built the validation into an expression rule that invokes the Query Record Type and I noticed that the filter is case sensitive. Thanks

How could I query a database using a!queryFilter where the field it checks is an integer and would check if the search value is included in the whole integer?e.g. If I searched "123" and one of the record items had an Id that is 123456789, I would like that item to show up in the resulting list.

Hi everyone,  I'm having a CDT (CDT01) with fields: {id: int, name: text, information: {id: int,fieldId: int,address: text}} As you can see, the information field contains a different CDT (CDT02) that is nested inside CDT01.  I would like to sort a list of CDT01 based on CDT02.fieldId. Is there any solution for that? I tried toDataSubset and dataSubset but seems like I can only index the first layer of the CDT.  Thanks for helping :)

Hello,      Why and what is better to use data type or record type?   Thank you.

Hi i am getting 404 error when i am trying to use webapi/printRecordToPDF approach for printing record view from a safe link.  if anyone encountered same issue would appreciate steps to resolve the same. for safe link i am sending record url along with identifier and url stub and onclick i am trying to invoke windows print method for pdf. Thanks in Advance

When I try to add a Record Type Event it is impossible to add history and event type names : anaything I insert in those field get erased 

Record Type Custom Field Column Creation: We have a one-to-many relationship between two tables and need to retrieve a particular record based on a condition. Please let us know if this is possible using a custom field.