Data Fabric

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

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

hi I have process report that shows me all processes. I would like to get exact start, end and duration time. As our global settings is us I've used text function to get time in format  dd-mmm-yy hh:mm:ss and milliseconds. Problem is that sometimes the END TIME is before START TIME and it does not sum up (Start Time + ProcessDuration = End Time).  Please advise how to properly capture process completion time and it duration. There are no tasks in this process. Appian version 20.4 Start time = pp!starttime with text function to format it. Process Duration = =process_duration() End Time =text(process_completion_time(),"dd-mmm-yy hh:mm:ss") & "_" & milli(process_completion_time())

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.

Hi Appian folks, Is it possible to split the data of a column and then perform aggregation over that data?  We have a requirement where we have to display data in both categories in a pie chart but on DB level, that data is multiple in nature, stored with a semicolon. The DB design is correct but aggregating it in a report has sort of became a blocker now.  Data for a row looks like: Category A;B;C Pie charts have three categories: A, B & C

Hi, I have written an userfiler insider a RecordType with an expresson. When I try to use the filter in the user interface and after selecting the item from the dropdown, I am getting an error below in the below attached 2nd screen shot. Any advises please. I am getting an error like below