Records

We have a table with below fields we want the output with same firstName, lastName and phoneNumber with different city Table Result can we achieve this by a single DB query without writing any views/sps...

I have scenario as below - Country List Country Code Field Name France 1 Country_Field Germany 3 Country_Field USA 4 INTAKE_FIELD EUR 2 INTAKE_FIELD I have to populate a column in generated excel which must contain values after translation based on selected value of Field Name in mapping with Country List and Country Code. Output file must generate column like below - 1 4 13 27 89 5 7 8

Hello There, Could someone please let me know if there is any plugin which we can install to mariadb, which shows me queries Appian application is firing. We have received notification from database that there are lots of queries firing as cross join and it should be fixed by index. We have checked indexes and mostly indexes are in place. Therefore any tool or any help which help us fixing this issue would greatly be appreciated. Thanks

Hi, I am trying to save data in appian db which I am getting from an api call. API is : https://run.mocky.io/v3/ac936aeb-6ae5-46e1-ab38-b953ab3ac2a5 [Below is the body that I am getting after running API call in Appian] [{ "FXRateMicroservicesSuite1": [{ "FXR": [{ "FXRateGET": ["test step 1", "test step 2"], "link": "FXRateGET.com" }, { "FXRateMiscellaneous": ["test step 1", "test step 2"], "link": "FXRateMiscellaneous.com" }, { "FXRatePolicyServer": ["test step 1", "test step 2"], "link": "FXRatePolicyServer.com" }, { "FXRatePOST_DELETE": ["test step 1", "test step 2"], "link": "FXRatePOST_DELETE.com" } ] }, { "Script2": [{ "Test cases": ["test step 1", "test step 2"], "link": "Script2.com" }] } ] }, { "FXRateMicroservicesSuite2": [{ "FXR2": [{ "FXRateGET2": ["test step 1", "test step 2"], "link": "FXRateGET2.com" }, { "FX

After the data sync in Records the data is in cache to retrieve swiftly. Where can we see that data after the data sync in records to compare with the previous data sync?

The Appian Documentation below does not explain how to prevent the updating of an existing value. I want to bring in new data, but if the primary key already exists, then I want to retain some of the old data while updating other values. I tried doing something like: if(isnull(rule!Query_Existing(pv!data.PrimaryKey)), "new data", "old Data") and save into the field And the rule above passes the primary key and searches for the "old Data". The rule works by itself, but when I do this if statement, I get a null pointer exception.  Appreciate any help on this. https://docs.appian.com/suite/help/21.4/Write_to_Data_Store_Entity_Smart_Service.html Updating an Existing Value The data that you write can update an existing record when a primary key is properly configured for the entity and provided by your node input. Saving a New Value Saving a new value for an existing record does not merge the records, the old record is overwritten.

Hi Team, Record view summary not getting refreshed after the update related action. Its reflecting only i click manually on the record summary view 

Hi All, I am using a record to show the data in read only grid along with selection. I have to use a database view as a source for record,along with user filters,export to excel functionalities and search box. Since it is a view,I am unable to do the Data sync.But it lands in a performance issue as it takes more time to load. Is it possible to do Data sync for a view? Thanks in advance.

HI All, I want to query all of the data that older than 30 days in the DB.  Can an someone suggest me how to achieve the filtering thing from db? Thanks in advance

I am getting the below issue while updating my CDT. The data source schema does not match the type mappings: Wrong column type in GDMPMDEV.dbo.VT_VW_PRCF_MODULE_PARAMETERS for column Description. Found: ntext, expected: NVARCHAR(255) (APNX-2-4056-000)

