Records

a!recordFilterList( name: "Employee Name", options: a!forEach( items: local!data, expression: a!recordFilterListOption( id: fv!index, name: rule!CMN_PLATTS_GetUserFullName(fv!item.employeeName), filter: a!queryFilter( field: 'recordType!{c3db295c-a167-41fc-84b6-90d578db6968}Employee.fields.{employeeName}employeeName', operator: "=", value: fv!item.employeeName ) ) ), allowMultipleSelections: true() )

The main question is about how Appian cache the data when you relate a record type to database tables. Also does this cache mechanism provided when you relate a record type to database views. 

Hi Guys Is it possible to run mulitple instances of Write Records smart service as a single transaction, i.e. if one of the instances fails, all updates made by previous instances are rolled back? According to docs, Records can only be updated for one record type at a time (https://docs.appian.com/suite/help/23.1/Write_Records_Smart_Service.html) So say I have a record type representing a bank account. And I have a process model to transfer money from one account to another. The high-level steps are: 1) Update balance of account 1 (deduct the amount) 2) Update balance of account 2 (add the amount) If step 2 fails, account 1 will be charged, but nothing will be added to account 2. If there is no option to run the 2 actions as a transaction, what is the best practice for handling such cases?

Hi, all! I just prepared my site to get data nd put It inside a ri! to send to a table at DB, i tested at model process and just worked good, but when I try to do on the site give the follow problem. Can someone help? I really need make it works.

Hi Team, I was facing some issue while querying and performing larger data such as approx 1M+ data at a time. Considered I'm querying data from approx 5 table using some filter to reduce some search results and storing in seperate variable with the help of index() function. Even I'm having more data and I'm performing approximate n time (rare case n^2 times) as looping so Appian expression rule was failing shows as one pop up with please try later in the code such approx 502, 504. Is there any limit in Appian hold particular level of data or no such limit? Anyone has any idea is there any better way to handle this larger case of data... Thanks and Regards, Vigneshkumar Radhakrishnan

Hi, After every user input task completed i have called write to data store entity to insert data to table so over all in main process i have called three times so after every user input task a new row creating the values is not getting updated but after every user interaction a new row is getting inserted. i have updated the details correctly like below in input and also in output tab i stored the ac values to cdt. kindly suggest me on this and autoincrement i have given to Id column in cdt Query:

when we apply multi-select dropdown .. comma separated value is getting store in table in single row ..but i how to put in different rows. Output i am getting  Field Field Value Dropdown 1,2,3,4 Expected  Field Field Value Dropdown 1 Dropdown 2 Dropdown 3 Dropdown 4

Hi All, I am new to Appian, during one of my solution development I have found that I have deleted the rows from the oracle table and when I am trying to test the expression rule where I used Query Generator to get the data from that table , it's stil returning the old data. So can you please help me to know that how can I clear some cache or sync it with my tables ? I am using query generator to generate that expression rule.

I am working on "Interfaces 103" in the lowcode4all curriculum. I made a mistake and deleted the PF_Goals Record Actions - Delete Goals and Update Goals. Now I am unable to generate any record actions. Please advise me on what to do next in order to continue building the interface.

Hi Is there a way to sync all records within an application? Thanks

Home Page displayed with following error message  An Error Has OccurredCould not find "store" in either the context or props of "Connect(XrayConnectedComponent(Pure(Interactive(XrayComponentSelectionManager))))". Either wrap the root component in a <Provider>, or explicitly pass "store" as a prop to "Connect(XrayConnectedComponent(Pure(Interactive(XrayComponentSelectionManager))))". Expected:Application Should free from expression errors

I'm updating my database table using the "Write to Data Store Entity" I have an array of uploadId's that are my primary key. When writing to the DSE, I'm passing additional information like the current time now() and some other text values.  In the error (see image below) you can clearly see that the first uploadId (10473) is passed with the additional information. However on the 2nd iteration (uploadId 10474) all of the additional values are null. How do I pass multiple values using this smart service?   Thanks!

So I have this code that works when I test the interface, but when the test values are empty it displays this: I want to still display the interface while the index List is empty. I tried a few things but so far nothing has worked. Here's the text field's code: a!textField( label: "Program", labelPosition: "ABOVE", value: index(local!program[ri!tpsRequest['recordType!{63733d83-c1fa-4244-bcca-b0ddcccccbf4}DS_TPS.fields.{dbc3f6e3-0ead-4aec-969e-561c93c12055}programID']], 'recordType!{0ad1112a-64a6-465e-99da-48e839d78914}APR Program.fields.{64faa577-dd6f-4073-902d-57142bb77458}name'), align: "LEFT", readonly: true, ), And here's the entirety of the code: { a!sectionLayout( contents: rule!ACE_SCT_DynamicBreadCrumbTrail(isInterfaceDark: false, recordName: cons!ASK_TEXT_LABEL_REQUEST), divider: "BELOW" ), rule!ASK_SCT_RequestDetails(request: ri!request), a!sectionLay

I just want to understand why list of records(0 items) is not returning null/true in below scenarios. I have problem returning the List of Empty Records to be empty/null. Any thoughts?? We always practiced using null vs 0 vs "" vs {} depending on the type of data. However here {} for set of array records is not working to identify as null. Of course same behavior with CDT's as well.

How to update a single field for a record? Any idea! Reference Link :: Update existing data

Hi Experts, Currently I'm working on an Enhancement Project where in the legacy Application we were using CLOB field to store comments. Since CLOB is not available in MariaDb as a dataType what would be the recommended datatype to use in New System.The max number of chars that we have for one of the such comment is 21499 chars. What all will be the pros n cons of using VARCHAR(21499) vs BLOB datatype, and also if makes any impact on the performance of the record and UI using the comment table. Thanks, Gaurav Singh

Hi, I have an URL of the format : https://www.google.com/<unique_id>_<fileName>_<remaining url> Now my requirement is I want to fetch the filename out of the URL ... the first part will always remain the same  i.e. first is https ... till .com/ then comes an unique identifier  then followed by '_' then followed by filename then followed by '_' and the remaining URL  Can anyone help me fetch the filename ? 

Hi Team, Got confused while doing some calculations in Appain Expression rule. Added input and output below. i have tried fn!union() function but it was failing sine input was only one array. Code: fn!union({ 1, 2, 2, 1, 3, 1, null, null }, {}) Sample i/p -> { 1, 2, 2, 1, 3, 1, null, null} Expected o/p -> { 1, 2, 3}  Current Appian Design: Thanks and Regards, Vigneshkumar Radhakrishnan

Here in this image the expression should only return seatno and gender field without pid. Can anyone please help me with this?

Following normal database best practices we typically store id fields in our main data tables and then link those id fields to reference data tables when we want to display the reference data values (e.g. status values such as 'Received', 'In Progress', 'Pended', 'Abandoned', 'Completed', etc.). With the new record and relationship functionality it is easy to display the textual status values rather than the id value on the record list and record summary. But, if we need to export the data, including the textual values, to a CSV file for ingestion by an MI tool we can't currently export from a record to a csv file programmatically (our export for MI would typically be a scheduled process running once a day, outside of standard business hours). We could create a database view to pull together the data and structure it for the MI extract but the documentation for the Export Data Store Entity to CSV smart service states 'Because database vie

Hi Everyone, I am new to Appian and still learning basics. While updating a record, I am getting Data sync error. But if I do manual sync, record is getting updated. What should I do for automatic sync instead of doing it manually after updating a record? I am not using CDTs or DSE.

Hello Community,I need to upgrade a table where there are more than 1 million rows available, I want to know can this operation be performed at Appian end, I am thinking of retrieving the data in batches of 5000, that batch needs to go through encryption/decryption function. Since this processing needs to be done at Appian end, so cant use Stored Procedures for this. Will Appian be able to handle such load ?Any suggestions will be helpful ?Thanks in advance.

Hi there. I have used write records smart service in my process model and I have configured both input and output nodes. But I'm unable to capture records updated into a variable in write records.

Hi, I have an API that has an output that looks like below. can anyone suggest to me how to add data to the database without changing any output from the API?