Data Fabric

What should I type in the expression editor in order to set initial value to a record as shown in the pic? I have tried typing the first couple letters but it seems that the Applian does not recognize them as affiliated functions of a record.

Hi all, I'm dabbling with some "serious" QueryRecordType interface use for the first time in a bit, and for the first time I'm attempting to use the built-in Aggregation. My use case: a simple one, basically showing a grid sorted by frequency of use of a potentially repeating column.  I'm using Aggregation Fields and grouping by that column, while doing a "count" in a measure.  When I run this a!queryRecordType() in an expression rule it works beautifully.  I notice: it returns an a!map() data result rather than a DataSubset. Then I try to plug it into a Read-Only Grid and things start going a bit haywire. If I try to use it as you normally would use a RecordType source, the grid errors with a complaint about returning List Data.  If I try to run the query in a Local Variable first, it doesn't quite work right, because with the local variable not resolving as a DataSubset, the grid doesn't quite recognize what info I'm try

Not able to fetch the top 3 most visited parking spots for a respective month. any suggestions

I'm trying to filter my task report according to either the process, name or created by field. But it's not returning any processes with these exact names. Can I filter the fields like this, for example, the process name is JT Create Incident, but can I reference only Create Incident? And with the name it changes everytime from Approve Incident to Attend To Incident. Can I just reference "Approve" or "Attend To" or should it contain the entire name / process name?

Hi, I need to know from which Appian version it's possibile using recordActionField in a gridColumn of a read-only grid with a queryEntity as data source. I need this functionality to start a related action showed in a dialog and remaining in the same interface, same status, after close it. Thanks

Not able to fetch the top 3 parking locations for repsective month. kindly help

Hi. I am experimenting with data fabric features and building record views Expression Base record types with Sync On. I have 'Queue' Record type and 'Queue Item' Record type in 1:M relation. In a 'Queue' list, I need to see number of related 'Queue Items'. I have created a column for that, see below. However, the highest number it can count is 10, then it stops counting. I guess that this is caused by logic to related to logic described here: https://docs.appian.com/suite/help/21.3/fnc_system_relatedrecorddata.html (..Number of related records to return. Valid values include 1-10..) My question is, if there is some way around this? Simple count procedure should imo not be difficult enough to cause performance issues, especially in my case when the number of 'Queue' record types is low. Thanks, column definition that only returns 10: a!gridColumn( label: "Number of items in Q", sortField: 'recordType!{3c05c063-58d

