Data Fabric

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

When i re-assign task to particular user then the status is still remains to assigned not the accpeted untill that person open the task, is this a functionality or task or a bug?

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?

Hi All, I am trying to make a task report interface. This is a snippet of my report. Here, I just want to ensure that by default when a user lands to this page, they only see their assigned tasks, and only when they click on  the dropdown they should be able to view other task status in the grid such as "Completed" , "Accepted" and "Not started".Here is the snippet of my code, I tried using the local!statusfilter to be just as "Assigned", but that is not working, for now the value is null. Request some help on 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

Hi All, Need a help with this scenario - There is a scenario when a task is accepted by an user. If that user goes on leave or leave the organization and task is locked to this user, how assigned tasks for this user can be reassigned to a group.

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, ""

I'm using a record type in my grid column and need to keep a few columns as sort fields. I was curious as to whether the sortField columns impact the performance of the record type?

Hello readers, We have a previous record view, when accessing these records we want to show the records corresponding to that id in the read only grid, but instead all the records in the table are being shown For example, the airline Iberia, has a related contact But when I enter the summary, in the read-only table, it shows me all the airlines and the contacts of each one in the DATA attribute of the record type I am using the airline record  

I have a related sync record One to Many - Request and Watchers. I am trying to query data from Request record but filter the data so only those requests for which the watcher is the one provided in filter is there as well as isActive should be true. But the response i am getting back is weird. Please have a look at the attached screen for rule as well as the data. It's returning data which doesn't seem to satisfy filter criteria. Am i missing something? please suggest. a!queryRecordType( recordType: 'recordType!{5c74086c-d578-4cb3-bcc9-462eac05e87d}CLM Request', filters: { a!queryFilter( field: 'recordType!{5c74086c-d578-4cb3-bcc9-462eac05e87d}CLM Request.relationships.{456939a6-4ebb-43c0-9f2a-89523af6a1f1}clmRequestWatcher.fields.{72eced9d-9111-4afa-9a19-ec3dbb59e196}isActive', operator: "=", value: false() ), a!queryFilter( field: 'recordType!{5c74086c-d578-4cb3-bcc9-462eac05e87d}CLM Request.relationships.{456939a6-4ebb-43c0-9f2a-8952

I have a usecase where I need to export grid data to Excel but here we need to export not only data but also the same format of each column value that we see on grid. For example we have one of the column Revenue in which we have data as $ 123,233,000 this needs to be  exported to Excel in the same way and also apart from that data in Excel should show in number format with the formatting of above example so users can do some manipulations on that data like summing up the  revenues. Data on that grid  is coming for a stored proc.

This query is simple enoughtselect noteId , miscMattersMainId , createdOn, createdBy , note from PLSM_note Those are the only fields in the table and only two records in PLSM_note,  This is being executed against the pre-defined data source that comes with Appian with almost no load on the server.For reference, when I run this same query in the loud Database/MyPHPAdmin I get Showing rows 0 - 2 (3 total, Query took 0.0003 seconds.)So what's going on as it's taking more than five minutes to complete the execution?