Data Fabric

Hi, I need to provide a filter with a date range to filter data in a read only grid. Is there any specific control which can give the behavior similar to the RecordType user filter of type  "data range" (Attaching the screen shot)

Hi, I am using a RecordType to load the data into a readonly grid. Also, I am using few user filters to filter the data in the grid. So far so good. Now when I try to export the data into an excel it is loading only the columns which are there inside the grid. But, my requirement is load all other columns including the columns which are not there in the grid. I know there is one server to export data using the service "Export Data Store Entity to Excel Smart Service". I would like to know is it possible to export the RecordType into an excel using this service. Thanks.

Hello, I've created a datasubset using a!foreach. Now want to filter the data on the datasubset depending on the value for one field. Can you please suggest on this? a high level snippet is below. Below rule returns a datasubset & on that datasubset I am trying add a filter.  todatasubset( a!forEach( items: rule!Irulename(), expression: 'type!{urn:com:appian:types:cdt}|cdt_name'(fields:, completed: rule!newRuleToupdateafield )) )

Hi, can we use task report (a!queryProcessAnalytics) to show the read only grid by fetching data from db? 

Hi, We are using Picker field to search client name based on id, using an expression rule to get result of data subset when user enter id or client name. Minimum four char should provided by user in picker field search so that query will search the matching data and displays first 10 ids. For some ids while searching in picker field, getting an below error: An error occurred while retrieving the data. Details: Unexpected error executing query (type:LKTableDataDT2865], query: [queryentity expression], order by: [[Sort[id asc]]], filters: [((id = TypedValue[it=3,v=9000152]) OR (clientname includes TypedValue[it=3,v=9000152]))]) Here, in LKTableData we have records around 19lakhs plus. Regards,Sandeep

Hi Team, We actually have an related action in our record but when we try to open it from android mobile app it is very hard for us to see the related action icon, Even i was not sure why record title is taking the color of site navigation bar color ,Due to this the icon is too hard to visible to users, Please let us know if you have any suggestions Thanks, Udayasai

Hi  I have a main RecordType  which is linked to another RecordType "recordattorneys" which is internally linked to another recordtype "attorneys". Now when I try to set up "user filter", I am unable to do. Getting an error message like "Please add at least one filter option". FYI: I have a one-to-many relation between main recordtype and "recordattorneys" and many-to-one relation between "recordattorneys" and "attorneys"

When I tried to get data using a query filter for a custom picker and when I tried using record picker, I could find a significant performance difference. Record Picker was very fast when compared to a custom picker. How does record picker work and can we do the same for a custom picker also? And I  would also like to know how record type actually holds the data, is it like a cached memory or it fetches every time? Can someone help me understand this?

Need to immediately sync record data after executing the query database node. any work around helps.

Hi, We have a Record Type based on a MySql view, and we just added 2 new fields in the concerned table and in the view. When we used the RecordType, all works fine, the 2 fields are well visibles from Interfaces, ER, or the RecordType itself. The only issue we have is when we try to deploy this component with the Visibility set with the code below (cf screenshot). Please see the error is below. When we leave the "Visiblity" section to true (default) all works fine. When we put back the code with new fields, the error still appears. Yesterday to get out of this situation, we set the Visibility with an ER to not evaluate anymore the new fields with the rv!record[] function, to deploy it. Today, we tried again to set the initial code, an now, it works !?? Would you have any explanation ? Deployment log : 2022-06-15 13:53:19.88 ERROR recordType 6dfe1b0b-91a9-46c0-8133-d6c88103606b The recordType [id= uuid=6dfe1b0b-91a9-46c0-8133-d6c88103606b] was not imported

Hello, I want to create a report using column chart that shows the following conditions(I am done with the first 2 conditions), I'm stuck on the last 2 conditions, could someone help out? Requests that are closed by agent Requests that are open by agent Average time agents are taking to complete their tickets Average time each department is taking to complete their tickets. 

Hello  I am trying to generate Record Actions for my DB but for 1/2 of my Record Types I am unable to do so. I have tried to generate these actions both with CDT's generated by Appian and also by me (inside Appian) but I always get the following error. I have read similar threads but no solution.  

Hello All, We observed one issue 1. Parent CDT -> one of the columns type is document 2. We updated the child CDT (added a new column) upon updating the child CDT, the parent CDT filed type changed from document to anytype. Did anyone face the same issue?

Hi All, I have requirement to get the data from an external systems and import into Appian. Firstly, I need to get data from the external source and later need to store in Appian Db . How can be this achieved?? Thanks & Regards, Sravani Manyala.

for my summary page i want to add a aprrove button action . how can i do that

I have created a from and created a process model so that data can be stored in DB .after submitting the form i want to show in a new interface that what details i have submitted. Can we able to see the check boxes also in the summary ?

HI Team, I am using the site_usage.csv to generate report for business. There is one "Action" tab which contains  View Site Task ReportView Process Task FormSubmit Process Task FormView Site Action Start FormSubmit Site Action Start FormView Site Record ListView Site ReportView Site Record ViewView Site Related Actions ListSite Record List Search Can anyone translate this to layman terms which business can understand like which one stands as DB "transaction" and which one is "Read-only" OR anything meaningful.  Thanks Bihitak

How to update the existing view(created using joins and tables)  with new column and change the existing column i.e "ID" field (which is having foreign key constraint ) in the cloud database

Before  the update i was  able to  make a filter just for the loggedinuser but now i'm getting this  error  is there any way for filtering a record   that allow the logged in user to see just te  info  requested by himself.  

Hello, I would like to create a CDT with a primary key which must be an Auto-generated value but with a prefixed value.  Ex: "APP_01", Where the number 01 must be an auto incremented value. Is it possible to do so? If yes please suggest me a possible way to do it. I was unable to understand the following: Generating primary keys When using a sequence to generate ids (such as @GeneratedValue(strategy=GenerationType.SEQUENCE)), we recommend allowing the system to name the sequence instead of providing a name with the generator attribute. If you choose to define a sequence generator with the generator attribute in conjunction with the @SequenceGenerator annotation, then you must provide a name, and that name must be unique across all sequence generators in the system to avoid uniqueness constraint violations https://docs.appian.com/suite/help/22.2/Database_Schema_Best_Practices.html Please help me with the above.

Is it posible to configure the action button "Delete Item" so it just deletes that item from the Record, but not from de Database? Do I do that from the process model? Thank you!

Hi All, i want to hide Readonly Record Grid, in case it's Empty or no data contain. by default it's shows empty grid with message,  Please advise. Thanks in advance. 

Hello All, We observed one issue 1. Parent CDT -> one of the columns type is document 2. We updated the child CDT (added a new column) upon updating the child CDT, the parent CDT filed type changed from document to anytype. Did anyone face the same issue?

Hi there, in a record type, i have two user filters. just put them here as filter1, filter2. just want to dynamically display the drop down options for filter2 based on the selected option in filter1. how to implement it, how to get the selected option value of filter1? Anyone has experience/information please help. regards L

Hi Community I have a case that I need to decrement counter in foreach loop is it poosible ? My code: local!numbers: {2, 12, 14, 22, 32}, local!counter: 100, local!loop: a!foreach(      local!numbers,      /* need here to decrement the counter */ )