Not able to fetch the top 3 most visited spots for a repective month with below mentioned code. Kinldy suggest { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VP

I am not able to fetch the top 5 most visiting spots for respective month. { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-45ca-

I want to show only top 5 secondary grouping categories for respective month. { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-

I need to show only top 5 most visited places for a month but i am stucked at this point. below mentioned is the code that i used to work out till now: { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType

So I have a read-only grid displayed on a site through an interface. The summary is also displayed through an interface, and the summary of a record is pictured below. What I want to do is add a button, going to the next or previous record so that the user doesn't have to click the home button in the top-left. I found this thread but wasn't sure how to apply it to my situation (not completely sure how to apply a!query): community.appian.com/.../access-to-previous-and-next-records

I want to do this get value from multiple select as newRefs;insert into table1 ('name') values ('pete');SELECT LAST_INSERT_ID() as newUserId;for each (currentRef in newRef) {     insert into lookupTable1 (userId,ref) values (newUserId,currentRef);} Actually there is a quicker way to do this with MySQL/MariaDB as noted here https://dev.mysql.com/doc/refman/8.0/en/insert.html What do I need to do this?Do I use Data Store Entities, Record Types, etc.?I can't be the first one that want to do something like this.

Hi,  I have created a process report.   I was able to see the list of the task assigned to the group in the report  but I wanna use this report in my interface to allow the supervisor group to approve the leave. but I encountered the error message as  Empty context passed in for report LM Supervisor Task Report [id=4256]. (APNX-1-4156-000)] anyone can guide or teach me how to do ? 

I'm facing the priority changing of a process and task to others different from 0,1,2 (low, normal, and high) priorities, is any way to create others like "critical"?, or if there exist others, where can I see them?

So, I have a record action to delete a "contractor" from a list of contractors I've created with a record type. After deletion is complete, it displays this: Ideally, I'd like it to display something else, like: "Contractor successfully removed", or "Contractor successfully deleted." Is that something that's possible? This message is displayed on a site that a read-only grid is displayed on.

Hello, I want to be able to retrieve my Records in an a!hierarchyBrowserFieldColumns, including the record relationships. I already created a Query Recordtype retrieving my data including the relationships data.  Is there a simple way to display the record type list in a a!hierarchyBrowserFieldColumns.  in the firstColumnValues i'am using a the id of the record. what is the next step? ( nextColumnValues). any examples using a record?  Here is a example from: docs.appian.com/.../Columns_Browser_Component.html a!localVariables( local!path: {4,2}, local!selection: 2, a!hierarchyBrowserFieldColumns( firstColumnValues: enumerate(9), nodeConfigs: a!hierarchyBrowserFieldColumnsNode( id: fv!nodeValue, label: "Node" & fv!nodeValue, image: a!documentImage(document: a!iconIndicator("PREVIEW")), isDrillable: 1 - mod(fv!nodeValue, 2), isSelectable: mod(fv!nodeValue, 3), nextColumnCount: fv!nodeValue ), pathV

I want to update a row when save to data store entity instead of generate a new row with a new id.I cofigured write to data store entity of output tab (plz check my attached screenshot） When　In debug and check my Id did not get id value.

Here are my record types: Why am I getting the following error message when I try the expression out? Expression evaluation error at function a!queryRecordType [line 5]: The field [recordType!SS Item.relationships.ssLookupCategoryItem.fields.categoryId] used as a sort field was invalid. You must reference the field from the related record type in "relationship". This query works fine when in the Cloud Database area/*select * from SS_LOOKUP_CATEGORY_ITEM, SS_ITEM,SS_CATEGORY where SS_LOOKUP_CATEGORY_ITEM.ITEM_ID=SS_ITEM.ID AND SS_LOOKUP_CATEGORY_ITEM.CATEGORY_ID=SS_CATEGORY.ID*/

 I am working on a application where i want to update details of customer and the updated details can  be shown at site

Hi Experts, I have implemented readOnly grid with RecordType as a datasource. Search options was only working for the the columns which I have configured in the gridField, so for search to filter on all the columns I have added all the columns of the cdt/table as gridField column with showWhen as false. Will it be having any impact of performance? I tried to lookinto the performance matrix of the UI but in both the cases performance is almost identical. Q: Question that I have up in my mind is weather the performance will get deteriorated with the increase in amount of data pulled through record or will it behave as it is ? Q: Since all the data is already coming through record , showing it in grid will have considerable impact on performance or not ?

Hi guys. I'm new to complex queries with records and I've got a question about how to execute a query based on records when there is no key based relationship between two tables. Imagine a situation where there are two tables 1. Executed jobs table Jobs       Id Summary Employee Hours Timestamp 1 Pipe change johnb 3 10/12/2022 12:34 2 Cleaning andyw 5 08/12/2022 10:22 3 Installation johnb 2 03/12/2022 09:12 4 Destruction johnb 4 02/12/2022 18:34 2. Hourly rates of employees Rates         Id Employee From To HourlyRate 1 johnb 01/02/2021 30/11/2021 12 2 andyw 01/03/2021 31/01/2022 8 3 johnb 01/12/2022   14 4 andyw 01/02/2022 31/12/2022 11 5 andyw 01/01/2023   14 In result I need to list executed jobs with their cost. But the join between these tables is based on employee name and timestamp of job fitting into rate of employee at job execution time. Using SQL I could perform a join on multiple fields

THE primary key is generated automatically when data is stored in database. Now how to display primary key when the data is forwarded further to supervisor?

Hi Team,I have uploaded a document from the interface. Now I want to call the record and show the documents in file form like this  and also wants to add view more button option, for example in the beginning   there are only 5 documents files that are visible now I will click on view more button and more files which are uploaded will be visible on interface. Please tell is it possible to apply all these, if yes, how? Thanks in Advance

Hello, I want understand how the data is retrieved when we use chart with grouping. For charts In data we give recorddata (retrieve the data with filters) and then it is grouped using primary or secondary grouping(column charts) I want to know if internally. the whole data is retrieved and then grouped or the data is grouped and retrieved? If the data is retrieved and then grouped , then i can use local variable and save the recorddata() and then give the data to chart for grouping. if i do this whole data is stored in local variable.  if im using a drillable grid then i can reuse it. But to reuse this data i need to again filter this with the selected (data clicked on) grouping.  1. I want to know if internally. the whole data is retrieved and then grouped r the data is grouped and retrieved? Can i load data in local variable as shown below pic. 2. If its the earlier, then given a recorddata how can i then filter it to get only few rows out of the whole? belo