Records

There is a requirement where i have to insert nested CDT(one to many) data into table and then read in another process model. Parent CDT : policyDetails policynumber customerId actiontype nomineeDetails Child CDT= nomineeDetails { title: "Mr", forename: "abc", surname: "Test One", dateOfBirth: "01/01/2000", percentage: 80, relationship: "Brother", addressLine1: "Hall Road" } { title: "Mr",forename: "xyz",surname: "Test two",dateOfBirth: "01/01/2006",percentage: 50,relationship: "sister",addressLine1: "aaaaa", } My Approach :  Create two tables policyDetails & nomineeDetails with foreign key = policynumber Insert policy details into first tables without nomineedetails. Insert nominee details into second table using MNI in process model. Create 2 expression rules to read data from both tables and use it. Do you guys feel that there should be be

Hi, my application has a number of record types with associated summary views. When the user enters they filter the records, make use of the paging, and then open the summary view. Unfortunately on closing the summary the filter and paging info is lost. Is there a generic way to maintain this state? 

Hi, am working on a use case where, service backed record is supposed to fetch data, used to display and to be fed to corresponding Reports. The provider system is having around 2 million records, and the record sync is timing out (100000 records synced in 40 minutes). Additionally for every call 1000 records are returned. Requirement here being to sync the entire 2 million records in Appian record type.  In case you'll have experienced something similar or have a solution/workaround for the scenario, request to please advice. Thanks in advance. Regards, Amit

Hi everyone, Can appian do this query? I would like to query all of the data of the merchant without transaction between a specified date range and show it in the read-only grid, I already have view table  but I can show all of the merchant without transaction between a specified date range.

Hello, User Group Functionality Description Comments Grnators Action         Edit         Edit         Edit         Edit Users Part of Group Users Emailid Remove A   x B   x C   x     These are two editable grids . When I press edit link in above grid , then below grid named "Users PArt of Group" should be displayed. How to do that using recordaction field 

Which operations are not supported on the CDT editor interface? (select multiple from bellow options) a. Add a field  b. delete a field from cdt. c. change field of cdt d. define a field as the primary key of cdt.

How can i implement grid export toexcel to user system on single click Bot to aappian system

Hi All, I have a requirement where I need to query with 40k input and output will be 2x or 3x of that. I have passed the batchSize as 20 and fetchTotalCount as true. I need to display the data in grid and need to export all in a excel also. But I am getting a time out error. Is there any way I can query these number of data in UI. Please help us with your suggestions. Regards, Kavya

In my application, the DB contains the fields (id,name,unit,type,isActive). The name and unit values are retrieved based on the type and shown in the UI dropdown and that is the List. One Particular type contains 13000+ active records and gives Memory Threshold issue when it tries to load the data. In the expression rule, the batch size as set as -1 to retrieve all the data's from DB.  To avoid this exception, I added the batch size as 100 in a!pagingInfo(). But the problem is now able to see only the 100 records in dropdown field and not all the 13000+records.  Is there any other option is available to resolve this problem. Regards Martina

Hello everyone, I like using record filters and record view. Some of the fields in my Record Source are however decimal/integer and Appian offers only filters for Date and List of Values. Both is pretty much useless when it comes to Numbers. What would you suggest use to filter these? Ideally, there would be some number range selector similar to Data Range, with 0s filterted out as default option. Of course, I can set up my own field that would filter the record data based on filled in value, but that would greatly hinder the record filter functionalities, and I would need to use custom interfaces instead of Record Views. Thus, looking for a better solution.

I would like to be able to pass the ALL the data for a selected record (using the data type for the individual record) to a related action.  However when I try, I get the attached message.  Is there a way to do this? It is possible to pass rv!record to a record view, for example.

Hi Champs, I have a use case where I don't need to show the related action in a record related action tab ; but I need to call that related action of a separate interface. the reason for doing this is I have to call an interface in a popup/dialog ; which can only possible in related action.  Is it feasible to do so ?

Hello All, We are using 1 PM in which we are using the smart service "Execute Stored Procedure", We are having 10K+ data in the staging table and we are using the batching logic to trigger the stored procedure for 1000 batch. Th stored procedure function is to get that batch start and end index as parameter and fetch that much data from the staging table and run different sql queries , insert data in the different table. The same sub process I am using multiple time but when 1 is ending I am triggering another one, not running all parallel. I am getting wired error in some batch running after 7000 or 8000 data. The error: "An error occurred in executing an Activity Class." Not getting anything in logs as well. Sharing the screenshot of the error aslo. Let me know how to resolve this issue. Thanks in advance.

