Data Fabric

Is it possible to customize excel name generated from Record type(Default export to excel functionality of Record type)

Dear Experts, I have a requirement where I have to Search the Request where certain comments have been made. There can be multiple comments for a Given request number hence I'm using two table "Request" and "Comments" with flat relation where comment table contains requestNumber field to create the relation between the two. Is there any way possible that I can search in the "Request" record with the comments which have made under it.  Thanks, Gaurav Singh

Hi All, I am trying to create one expression rule to get count of records created by  Tester_Group. In table, we have CreatedBy column. Requirement is to display the count in UI by using a!gaugeField(). Please help with some ideas. Regards,Sandeep

Attempting to use the records' export to Excel feature to export 50,000 rows.  Is there a method to speed up the performance because the download is taking longer than usual? There is no sorting of the data that was downloaded. We'd appreciate any advice. Thanks, Jasmitha

Hello, Let's see if this is possible, I have a record type with a list in an interface showing the download in excel button. Once per day, on an auto-launched process, I need to send the excel generated to an email address, and also send the file through an FTP directory once per day. There is any way to generate the excel inside a process and work with it? If not, there is any workaround? Thank you!

Hello , I am not clear in which case it is more advantageous to use queryrecord instead of queryentity, I understand that the greatest benefit is when I have many related records, but if what I want is to make functions of a single entity with several calculations to later use in the processes, which is better ?

In a column status I have 6 values repeated, but in pie chart I want to show 3 values percentage. How to do this?

I'm trying to manually create a related action for a record type (the auto generator didn't work). I need to create an expression rule that returns an individual record based on the record ID (according to the documentation), but there doesn't seem to be any documentation on how to actually do this. I've posted what I have currently that is not working, could someone let me know what I'm doing wrong? Thanks in advance! Expression rule: a!queryRecordType( recordType: 'recordType!{5e8d63c0-430d-4636-9dfe-e5e4c67aefc5}SH survey data', fields: {}, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ) ).data[ri!identifier] Context field in Related Acton configuration: { record: rule!SH_getSurveyRecordById(rv!identifier) /* SH survey data */ }

How To Remove Unwanted fields in pie chart.

Hi Experts, Is there any restriction in Appian on a service account with read-only access on Oracle database, to not be able to create the CDTs using those table. In my current application I have been provided with credentials for the account which has only view access for the tables. I have configured the connected system with provided credentials. But when I'm trying to create CDT's I can only find the Schema Name but not the underlying Tables. Please suggest.

Hi, We have a database table where data gets dumped in a regular interval by a ETL job. We are using database Backed record with synced functionalities. Now, we need to sync/import newly inserted data to record in a regular interval, but FULL SYNC cannot be done automatically (more than once a day). Is there any way to get those new data in Record?

Getting Below error while retrieving Data. Expression evaluation error at function a!queryEntity_18r3 [line 4]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [VIEWDT6164], query: [queryentity expression], order by: [[Sort[eventType asc]]], filters:[null])

I'm facing the following error when attempting to create a datatype. This pops up whenever I select the data source, regardless of the selection. I did not show the expression fully because it is incredibly large.  The application has just been created, with only one empty data store and some interfaces.  What could've caused this? Is it a system error? Does it have any solution?

Hi, Is there any way I can get the size (number of rows) of a view by running a code in Expression Rule? In addition, Is there any way I can write SQL queries directly in Expression Rule? Thanks in advance

Background: customer wants more fields to be shown in their record so that the Excel download would include them. One of those fields is 'country', which the CDT saves as an integer value which is matched with a country list in the cloud database (i.e. a value of 1 would be Afghanistan). To display the country properly in the record, I use one of our rules that fetches a datasubset containing the countries and then matches the country Id with the datasubset. It returns a text containing the country name in the user language and display correctly in the Record. However, what's odd is that when I download the Excel, for every record entry that has a value for country it will only display the name of the 1st Id that was matched. That means if the 1st entry is Germany, all subsequent entries will also be Germany although showing correctly in the online record. Has anyone experienced this before? What's the best approach to fix this? Thanks in advance for any help!

