Records

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

Hi, I have below Record Type(s) structure. Now when I try to load the column(s) data in the summary page from the RecordType "D", it is not loading. But, when I ran the "Data Sync" for the recordType "D" manually then I was able to see the data in the summary page. FYI: RecordType "B" is having a foreignkey relation ship with column data which is there in the RecordType "B". Any tips please. Thanks in advanse.

Use Case : I will be uploading multiple documents for a single question - Document to questions (many to one relationship ) I have a CDT for Question and another CDT for documents.(Questions and documents are two different tables in database.) Since, I need to populate the document id in the document table based on the questionaries entry - For now, I am getting the primary key of question table first (after making an entry in the database)and then  trying to pass the value to document table for multiple rows. I am making an entry in the Question table via the process model using write to data store entity smart service, then using a script task I get the ID (Primary Key) of the newly inserted Questions and save it against a new process variable. Then, there is another write to data store entity smart service and in the input node I have mapped the newly created Questions ID against the particular column. When there are multiple attachments, only the first row gets

How can I get the list of active and inactive users without using any plugin?

I added a new Record Type that is associated with a table in my database.  Next, I added Record-Level Security.  Then, I attempted to use the Generate New Action assistant to add a Create Action for the new Record Type.  I make no changes to the default values defined by Appian.  When I click the Generate Action button, I get the following message: Your record action and supporting objects could not be created. Try generating the action again or manually configuring the action and supporting objects. There is nothing special about the Record Type.  It is associated with a database table that has a primary key defined.  I have been able to use the Generate New Action assistant for other new Record Types without receiving this error. This error first appeared AFTER the recent system updates to the Appian Community Edition were completed. I have not received it in the past. I have added 4 new Record Types after the recent sys

There is a function getraurlstubbyrecordtype() in 19/.4 to get the url link directly to edit the record but its not working for 21.4. Similar way can we generate the URL in 21.4. Can any one help me with the code how to generate .  Thank you .

Hi, I have a main recordType along with few relationship. Now when I try to show one of the field data from the sub relationship, it was showing like a continuous data even though those are multiple record columns. I would like to show some type of character like ";" at the end of each column data. Example x; y; z instead of xyz Can someone advise on this. Thanks.