Records

Hi , when I sort on a record backed read only grid , sort field that is stored is in the format #"urn:appian:record-field:v1:ff132d24-cf88-4234-88ae-9fe224dd3dfd/b05761f7-3e63-4e76-bb2b-10c4886815d8. I need to store this sorting preference for each user level. This is not being stored in record field type. its type is string. Even if i want to cast it to record field I am getting error that cast invalid. Only way i could find to covert this into a record field is by using eval() function. But eval() function is a hidden one. Can some one give me an idea on how to handle this? Thank you

Hi there, Our business is having a problem when using a queryEntity in Appian for a certain field. It converts that field to an NVARCHAR(4000) (I'm assuming because it's a text field) even though our Database and Data Type have it listed as VARCHAR(50). In SQL Server, when comparing an NVARCHAR to a VARCHAR, it causes an implicit conversion of all data in the VARCHAR column which is a big performance hit for us. Is there any way to make sure that the parameter uses VARCHAR(50) instead of NVARCHAR(4000)?Thank you

Hi All, I am working on a use case, where I have configured record with integartion(service backed recordrd type) using a dynamic link in a grid to redirect to summary page, I am getting "The record data does not exist, has been deleted, or you do not have sufficient privileges to access it. (APNX-1-4205-006)" this error while clicking the link to see summary . Can any one please help me what configuration needs to be established to see summary page. .a!localVariables( /* 1. First, configure the integration object to return successfully */ local!integrationResponse: rule!GI_INT_GetClaim(adjustername: "ABC"), todatasubset( a!forEach( local!integrationResponse.result.body.claimsList, cast( typeof( 'type!{urn:com:appian:types:GI}GI_RESP_GetClaimSummaryClaimList'() ), fv!item ) ) ) ) I am getting this output. Am able to see the data in the grid but not able to view summary. Help me to resolve the issue.Tha

I have a application , where customers can see their invoices . For ever customer we provide a user id . we store all the invoices across the customers in a recordtype  INVOICES. Now when a specific customer logs in this is the start page. I want to show only the records (invoices) speciifc to customer I am using SITE and Invoices as Records/List

Hi Team, After creating a CDT properly, I am unable to verify  Entity mappings in the data store. It is giving me the below error. Note:- Record type is generated and synced with the table already available in the DB. I want to keep my table name in uppercase [NT_NH_Handover_History] but during entity mapping i downloaded DDL, it is asking me to create a table with the name in lowercase ntnhhandoverhistory. I have to keep the table name in upper case. Could you please suggest?

Using the a!syncRecords function is there any way to see that the record has synced? I looked at the actual Record and the sync history was not updated.  I looked at the tomcat log but can't tell what would indicate the synced record?

Hi all, We are switching to a full record centric approach for our new projects. In our old projects we used to have an expression rule "XXX_setCdtDefault()" this would set the fields createdBy, createdOn, lastmodifiedBy and lastModifiedOn for each CDT right before saving. if( a!isNullOrEmpty(ri!cdt), ri!cdt, a!update( ri!cdt, { "createdOn", "createdBy", "modifiedBy", "modifiedOn" }, { a!defaultValue(ri!cdt.createdOn, now()), a!defaultValue(ri!cdt.createdBy, loggedInUser()), loggedInUser(), now() } ) ) Since we will now use the Write Records smart service, we are no longer working with CDT's. Is there a way to do the same thing as before in a generic way for record types. If we want to update a record type, we need to pass the references to the record fields, so we cannot use the generic "createdOn" etc..I have come up with a workaround as shown below, but I would prefer it if we could j

Hi I am using The "Import From Excel to DB" smart service. The data so written into the DB is not synced with the record type for the same DSE. For using "Sync Records" smart service it is asking the identifiers of the newly added records, which i do not have. How do i force a sync after the data is extracted from Excel to DB?

Here I want to get the most visited top 3 destinations and the count of journeys on each location.(relationship between 2 tables) So make an expression rule for that. but I need to do with record type with the use of a custom record field, here i found the custom expression rule, anyone guide me on how to use this code with a custom expression rule in record type? code below here a!localVariables( local!data:a!queryRecordType( recordType: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey', fields: a!aggregationFields( groupings: { a!grouping( field: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey.relationships.{324614a4-84f3-45b4-bce2-95cbc8b65b6d}vsDestination.fields.{dbe0e7f1-b3d7-456b-9d82-e81a9042d256}name', alias: "name_grouping1" ) }, measures: { a!measure( function: "COUNT", field: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey.fields.{1209585a-f527-4ad9-b1fc-cc7ccc5dd973}de

Hi My application is currently running on Oracle, and we have more than 1000 entities created as CDT's in Appian for the database. Now we are migrating from Oracle to MySQL. Now Can I change the source of the existing CDTs from Oracle to MYSQL from their XSD files without creating new CDT's. Any suggestions please. Thanks, Srikanth

Hello guys, i am trying to combine my list of contract numbers with contract line attributes, where a contract line can have multiple lines. So for example my list of contracts (local!contracts) contains attribute like name, id, etc... The contract line items (local!contractlines) contains different attributes of a contract like chargetype,currency,lineId, amount, etc... If there will be only 1 line of contract i can easily achieve the required output using a!forEach like this: local!finaloutput: a!foreach(                            items: local!contracts,                            expression: {                           {                            contractName: fv!item.contractName,,        

Hi, I am trying to make an interface wherein I have a read only grid that displays data from a table stored in the database. Now I wrote an expression rule to fetch the data and passed it in the data parameter of the read only grid. I want to implement pagination so that only 10 records initially are shown, clicking on the side arrow button '>' will load the next 10 records i.e. I will be running the query again and again for every 10 records changing my startIndex and batchSize. this will ensure that the query will not fail if the data is huge. I wanted help in implementing the pagination as I tried implementing a few things and it didn't work. I'll attach what I have implemented. PS : The pageSize parameter will not work, as the requirement is to "not use" pageSize.    This is the expression rule where increment tells the batchSize, and times lets me tell the startIndex This is the interface code

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

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 ?

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 */ }

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