Data Fabric

I need to build an interface with 100 Editable Columns and all the columns need to be searchable & editable.(Like a table with 100 columns and we should be able to input something and search / modify the data and submit to DB).Which approach is suitable for this requirement? Should i go with Record Type / Editable Grid.(I am aware that the performance may be slow due to 100 columns. But business want to evaluate how it looks like and see the performance)

Hi , I want to update the local variable of the type List of Cdt based on a condition. For eg. myCDT:{{name:"Albert",age:30,Dept:'Sales',Sal:10000},{name:"Beth",age:28,Dept:'HR',Sal:2000},{name:"Cindy",age:35,Dept:'Finance',Sal:2000},.................} Dept:{"HR","Sales"} I wanted to update the Sal of myCDT list found in the Dept variable.   I know we can do it with foreach() function, but I have to map each field in the CDT. I have around 50 fields in my actual  CDT   Is there another way to implement this ? Please suggest. Thanks in advance.  

Hello Community, I try to get a task identifier specifc to a process instance. when I use this, I get 6 identifiers, they match the 6 instances in the record list: a!queryProcessAnalytics( report: cons!MY_REPORT, contextProcessModels: cons!IPAY_TEST_FOR_RECORD_PM, query: a!query( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1) )).identifiers, I would like to pass the fv!identifier in the record or pp!id to get the specific identifier of the process instance in the list of 6, then use that in a link to the open task in the record list. 1067516(Number (Integer)) 1067535(Number (Integer)) 1067554(Number (Integer)) 1067612(Number (Integer)) 1067574(Number (Integer)) 1067600(Number (Integer)) when I use contextProcessIds: pp!id, it wont work. How to query or is there another solution. KInd Regards, Erik

As i said i´m trying to update certain rows on my table, and i have a list with the key and the field I want to update. I´m trying to do this from an interface each time i click on a button. But on a!writetoDataStoreEntity, i just can update one row each time, but i only have one button to do it all. So, any posible solutions to this problem?, thanks!

I am trying to create a vehicle record but I didn't find 'aavehicle'. I have checked in database for aavehicle. I didn't find. How can I found please help me.

Dear all,  I have updated the possible values ​​(by changing the linked constant) of a record type field. The problem is that the data already stored for that field is not updated with the new values, but remains with the old ones. How can I change the records already archived? Thanks

Hi, I have a dataset of 150k record that needs to be updated nightly. We get this data through an API. From the payload we will parse the data and map it to 5 individual CDT's and then write to the db. How should I design this whole process?

Hi, In the below Summary view of a RecordType, I have a document ID which has been uploaded using fileUploadField.  I have this saved in the database.  Now, while showing the details, I would like to show the document name instead of id. Can someone help on this. When I tried like document(ri!employee2.coverletter, "name"), nothing is displaying.

Hi, I am getting below pink error. The data is being fetched from a view and its an intermittent issue. Need your suggestion on this.

I just started trying to use Record Sync and Relationships and wanted to sum amounts from another table that have a many-to-one relationship with an Id in the main record type. However, I only want to add rows that are  isActive = 1 or by some other kind of categorization. Is this doable with a custom expression ? Since the template doesn't have any filtering options.

Is there any way we can use related record type field or expression rules while creating custom record field in a Record type with data sync on? When I am creating a new custom record field and trying to write my own expression, it's not allowing me to use any expression rule. Also I am not able to use any field from the related/mapped records.  It is restricting me to create user filter based on custom record field. Any help would be appreciated. Thanks in advance.

I'm looking for a way to make it possible to page through a list of records from the view of a single record - that is, to add in BACK and NEXT buttons at the bottom of a single record view rather than returning to the list to reselect the next. I understand from previous posters that this may be possible if you can access the list's index of the selected record, then decrement or increment into a local variable so your BACK and NEXT buttons will take the user to the correct record. I have saved the queried list of records to a local variable. How does one access the index values of the records in that variable? Should I instead work from a read-only grid? fv!item will give me the entire record but no value I can reliably decrement or increment to get its neighbors, and fv!identifier will give me its unique identifier, but as records are constantly added and deleted that is also unreliable.

I have this expression rule : a!localVariables( /* Loop checks against passed in value of type to pull values from specific requirementActivity match */ a!forEach( items: ri!requirement.requirementActivities, expression: if(contains(fv!item.type, ri!activityType), 'type!{urn:com:appian:types:UW}UW-Requirement-Activity'( key: fv!item.key, type: fv!item.type, creatorId: fv!item.creatorId, creatorFullName: fv!item.creatorFullName, createdDate: fv!item.createdDate, commentText: fv!item.commentText ), {}), ), ), And I'm using it in my interface : a!localVariables( requirementsResponse: rule!UW_GetRequirementsByCase_RDS("SomeKey"), local!requirements: { a!forEach( items: local!requirementsResponse, expression: a!map( type: fv!item.name, status:fv!item.status, orderDate: fv!item.createdTimestamp, orderRe

Hello!  I am working with an API response from BigQuery, I get the data to be on the record type from my input rule, however when I try to sync, it keeps getting an error as shown below  So, I'm not able to work with this record because of the error, I checked this article https://docs.appian.com/suite/help/21.3/configure-record-data-source.html and it seems like I have to modify the batch number rule but I'm not sure how to do it (like what I have to put in there) or if that is even the issue. My response gives a 632 record only so it is less than 1000, and I assume I shouldn't have to do sync in batches as is less than 1000, but still the error comes up, have you encountered this error or do you guys have any input on how to solve that?

