Records

I have a map and a dictionary.. How can I merge them and save the output to a datasubset?

Hi Team, In records we can create a text filed filter. Thanks, Nagesh

a!richTextDisplayField( value: { a!richTextIcon( icon: "check-circle-o", caption: fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'], link: a!dynamicLink( saveInto: a!save( fv!row, a!update(fv!row, fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'], not(fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'])) ) ), showWhen: fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'] ), a!richTextIcon( icon: "times-circle", caption: fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'], showWhe

Hi, i would like to know what are the possible reasons why a record is not shown in a record type. Record Type is connected to a data store. This specific row does exist in the database, but is not shown in a record type. Thank you.

Hello, thank you for everything.There is something I would like to discuss with you today. Within the interface's expression mode, I am attempting to retrieve data from a record type, aggregate that data, and display it in a graph.The aggregation process is done in units of month and year, such as the total amount for each month in 2024.I prepared a temporary record type for practice. If all the target data contained in the record type is of date type, the implementation was successful. However, among the designed record types, there are fields that are text type and have date data. This is text type data such as "2024/11/04".I would like to convert the value of this item to date type data between acquisition and aggregation processing. If it is a text type, conversion can be achieved using todatetime(). However, this function does not work well for data obtained from record types. The error is that it is a record type type or a record field type, and that these types can

I am having trouble with the error "Export Data Store Entity to Excel Smart Service". I am using "Copy Document Service" and "Export Data Store Entity to Excel Smart Service" in the process model. The contents I want to process are as follows. ① Copy an Excel document. ② Paste the content exported from the Data Store Entity into the copied document. To achieve these goals, we first stored the document output by "Copy Document Service" as "pv!copyExcelTemplate".Thanks to this, ① was achieved. Next, I set "pv!copyExcelTemplate" to "Document to Update". This results in an error that says, "Please select a new document name, or if you want to access an existing document, select the document you want to update."(it's Japanese) The document should be configured correctly, so why am I getting this error? Note that if I leave "Document to Update" blank, I can export the contents o

We have a series of Records configured in one large relationship structure (50 + record types).  A third party process retrieves data from a SOAP webservice, extracts pertinent data and using a series of stored procedures inserts that into the database. Is there a way to capture those new entries and sync them into my records without having to examine 50 tables and perform 50 Sync Record operations?

Hi, I have a very strange issue with a RecordType and a Process. So I would have 2 questions : 1/ My recordType is based on a simple table Category(#categoryId, name, isActive, fkIconId, orderNo) and the corresponding ProstgreSQL table contains a Primary Key with SERIAL on the "categoryId" field. I've created a new RecordAction to call a process, and the RecordAction passes the rv!record to the process.{ myRecord: rv!record} I've created an Interface with a RecordType based Grid, to try my recordAction :but when I click on the button on a grid row, the process is launched with the bad parameters : Example1 : Click on row(categoryId=4, name="CAR", isActive=true, orderNo=2) => but in the process instance I see this log : changed to {categoryId=2, name=BICYCLE} Example2 : Click on row(categoryId=2, name="BICYCLE", isActive=true, orderNo=4)=> but in the process instance I see this log : changed to {categoryId=4, name=CAR} It is exaclty like

is there a way to retrieve more than 4000 characters from database using either records type or data store entity 

Hi team, I have a requirement where I need to add multiple assignees to a request. To do that I have created a child record for Assignees and with "id", "Assignee" and "isActive" fields. To do this I have created a rule input and added this child record as an array. I have added a user picker field "Assignee" where I was not able to save multiple values to Rule input. Can anyone please help me. Thanks!!

Hi everybody,I want to put some multiple default values into a Record Filter, but I don't know how.I see that with only one default option works correctly, but in the case in the screen didn't work.

Hi Team, I understood how index function works, but can someone please write a code(with example) using index function with cdt.

Hi there, I am getting this error while writing data to data store entity. An error occurred while trying to write to the data store [IPA Main DS]. No values have been written. Details: org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save(): IPAIRRIntegrationLogDT11401 (APNX-1-4208-004) Thanks

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.