Data Fabric

Appian recommends using history tables + triggers for storing historical data. Why not use MariaDB's OOTB feature? https://mariadb.com/kb/en/system-versioned-tables/  This approach requires very little configuration for each table. ALTER TABLE t ADD SYSTEM VERSIONING; I tested this out in our Appian Cloud instance and the only downside I've found so far is that ALTER operations on versioned tables may need to be run manually in combination with  SET @@system_versioning_alter_history = 1; The solution may be to change the global config (set global system_versioning_alter_history = 1), but it requires SUPER privileges.  So, what's the catch? This approach seems to be the simplest solution for storing historical data. 

Hi All, Is there a way to export entire columns from the database table/view when using Appian Record Type and in the Grid we should be displaying only few of the fields from the database table/view?

Hi Community team, I have an requirement to fetch all the Schema Names and their associated 'Table Names with their Sizes'  to display them in the appian interface. In order to achieve this, From the cloud database I have executed the following SQL statement which gives me the output:  SELECT table_schema as `DB`, table_name AS `Table`, ROUND(((data_length + index_length) / 1024 / 1024), 2) AS `Size` FROM information_schema.TABLES WHERE TABLE_SCHEMA IN ("Appian", "SchemaA", "SchemaB") ORDER BY `Size` DESC; On executing the result: EX DB Table Size Appian data 30.56 Appian example 28.52 ScheamA customer 3.52 Appian document 3.52 SchemA CaptureDetails 2.64 SchemaB Controls Library 2.52 Similarly, I'm trying to implement the same functionality in Appian using Query Database Smart Service in Process Model, on the set-up tab I'm able see only one schema(Selecting Pre-defined schema ) details: Instead of that I need to retrieve a

What could be the possible fix to the below issue. 8 calls, 1199 ms peak average, 0.0% of total

Hi I am querying a record type to get usernames. I am getting all the records except one record. There is no such filter too. I also checkd whether recordtype is syncing or not. It is also syncing properly. The usernane is also in the record type and database table. What can be the reason? Please suggest a solution.

I've got this 'Expense' record type, and I've set up two event tables for it — 'Expense Event History' and 'Expense Event Type'. Now, I'm looking to make a user filter within the 'Expense' record type. I want the filter options to be based on the 'Expense Event Type', so when I pick one, only expenses with that event type as their latest event will be shown. The issue arises when selecting event type 'Pending'. Due to the 1-N relationship, the a!queryFilter exhibits an 'At least one' filter behavior. https://docs.appian.com/suite/help/24.1/fnc_system_a_queryfilter.html#%22at-least-one%22-filter-behavior Consequently, the list displays expenses with their latest event being event type 'Pending' (first row on the image), but it also includes expenses that have ever had events with event type 'Pending' (second row on the image).  Could you suggest a workaround or alternative approac

I have a record type that has been deprecated. I'd like to drop the table from the database and rename the record type to start with DEPRECATED; then disable data sync and disconnect the table. However this record will become invalid and fail to deploy. What's the best practice? 

I have requirement to update many Record Type with almost 100 column to Camel Case Is it possible to update Record Type settings as a file?

Hi all, Is there any way to invoke the Record Leve Security of a Record type? I mean passing manually in code a user like queryRecordtype (userToApply:user) Givin more context: We have a set of Web APIs that will be invoked by other system, we have set up the authentication to be via "API KEY" in this scenario the API is tied to a service account, but the problem here is that we have in configured the Record Level Security Rules to manage what groups of users can see the information. We want to expose cases but since the Authentication is via API key (tied to a serviceaccount) we loss the functionality of Record Level Security. We tried with passing the User ID as queryParameter/Header in the API but we need a way to apply explicitly the Security  of a RT. Thanks in advance for your help.

