Data Fabric

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 have created one process report and then I fetched the process report data in grid by using a!queryProcessAnalytics function. then i have created link for user to complete the task(for link i have used a!processTasklink function) . when i click on the link it shows this error, the code for process task link, please suggest a way to solve this error  and Is their any alternate way to do it? .

In the function a!queryProcessAnalytics the sort field in pagingInfo can contain multiple sort field without conflicting the result data correctly? I have two fields that are to be sorted together but it seems the results are conflicting because of it.

Hi while making a column chart by make and category i can see the make detail names but my category names just appear as numbers  can somebody help me as to how to get this fixed

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, I have created process report type as context type -Tasks assigned to group for the lists of tasks assigned to group(abc,mno,xyz). and when I tried to test through the a!queryProcessAnalytics(report:"my report") it is throwing the error that "Empty context passed in for report sg1 [id=46716]. (APNX-1-4156-000)". even though I have given the report context with list of groups. Can Anyone suggest on this ?

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

Need to build a Interface to shows all users activity on tempo reports

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??

Hi all, I want to display all the tasks which are assigned to xyz groups.I have used process report for the same and also getting the task lists which are assigned to that xyz group and also getting same task more than 4 times for the same assignee.  Can someone suggest on the same? Thanks in advance.

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