Data Fabric

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

Hi Team, I have a requirement where I have to show the list of users who have opened same record in a site. I have record type with 'related actions' to view the record details, my requirement is if user A has already opened the record and if another user B opens the same record, then both of them should be able to see on the summary page that the other user has also opened the same record. We don't need to lock the record rather just display who all are viewing the same record at the same time. Any help is appreciated. Thank you

Hi, I'm using expression in "Source & Default Filters" in RecordType. I can only save expression with 4 criteria but I cannot save it with more than 4. do you have any suggestion. my code is below: a!queryLogicalExpression( operator: "OR", filters: {a!queryFilter(field: "year1", operator: "<", value:2021), a!queryFilter(field: "year2", operator: "<", value:2021), a!queryFilter(field: "year3", operator: "<", value:2021), a!queryFilter(field: "year4", operator: "<", value:2021), a!queryFilter(field: "year5", operator: "<", value:2021), a!queryFilter(field: "year6", operator: "<", value:2021), a!queryFilter(field: "year7", operator: "<", value:2021), } )

Hi, I have record data as shown in the table below :  Id NumbersInText 1 One 2 One 3 One; Two 4 Two; One 5 One; Three; Two 6 Three 7 Three 8 Two 9 One; Three I am trying to aggregate this data is such a way that I can how the report below : NumberInText Count One 6 Two 4 Three 4 Please help me with it.

I am working on bulk file (docx and PDF) handling Application. My plan to use SharePoint for that. I want to know,       1)Is there any other optimal way to handle bulk file other than SharePoint integration that can connect to Appian.       2) While trying to connect to SharePoint, Integration give error, even though Connected system is correctly authorized. Thank you

Hello, I have a process model that is using execute Process Report to retrieve data on task metrics and store in the database. We are seeing an intermittent error where data is not being retrieved into process variables. I thought this may be a timing issue, but no data is being retrieved when the model is rerun and the underlying process report displays the required data. Are there any system logs that can be queried to help me identify the root cause of the issue?

When i'm creating cdt from database i'm facing this issue:- ->After selecting Data source no table or view is there for selection  -> data source (oracle DB)

Hi there, I have one CDT array { {a: 1, b: "R" }, {a: 2, b: "E" }, {a: 3, b: "R" }, } what's the good way to update field b from "R" to "T". tried this, it does not work. a!update(CDT.b, {1, 3}, "T") anyone has the experience dong this? Regards, Lin

Hi All, I have  "Accounts" record(database is the source) in below structure, Account ID Account Name Account Status 28 Test InProgress   I added a "One to Many" relationship with the "Contract" Record,which is in below structure.  Cont Primary Key Account ID Contracts 1 28 A1100 2 28 A2000   Now I want the "Accounts" record list to be displayed in below structure,where the "contracts" column will be my new custom record field,and it should be concatenated like below. Please help me how to make this work. Account ID Account Name Account Status Contracts 28 Test InProgress A1100,A2000  Thanks in Advance!!

Hi there, I have an array local variable here, using a!save(local!array[1], true) does not work. any idea what's the problem? regards, Lin

i'm trying to create a process report report type task , context tasks assigned to group inside the report i set the required group as a context but i wasn't able to see list of tasks of that group, so please guide me what is missing

Hi All, While running the Query entity. Facing this issue.  a!queryEntity( entity: cons!ABC_DSE, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10 ) ), fetchTotalCount: false) Exception: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DECOMITSMNetworkDT11134], query: [queryentity expression], order by: [[Sort[computer_id asc]]], filters:[null]) Is there any log file where i can get more details? Note: Retrieving data from Oracle. Regards, Nishtha Bhatnagar