Hi , I have a requirement where we will be having around 90 case types and I have groups for each case type (90 groups). I need to provide a record level security for each cases . For eg: if I am part of Address group I can see only address cases in the record. I am planning to use Security expression instead of security rule since there are around 90 case types. I created an array constant containing all the groups with group type and also with the text type. I was trying to use for each loop and query filters. local!group constant contains all the 90 groups in group type local!groupassignee constant contains all the 90 groups in text type. Please suggest me any approach where we can provide record level security for 90 cases. Thank you a!localVariables( local!group:cons!PSP_ALL_GROUPS, local!gropAssignee:cons!PSP_ALL_GROUP_TXT, if( a!forEach( items: local!gropAssignee, expression:a!queryLogicalExpression( operator: "AND", filters: a!queryFil

In order to force sync all record types when importing an application, I have to add the force sync line in the properties file along with the UUID of each record type. Where to get a list of all UUIDs of the record types used in my application?

Hi All, We have a database backed record type and inside DB there is a column called as Status which can have 3 types of values. i.e New,Accepted,Rejected. Our requirement is to show the record list containing data only for New and Accepted initially and user can select Rejected in the user filter if they want to see those records. Now the problem is that Appian's Default Choice option inside User Filter is only allowing single selection. Due to which its not possible for us to show the record of New and Accepted at the same time. Can someone please suggest what can be done in this case? Any help here is appreciated. Thanks in advance.

Hi everyone,  I'm having these 2 tables. For each table I created 1 synced record, in synced record for Leave, I set a many to one relationship with Status, and by contrast, I set a one to many relationship for Status to Leave.    I ran a SQL script in DB to update statusId values to 3 (UPDATE User SET statusId = 3) and when I check again, SELECT * FROM PPL Leave WHERE statusId <> 3 returns 0 result. After that, I went into PPL Leave synced record and do a fully sync. I'm expect to see the synced record data to be updated to be the same with the table (all statusId = 3), but instead I can see no change in the sync record, and query SELECT * FROM PPL Leave WHERE statusId <> 3 returns 2 results (which I'm assuming after the sync, data in table was updated to be the same as in sync record).  Is this a strange behaviour or did I set up something wrong?  Also, if possible could you explain for me the

I have a read only grid where I will search records and filter it and from there click on record link and navigate to record summary and from there when I navigate back to same readonly record grid i want search results to be retained with searched text. I tried passing the value as ri. But since Summary interface is already configured with static value in Views its passing as null. Any idea how to get it done?

Is it possible to configure record link on row selection on read only grid. I have tried selection Save Into to set a value with selected record id but not sure how to configure record link here.

Greetings everyone, I've been going over the Applian Academy Step-by-Step #5 pertaining to designing record types.  I've created the record type for "AX Vehicles," but when I save there and attempt to configure the database source, the "Choose Database Table" is empty and I'm unable to proceed.  Please offer any advice you can. Thanks in advance!!!

im working with records and i want to export the data that im showing in the record, to do this i want to use the parameter showExportButton and it says that this parameter only applies when a record type is used as a source in the data parameter. in the data parameter im using the function a!recordData, the button to export is visible but is not working, anyone there to share the solution?

Hello, In record filter not in operator is not working for multiple selection.  for single selection is working. If I passed IN operator, then working as expected.  can anyone help me on this? please find code for reference.

Hi Folks , When we create a CDT we get an option to hide it from pickers and auto complete , what's the use of it , in what scenarios can we use it ?

We're using a record type, but one of the record field types needs to be changed from integer to text. I can update it in the database, but when I try to run a sync in hopes of being able to change it in the record type as well, the sync fails. How can I achieve this? I do not want to delete the field and create it again since it's referenced in a lot of objects that we use.

We have built a reporting framework that allows customers to customize columns and filters to generate a custom report. The customer is asking for more flexible filtering, including defining operators between filters and grouping filters, basically a UI for building logical expressions. Furthermore, the customer has more complex reporting requirements such as generating reports with dynamic columns, based on selected filters. We have a potential solution for the flexible filtering requirement, but we have performance concerns as our current filter framework uses nested CDTs Are there any existing solutions or examples of report builders / query builders in Appian? Also, what is Appian's recommendation for handling complex reporting / data analysis?  Thank You

I'm getting this error after completing Exercise 5_Records Part 1 in the Appian Developer learning path. I reviewed the steps, and I still don't know what's causing it. Can anybody tell me what's causing this and how to resolve it?

I have this code which I use to query task report. I want the filter to check if the asignee groups are in an array of input groups. Take a look at the working example first:a!queryProcessAnalytics( report: cons!GBD_Report, contextProcessModels: cons!GBD_Process, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100, sort: a!sortInfo( field: "c2", ascending: true ), ), filter: a!queryFilter( field: "c4", operator: "=", value: ri!group ) ), ), This works because ri!group is not an array but a single group. However when I turn the ri!group into an array of groups, and instead of operator "=" use operator "in" so basically check if group is IN an array of groups I get no data

Good day Some users asked me if it is possible for us to have a kind of "Global" saved-filters. By today, each one of them need to fill the fields and go to Manage Filters > Save filter as .... But as they are store operators, they have a lot of filters that they wanted shared between them. After saving we have the following Filters: We wanted to define a global version of this, so every user in that profile might have access to it. Is it possible to do ? Or at least a user can export their filters for the others to import ? Thanks in advancecc.: [mention:a897b8cf98a0422ea0250353deb54416:e9ed411860ed4f2ba0265705b8793d05] 

HiWe have a process model having a user input task having a pv of record type variable. Now when we give that process model in a process report and try to map the pv values inside the report, the record type fields are not getting displayed. But another pv of integer type is giving value inside the report. Both the integer value and record type value are present in the pv level. Please let me know if there is anything I am missing.TIA