Records

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 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?

Hello Everyone, How can I set current schema to a particular schema/database in phpmyAdmin to ensure I execute queries on tables within that schema only. I tried with USE <Schema_Name> . This is not working.  Regards, SG

Hi Team, Is it possible to run SQL(sql is like - select and some condition between 5 tables in cloud database) in expression rule as array values-> to execute other expressions rule in unnamed rule. If possible, please share some example  let assume I'm currently queried data using sql and takes the one of the columns and adding into my custom unnamed rule input. Problem is that its take more time.  If its possible to queries the data using same sql statement as one of the parameters that will save my time eg:  a!localvariables(local!result,a!queryRecord(sql: "SELECT id FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id JOIN table3 t3 ON t2.id = t3.id JOIN table4 t4 ON t3.id = t4.id JOIN table5 t5 ON t4.id = t5.id WHERE t1.column1 = :value1 AND t2.column2 = :value2",parameters: a!queryRecordParameters(value1: "some value",value2: "another value"),fetchSize: -1)); so i assume if that local!result contains the same id which i rune

Hi All, I have created record from a view. By default  filtered to bring only data which is active and in "Edit List" I configured columns and set "rows to display" as 50. Am getting below error message . But when i change the "rows to display" equal to or less than 33, error is not popping up. Can anyone suggest why this is happening? Thanks in advance

Dear all, I'm facing an issue regarding the full sync of a RecordType via Smart Service, which contains a field with Unique constraint This is what I'm trying to implement: First, a large amount of data (several thousand rows) is uploaded to my database table. In that process, first the old data in the database is deleted, because appending the new data would violate the Unique constraint. After the new data is in my database table, I want to do a full sync on my RecordType The problem is, the sync via Smart Service results in an error due to a violation of a Unique constraint. The source data does NOT violate this constraint. I'm pretty sure the issue is that Appian still holds the old data in the RecordType. So when trying to sync the new data, Appian compares old and new data with the same Unique field, which results in the error. This error does NOT happen when triggering a full sync manually. I guess to make my approach (syncing via batches and Smart Service) possib

So, I have a relationship between these record types. I'm trying to put the value of the record type's data field into a value and saveInto parameters. It just doesn't work on the integer fields, only successfully on the text fields. I'd appreciate any feedback regarding this.  The field is correctly an integer, as is the data type in the record field.  recordType!ASK Request Item.relationships.dsSNR.fields.serialNumberQuantity a!columnsLayout( columns: { a!columnLayout( contents: { a!dateField( label: cons!ASK_TEXT_LABEL_NEED_BY, labelPosition: "JUSTIFIED", value: ri!request.needByDate, saveInto: ri!request.needByDate, required: true, validations: { if( today() > ri!request.needByDate, cons!ASK_TEXT_VAL_INVALID_DATE, ""