Hi All, Is  there any way to know how many users have logged into APPIAN in a point in time from the Appian cloud database(MariaDB). Regards, Arun Kondi

 Hi All, I have designed service back records and having some related actions added on it. Having this, i am using new component record action(a!recordActionField) on form to perform some actions.   E.g: Record A           Record B    My design :                                               1. I have interface designed and called on records summary on 'Record A'.     2. In Interface one of the section, i am calling actions of 'Record B' with record action component(a!recordActionField).     3. Now, problem Statement- every time i refresh summary tab/view, call goes to source integration of 'Record B' by record actions added.     It does seems standard behavior of ser

Hello guys, in my database ICH_Contracts i have information about my master contract saved in several attributes. In my process model this is saved as a porcess variable: contracts = [startYear=2023, startMonth=1, noOfOccurences=5, isCancelled=N, frequency=FRQ1, active=Y, createdOn=12/1/2022 4:15 PM, createdBy=jmaricl@jci.com, lastUpdateDate=12/1/2022 4:16 PM, lastUpdateBy=jlopeza7, contractType=CTYPE2, contractId=175, contractNumber=FY2300000176] I have a process variable which stores information about the child contract numbers: childcontractsnumber = FY2300000176_1; FY2300000176_2; FY2300000176_3; FY2300000176_4; FY2300000176_5 What i need to achieve is to add these child contract numbers to the contracts DB as new rows, where the contractNumber will be the values from pv!childcontractsnumber and the rest of the attributes will be just copied. So basically extend the contracts pv with these 5 new values. Can you please help me out with this? THanks

Hi We have a data sync enabled Record which uses Database Table as a source. When any data gets updated in the legacy system, We need to sync the updated data in our record. To sync the changed record, in Appian documentation they have suggested to create a web api which includes a!syncRecords() function.1. I wanted know by using a!syncRecords() whether API can sync the changed data by itself? if so, how it will typecast the data into Appian structure?2. If it is not possible, how we can get the updated data and sync the record ? Thanks

Hi I'm trying to use the QUERY DATABASE SMART SERVICE to delete few records from my database tables  My query is as follows : DELETE FROM <TABLE_NAME> WHERE ID = <VALUE> Now I want the value to be dynamic. I dont know how to pass on dynamic value. I tried using the process variables, I created node inputs and tried accessing via ac!. But none works Anyone can please help me in getting dynamic values for the query above ?

While querying the Entity whatever the first Start index (startindex:1, Batch Size: 20) mentioning up to that only i was able to get the data. When i am trying to increasing the start index > 1 (startindex:21, Batch Size: 20) getting the below error  Errors in Expression: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [COTAAuditRequestRDT14171], query: [queryentity expression], order by: [[Sort[request_id asc]]], filters:[null])

Hi When i am trying to go for 91 to 100th record in grid i was getting an error like below. Kindly suggest on the same Error in Expression: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 42]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Customer"] has encountered an error. Expression evaluation error : Invalid index (97) for list: valid range is 1..96

Hi, We have a requirement to fetch some records for a particular filter (service name from DB) and show it on the grid to the user. The issue is we have a large number of records in DB, which are more than 20+ lakhs and goes on increasing. While fetching the data from table I am facing the memory threshold error. I am using batch size as (1,-1), because I need to show all the data in the grid. so, My question is how many records Appian can handle & how many records can be fetched at a time. NOTE: i am not using Record Type, directly fetching it from DB Also can we query more than 20 lakhs record from a record type, 

Hi team, i am trying to to create an expression rule for my application where we have a master contract number (already created) and new child contract numbers will be generated based on the number of repetition defined. Example: local!contractmaster="FY2022",          (its given, already created) local!repetition=4 Result will be saved in SQL DB on Azure cloud as: FY2022_1, FY2022_2,FY2022_3, FY2022_4. Any help is appreciated. thanks

I want to ask about this function =task_avg_completion() as its output is not compatible by its description when I try to implement it in the process report. I am targeting to return from this function in my report the average completion time of a task per all process instances of a process model which is expected to be the same for all the process instances but the average completion time is different from a task to another inspite it is the same task name as shown in the following pic