Data Fabric

Hi, I want to be able to unselected all the labels that appears in the legend by using a button or any other way. I do not know how to have access to the variable that store a value to know if the label has been selected or unselected. For example, in the first picture there is only 3 label selected, so the graphic show the 3 data lines, every one related to its own label. In the second one, one of the label has been unselected, so the data related to this one does not appear in the graphic. I would like to know how to have access to this parameter so I could make this change without the needing of clicking the label directly. Thanks in advance. PS: here the piece of code that define the linechart, if it is helpfull. a!lineChartField( label: "Forecast", labelPosition: "ABOVE", categories: { union(local!data.date, local!data.date) }, series: { a!forEach( items: union( local!data.consumable, local!data.consumable ), expression: { a!chartSeries( label: fv!item, data

I have an action in a record type. I've set up a very simple visibility rule for it, but it behaves weirdly. The record type has a field Canceled of type Boolean and it cannot have null values. The visibility rule is configured to show the action only if it's not canceled. The action is available for users in a read-only grid and in a Related Actions tab of record's overview. There's always correct behavior in the Related Actions tab. In the read-only grid the action is shown only if I add a check for NULL to its visibility rule. And in that case the actions is always visible in the grid, no matter if it's canceled or not. So it behaves like Canceled is always NULL, though there's always a value. What might be causing this problem? We are still on Appian 21.4 hosted in our environment, not sure if it matters.

Hi All, Could someone please help me understand the difference between data Sync and immediate data sync for record type. I was referring "https://docs.appian.com/suite/help/20.4/Record_Type_Object.html#data-sync and in that I am confused with the topics "Data sync" "Updating synced record types"   Under "Data sync" the below criteria is given: You should only enable sync for your record type if: Your source data changes infrequently outside of Appian and it doesn't need to be synced into Appian more than once a day.   Where under the topic  "Updating synced record types" it talks about immediate update? Thanks Faisal

Hi All,We have an issue while trying to publish the Data Store.Couple of points to give you a background: Appian User is not assigned with proper Default DB Schema - the schema where all of the tables and views are held - (Therefore we're using Synonyms) After upgrade to Appian 22.4 we're unable to Verify / Publish the data store We have found the workaround by adding schema  annotation to all CDT XSD <xsd:appinfo source="appian.jpa">@Table(name="TABLENAME", schema="SCHEMA"). This workaround fails however when the CDT in question has 'primitive array'. In such case Appian creates a related table for the 'array' field.Because those tables were created in another schema we now cannot publish the entire Data Store. We have multiple such tables, therefore we would appreciate any help (Other than changing the default schema - which is currently not an option in our business case). Can you please advise if you

Hi! Does anybody know if there is a data limit for and export sql to flat file? I've been asked to research that as our App need to export large numbers of data in the future! I know it's. deprecated but it's what we have developed and I don't think the product owner will want to update de feature! Thank you

Title: Record sync issue post write to DB smart service call Body: I have used Write to datastore entity smart service for updating a record in database table, this works fine via a record action but when I'm using a related action, I am getting sync issue in recordType after related action process flow completes and returns back to the record summary dashboard. Below are the logs I could find for the issue: 1. Loading updates to synced record type(s) in ADS failed, invalidated record type(s) 2. Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4205-039) Can you please let me know why is this issue happening and how to fix it.

No longer need assistance, thanks!

Scenario is need to filter the data based upon user access to certain business unit id,forum id.Business unit id's are different sectors of business and they are mapped to certain forum id's.Business unit can have duplicate forum id's. they are stored in table like  user id bu id forum id 117 4 80 117 4 103 117 4 114 117 19 80 19 also has records with 103,114 forum id but we need records on the above mapping but when we try to filter it out by querying and storing in a local variable not able to filter out records for mapping of(19-114,19-103). local!buid(filter:userid), local!forumid(filter:userid,buid), In a interface we are using a record type in data and in filter we are using logical expressions.

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

Hello All, I recently created a process report , wasn't able to access SAIL functions like tp!name, tp!assignees. I get a warning improperly scoped variable Was suspecting it to be because of the report type value. I don't remember which one I selected from the below screenshot ( Process model, Process, Task) Question: Where i can see the value of the report type for the already created report and is there a way to update it ?

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? 

The no.of.tasks is being displayed the same times as the no.of members in the group. For eg- I am having  a group with 3 members who will be reviewing  a particular task, i.e. for 3 same process IDs i have 3 different task IDs, because of which when i am displaying it in the UI, its showing 3 same tasks where it should have been 1. How do I deal with this problem?

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.