I created a view and CDT on top of it;however Data Store is failing to publish the new entity with below error:  The data store "FAS" [id=5401] was saved but cannot be published: An error occurred while trying to modify the data source schema: (conn=267964) 'Appian.FAS_VW_GET_WORK_REPORT' is not of type 'BASE TABLE' (APNX-1-4178-000) I downloaded the DDL as mentioned and it doesnot look appropriate, please check the DDL update suggested below: /* UPDATE DDL */ alter table `FAS_VW_GET_WORK_REPORT` add column a_id bigint not null; @Table(name="FAS_VW_GET_WORK_REPORT") @Column(name="COUNT", columnDefinition="INT") @Column(name="USERNAME", columnDefinition="VARCHAR(500)") @Column(name="ACTION", columnDefinition="VARCHAR(255)") @Column(name="DATETIME", columnDefinition="DATETIME

Hello there, I created a view and CDT on top it. Data store is failing to verify and Publish the new entity. Below is the received error:  Added XSD for reference @Table(name="FAS_VW_GET_WORK_REPORT") @Column(name="COUNT", columnDefinition="INT") @Column(name="USERNAME", columnDefinition="VARCHAR(500)") @Column(name="ACTION", columnDefinition="VARCHAR(255)") @Column(name="DATETIME", columnDefinition="DATETIME") @Column(name="CASE_ID", columnDefinition="INT") @Column(name="CLIENT_TYPE", columnDefinition="VARCHAR(255)") @Column(name="TRANSACTION_TYPE", columnDefinition="VARCHAR(255)") @Column(name="TRANSACTION_SUB_TYPE", columnDefinitio

I have a CDT with some kinds of information Alle data in these cdt list have a start date and an end data. I have to find period overlaps. But I'm just resolved that problem. My req now is another, after I find all period that overlaps Ex: index of ordered by date array 2,3,4,5,6 of an array of 7 elements. Now seeing data I know that invervals that overlaps are 2,with 3 and 4 and 5 with 6. My problem is to find that kind of subgroups 2-3-4 and 5-6.

For one filter option I want to add to query filter in the record because the filter options are not in the cdt/table, when I apply 2 filters, it ignores the second filter.  How can I use multiple filter for recordfilter list?

i have summary view with a related action delete. after deleting a record. i get redirected to the already deleted record with the error: An Error Has Occurred The record data does not exist, has been deleted, or you do not have sufficient privileges to access it. I want to to get redirected to my recordlist view. How can this be done?

Hi, Has anyone ran into a UI performance issue after running  a record related action when using synced records.    If we load a record summary view for. synced record it will load in under a few seconds.   This load time is very consistent refreshing the page as long as we dont run an related action.      After running any related action the same summary view will take a 10+ seconds to load.   After a period of time (1/2 hour to an hour) the load the summary view goes back to loading in 2 seconds.       Can't pin-point root cause yet so thought I would see if anyone else has experienced any similar issues.Regards, Bob

I created cdt after that i need to add foreign key, to link into the view table

Hi All, We are using Orcle Database for our DB in Appian. Recently, our client want to display last updated record at the Top on Grid list. In order to fullfill this we introduce the UpdateOn[Oracle datatype date and Appian Datetime] column in our table, as we have more older record, it was hard to show updateOn date on them. We copied Created date[datatype Date in Oralce and  In Appian Datatime]. We see there are lot of record( more than 12000) which display date out of Range on updateOn column in Appian. Kindly see below. App: 1000789 Date out of range (-739921) App: 1000790 Date out of range (-739921) App: 1000796 3/10/2009 2:06 PM EDT App: 1000800 3/11/2009 3:10 PM EDT Kindly help me here. Regards,

Hi  I am using a recordActionField as link in one of my interfaces. To open the form on click of that link as modal window, I am using the related action.  When I try to show the current value of that field in related action "Display Name", in the interface, it shows me [unnamed] for most of the records and for some it shows value, though every record has value for that field.  If I use the same related action and pass other fields of same table in Display Name using rv!record[], they are displaying completely correct. Can anyone help what can be the root cause. Screenshots attached:    When using rv!record[recordName.A] field creates unnamed issue When using rv!record[recordName.B] field but works completely fine here

hi, i want to fetch data from list of list  robotic process variable in the workflow and process one by one in process model.

Hi, We are using Appian version 22.1, cloud database. Basically, we are trying to fetch Record Details (uuid, record fields, record data source,etc) from log file "hc-record-types.csv". For records that has been created from Appian CDT, we were able to fetch details successfully. But, records which has been created directly from the database schema table , datastoreentity uuid is empty in logfile. So, it is not possible for us to fetch record details from csv file with the help of datastoreentity uuid. Can you please help me where or how to find the uuid of database tables for which CDT not created in Appian OR Is there any other way to fetch record details apart from log files??

I need input a user or group type value, and filtering data. but a question emerged, if field of table is a list of user of group type, "in" of operator is not working. a!queryFilter( field:"c1", operator:"in", value:ri!user ) data: Dictionary  c1 List of User of Group - 2 item     user1(User)     user2(User) c2 ... c3 ... I expected when I input one user, if the user in the list, data is able to filter. 

My read only grid is having a column "Emp - Name" where we are concatenating Emp First Name and Emp Last Name and showing under a single column "Emp - Name". Here how to sort this column "Emp - Name" by clicking on the Header with both Emp Last Name and Emp First Name (First sort with Emp First Name then with Emp Last Name). "sortField" parameter is accepting only one record type field (In this case, i'm able to use either the firstname or the lastname to sort) Please advise.

Hi, While creating a custom records field..i cannot write an expression that exceeds 4000 characters and this is also explained in https://docs.appian.com/suite/help/22.2/records-data-sync.html#exceeding-the-field-character-limit Additionally expression rules are also not supported in custom record fields  If i have to write a Custom record field that has an expression that exceeds 4000 characters - what other options I have ??  Of course trying to make the expression shorter is an option but I am looking for other alternatives other than this. any help will be appreciated thanks jaideep