Dear Team, I am experiencing an issue with synced record types while deploying package from dev to Test environment. Issue: Error validating source for synced record type - APNX-2-4195-000 Possible Root Cause: Data source for record type is different in dev and Test. Alternate Solution: I can able to deploy the package, However i need to open the record type in target environment and change the datasoruce. Comment: Our deployment will not to do above mentioned alternate solution in each higher environment. Please provide any other possible solution. Tried options: I tired modifying the .xml file with target datasource, but when i select the package it says, package is invalid.

Well the problem I have is like this, the first is that I do not have access to the database, and the main problem is, I get from this database, data, it turns out that when I get a column with values, they do not respect the numerical order, for example; 1,11,132,145,186,2,22,234,257,3,4. that is an example, it only respects the first digit to the left. Another thing I noticed is that in the db, they use varchars instead of an integer, my question is, if I can not access the database, is it possible to change by means of a filter, or by means of some expression the format? I already tried to call my recordtype, with a cast, but it sends me an error when I do it from my recordlist for filters. for example tointeger(recordtypebdd.fields.values) and I get an error... I hope you can help me.

Hi All, I have a case where Users will pass some Id parameter say batch Ids upto 4k or 40k and we need to query all the data for the inputs from one particular view. In older version like 17.1 we used this executesqlquery() function which is available in sqlexpressions plugin to fetch all data. Since this plugin is deprecated now we include a stored procedure that will query data dynamically. But for few data like upto 1000. It works fine. But it seems to have certain character limit to be passed as a input parameter. If we cross it, stored procedure is not accepting those values. We are getting null values.  If anyone knows any replacement or ideas on how to proceed with this it will be helpful. Thanks & Regards, Kavya

Hello All, I am calling the interface through summary view of record type and create a button in related action. I am having a button in interface as well and when this button is clicked on it should display the related action button. But in my case related action displays after refreshing the page.  Any suggestions would be helpful.

I want to display multiple default options in record filter, but it seems like filter doesn't work when multiple options are there for default filters. Is it an appian limitation? Is there any work around for this? I am using 20.4.

Has any one been getting 503 error trying to export a record type to excel? I am not applying any filters. This is happening for small dataset (5 items) as well as large dataset (3k records). I am seeing this issue in  my community Appian instance 22.4 and work Appian instances in 22.3.  For every failed export attemt, there is a Warning log in the tomcat-stdOut as folows 2022-12-08 16:09:46 WARNING [http-nio-8080-exec-3] com.sun.jersey.spi.container.servlet.WebComponent.filterFormParameters A servlet request, to the URI https://yljk.appian.community/suite/rest/a/dataexport/latest/download-grid, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.

I have a read only grid with a record type as its source called Survey Data and it displays data from another record related with a one-to-many relationship called Recommendations. I'd like to create a user filter in the Survey Data record type that would allow the user to either see all the rows that have information in the Recommendations record (aka the Survey Data id exists in the Recommendations table), or see all the rows that do not have Recommendation information (aka the Survey Data id does not exist in the Recommendations table).  Does anyone have an idea of how to do this? I've tried setting it up so that it finds where the Survey Data id in the Recommendations table is null() but that did not work. I also have the ability to change this to a one-to-one relationship if I need to. Any guidance is appreciated, thanks!

Hi, I am trying to create a record action and generate a record action, system is throwing an error. I have verified the column name in the database which is showing in the error and there is no such a column. Now, I got struck due to this issue. Can someone provide tips to overcome this. Thanks in advance.

Good morning I have a recordtype field that has values 1,2 and 3. I am trying to have the field value to be displayed as 1 = Draft, 2 = In Progress and 3 = Finalized. can any assist me with this?

How to update a record type field value using the Expression Language?

Hi Appian Guys, a!queryRecordType( recordType: recordType!SellerTeam, filters: a!queryFilter( field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis" operator: "includes". value: "Alex" ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) )I want to get teams of including "Alex" only, could anyone give me some good advises?

Hi All, I need to call record type summary interface(configured in views and headers in record) from button widget. How to achieve this? thanks!