I'd like to store the value  ri!available using this code a!integerField( label: "Available Racks", labelPosition: "JUSTIFIED", value: if(isnull(ri!bicycleInfo.stationId), "",rule!PEDS_QueryStationStatusInfoByStationId(id: ri!bicycleInfo.stationId).availableRacks ), saveInto: ri!available, refreshAfter: "UNFOCUS", readOnly: true, validations: {} )

Hello All, In the filter parameter of a!recordFilterList(), I wanted to pass multiple query filter in order to filter the dropdown list using a!recordFilterList(), per the documentation I do not see any feasible way to do it. Kindly suggest a way out Thanks & Regards Girish Katti a!recordFilterList( name: "Name", options: a!forEach( items: local!completeList, expression: a!recordFilterListOption( id: fv!index, name: if( exact(fv!item, local!name), " ", fv!item ), filter: a!queryFilter( field: 'recordType!name', operator: "includes", value: tostring(fv!item) ) ) ), allowMultipleSelections: true() )

I have created a view and it has data in it . I am creating cdt and trying to map that into DS but it is not hapenning showing error "One or more of the data entities cannot be mapped to the table structure in the selected data source. Please choose an option for creating the necessary tables or select a type that matches the existing tables.   (More Info)" More info "The data source schema does not match the type mappings: Missing column: a_id in Appian.report_isr_budget_study (APNX-2-4056-000) " .

HI, I am trying to create a process with 2 nodes: call an integration + write to db The integration returns a Result.body - this variable is available in the next node....Example of body (json) body (Dictionary) orders (List of Dictionary - 272 items) Dictionary orderNumber5105251(Number (Integer)) operatingUnitId1030(Number (Integer)) operatingUnitName"GEMSAM_OU_LNR_GEMS_LUNAR"(Text) contractAmount4600(Number (Integer)) status"B"(Text) purchaseOrderNumber"1681345522"(Text) customerNumber"131441"(Text) customerName"WOODLAND MEMORIAL HOSPITAL"(Text) deleted0(Number (Integer)) ....   bookedDate11/1/2021 8:23 PM GMT+00:00(Date and Time) initDate11/1/2021 7:59 PM GMT+00:00(Date and Time) customerContractAmount4600(Number (Integer)) Dictionary orderNumber5104156(Number (Integer)) operatingUnitId1030(Number (Integer)) customerNumber"5455"(Text) customerName"SOUND"(Text) .

We have a use case, where a user wants to see both the older as well as new updates made to any field of a record, when pulled out in an excel from Appian Application/Interface.   For example, a record with Car's mileage, Initial Value = 10000, and then Updated Value (after 1 month) = 12000, Updated Value (after 3 month) = 52000   The user wants to see all these entries in the "Records", i.e 10000, 12000, 15000, etc., along with a time stamp (Created or updated date), and updated by.   Below is a sample table/report that the user wants as an output for the above use case.   Car Mileage Created On Updated by Comments ABC 10000 11/2/2021 Emp1 This is the initial value ABC 12000 12/2/2021 Emp2 First Update ABC 15000 13/2/2021 Emp3 Second Update I have received responses where folks in the community has suggested the following: via a Historic CDT Plugin CDT Diff Utilities So, wanted to check if there are any best practices or a 

Hi community, I want to use choose instead of nested if to display status text in different colors. I tried this expression and it throws this error A grid column [label=“Status”] has encountered an error. Expression evaluation error at function 'choose' [line 58]: Invalid index (1) for list: valid range is empty. choose(wherecontains({fv!row[aRecord.status]}, cons!STATUSES)[1],"SECONDARY", "SECONDARY", "SECONDARY", "POSITIVE", "NEGATIVE", "STANDARD") what am i doing wrong here? Kind Regards, Erik

Good morning, I need to make a report to obtain the information of all the existing nodes within the process. A perfect example would be the process node tab that appears from the monitoring inside a process instance.I don't know if it is possible to create a report with this information. Thanks

a!update(data:fv!item,index:{"backupBy","backupOn"},value:{loggedInUser(),now()}),  is not correct, how to do it?

Has anyone found a workaround for passing a dynamic value to a Record Source Filter?

Hello community, Is there a way to filter in a query on a text field with date time other then changing the datatype.e.g. a field lastUpdated with text datatype has a value 8/22/2021 2:55 PM GMT+02:00.If the filter is configured like: filters: { a!queryFilter( field: "startDate", operator: "<", value: "9/22/2021 2:55 PM GMT+02:00" it works fine if the month in the value is a one digit.it fails if the month in the value is two digits e.g.: "10/22/2021 2:55 PM GMT+02:00" Is it possible to convert/alter the startDate value before applying the filter, or add a column to to the result with the date time converted to date time. Kind Regards, Erik 

Hello All, I have constant with holds distinct values of usernames. The constant USER_GROUP has the values {gamma, beta, alpha} Earlier we had a sort() function which would sort the data for us, but this function is no longer available. In documentation I see only a!sortInfo available which is useful to sort the data from DB and I cannot use any utilities as well for sorting the data. So can anyone suggest an alternate way to sort the data in a constant to {alpha, beta, gamma}  a!localVariables( local!sendingName: getdistinctusers(cons!USER_GROUPS) local!sendingName ) Thanks & Regards Girish Katti