Data Fabric

Hello Everyone, I would like to apply filter for the process report using queryprocessanalytics.Configured the queryfilters as below but none of the approach helped me.The result is null.  1. a!queryFilter( field: index(index("c7","employeeDetails",{}),"employeeId",{}), operator: "=", value: "7" ), 2. a!queryFilter(field: "c7[recordTye!EmployeeDetails.fields.employeeId]"operator: "=",value: "7"), I have tried to index the same way on the process report data fields > Definition but not able to get the indexed value.Is there any way to filter the values of particular field in record type.

What is the major difference between creating a table from CDT and  creating CDT from a table? On looking from the front end, both look similar. But the XSD file for both of them tell a different story. I have attached both the XSD files here. The one created from table is having columns defined while the other is not having such columns. Will this cause any issues?  @Table(name="tableCDT") @Id @GeneratedValue @Column(name="id", nullable=false, unique=true, columnDefinition="INT") @Column(name="name", columnDefinition="VARCHAR(255)") @Column(name="amount", columnDefinition="DOUBLE") @Column(name="isTrue", columnDefinition="BIT") @Id @GeneratedValue @Column(length=255)

Hello there! I have some date as a data subset form and I need to create a pie chart which show which contract are overdue and which not .This pie chart need to be drilldown to a grid  which list only the contract on the selected category. The data are these: local!contrat: todatasubset({ a!map(id: 1,name: "Contract A",,deadline: today()-6,status: "Decline"), a!map(id: 2,name: "Contract B",,deadline: today()-20,status: "Open"), a!map(id: 3,name: "Contract C",,deadline: today()-2,status: "Draft"), a!map(id: 4,name: "Contract D",,deadline: today()+28,status: "Open"), a!map(id: 5,name: "Contract E",,deadline: today()-30,status: "Complete"), }, How can I do the grouping with this format of data? Thank you in advance

For using GUID/UUIDs as primary keys, Appian supports varchar datatypes; however this is not very performant for indexing. The UUID datatype was introduced in MariaDB 10.7 and supports index-friendly storage. Will Appian support this datatype for data synced records?  Our use case involves supporting data transfer and merge from distributed systems, so using GUIDs as primary keys prevents any conflicts upon merge. Otherwise, we'd need to clear out all the keys and generate new ones upon inserts (pks and fks). Also we'd need to maintain a mapping of origin keys to destination keys. This is a tedious process. 

Greetings, My requirement is to create an Appian application that runs within the environment, giving the user the ability to view the log data from login-audit.csv and logout-audit.csv. While I have done this, I was wondering if I'd be able to expand on it: Is there a way to view which application objects a user has modified in their session? If there is a log file that tracks this in shared-logs, that would be handy. Thanks in advance. 

i am having a record with the data 2million rows. And in our db table we don't have primary key so we created a custom primary key using multiple fields in the table when i am trying to fetch the data from records i am getting the value when i am using includes operator in filter but when i am trying to fetch the data from records i am not getting the value when i am using equal to operator in filter.

Exception: "Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = c36d2:2c0ec] : An error occurred while executing a save: java.lang.IllegalArgumentException: Invalid index: Cannot update integer index from type List of Null" While converting the list of terms from a rule input to a local variable, I get this error. When using without local variable, I do not get this error.  local!terms, ***gridlayout***  rows: a!forEach( items: local!terms, expression: a!gridRowLayout( id: fv!index, contents: { /* For the First Name Column*/ /*a!integerField(*/ /* Labels are not visible in grid cells but are necessary to meet accessibility requirements */ /*label: "term " & fv!index,*/ /*value: fv!item.termnumber,*/ /*saveInto: fv!item.termnumber,*/ /*required: true*/ /*),*/ a!dropdownField( label: "termnumber " & fv!index, placeholder: "-- Select -- ", cho

Hi All, Through stored procedure how to sync record? If anyone know pls let post your comments.. Getting all values through stored procedure smart service but couldn't able to sync record. https://docs.appian.com/suite/help/23.3/Execute_Stored_Procedure_Smart_Service.html

I have a problem to run quiz using 10 questions answers in in foreach loop. I want to save values in a local or rule variable. (question id with selected answer value)  If user modify his answer, then selected Ans value changed with new selected option. I want to do with record type.

Hi all, I was trying to get know more about "UUID" and how it works, I came across couple of challenges , Which both include "Record Type" object and it's UUID. 1. When i'm trying to pass UUID of record object in  getcontentsbyUUID function (Content tools plug in) ,it's throwing an error   "No object with this UUID has been found" , but when i search it in application search i can find the object. Can we use this function for records? 2. When i am deploying  application to an higher environment, In inspect tab SOMETIMES similar thing  (Record object and it's related objects  were there  in the package , but still it's gonna ask  for missing object with uuid  which is record type). Can anybody please explain why it's happening   

Hello, I'm displaying a selectable read-only grid on an interface, and the grid is sourced from a record type (entity-backed).  Based on what row the user selects, I want to use various fields from that row elsewhere. I.e., a!gridField( ... selectable:true, selectionValue:local!mySelection, selectionSaveInto: { a!save(local!selectedRow, index(fv!selectedRows, length(fv!selectedRows), null)), a!save(local!mySelection, index(save!value, length(save!value), null)) } ) My local!selectedRow looks great.  But, when I try to reference this elsewhere, like: local!myselectedRow.name I get an error: "must be indexed by its corresponding record type fields or relationship". How can I index this as if it were a CDT? (which...since it is an entity-backed record, I would think I can treat it as a CDT of that entity type). My only workaround is to do a cast() within my saveInto, but I hope there is a cleaner way.

i have a requirement where  "close" related action should be visible when status is not denied and closed .  i kept this condition in  " views and action security " but the relatedaction is still visible on the request when status is closed/denied also

How to call Power BI from Appian and show the reports in Appian. do not send the links , I have seen there is a  plugin with which we can connect to Power BI, how to render the reports & show it on Appian. basically which functions help us to call the Power BI inside an interface & How to pass the parameters to power BI from Appian?

I am calling an expression rule in task report for the context of tasks assigned to owner by creating a new column with "Edit". This newly added column with the expression rule is not populating the data in the report, but the same is working as expected while passing the data. Below is the code inside expression rule: a!localVariables( local!toDate: todate(ri!startTime), local!days: tointeger((ri!toBeExpireDate) - (local!toDate)), tointeger(todate(ri!startTime  + local!days) - todate(today()) ) startTime = tp!starttime from the report, toBeExpireDate = process variable (using this for calculating the no.of days left) Please let me know if the expression rule can be configured for column within the reports. Also, please suggest if there are any other alternatives. Note: Without calling the rule, I tried with the logic pasted above, but no luck.

I have updated parent CDT(UK_AWTS_Requests) to add 2 new fields. While creating new version using xsd, I was getting below Info warning for one of the child CDT(UK_AWTS_REF_STATUS) present in it. I ignored above , created new CDT and promoted to Runway. However in Runway all the dependent objects are still referring to older version of CDT. Also all dependent objects are showing ^8 special character. Can somebody tell me what needs to be done in this case.

I have a requirement to add a new field, contained in a record, to an existing process report. In an interface a gridField with filters is used for displaying the task data, but cannot find a way to get this data in a way that makes it available for both new and previously started active processes. Process Report is tasks per process model Process Report is tasks per process model Process uses Records for data management () Requirement to get additional data from the Process into the Process Report Additional data is a value found in the Record Process reports cannot index Records Less than ideal solution has been to add process variables for any data point needed from the record These single data point process variables can then be seen in the process report Process report is displayed in an interface using a a!gridField() Data for the gridField is pulled using a!queryProcessAnalytics() a!queryProcessAnalytics() uses logicalExpressions in an a!query() to filter data Query filters

We are building a case management application that support many ad-hoc relationships among different record types. We are using data sync, but anticipate to exceed the 4M row limit eventually. What strategies should we consider for this? The documentation suggests adding source filters, which makes sense; but no longer will all the data be available in the record type. Do we move all queries to a!queryEntity but allow all writes to continue using a!writeRecords? If so, then we'd want to make sure all our record queries are in expression rules so they can be updated to queryEntity. 

Hi All, I have a scenario where I want to open a site with the record data context thought a mail sent to a user. The user will click on the site URL present in the mail and then he will be directly navigated to the exact context of the record data and the page where he want to go with the record data.Can we achieve this identifier scenario for a recordtype based site URL?

Greetings everyone, I had found a previous post from 7 years ago, however the solution found is not one that works for our use case.  We have a usage monitor application that pulls data from the csv files of login-audit.csv from the shared-logs. Currently, files of login-audit.csv are stored in a folder inside the application's Knowledge Center. I was wondering if there is a method to getting files from shared-logs into Knowledge Center folder. The plugins such as login reader and login information parser would not work in this case as the data is pulling from the folder in knowledge center already. I was wondering if this can be kept intact, and if there is a way to automate moving files from shared-logs to knowledge center. 

I have a one to one relationship between WorkItem and Lead where workitemId is a foreign key in Lead. I first create workitem and then pass its id to lead while creating lead. Conditions in table, workitemId is unique and not null. This has been working fine in previous version of Write Record Smart service but in new version it is not working and giving error for workItemId not being there. Lead: {leadId=505, workItemId=2843, qualityScore=4} This gives error: Unable to write to the source due to system error. Error Details: Field 'work_item_id' doesn't have a default value. Note: Same input still works with old version of write record smart service. In logs I see it creates prepared statement without workitemId field:  Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO `PRO_Lead` (`quality_score`, `lead_id`) VALUES (?, ?)]; Field 'work_item_id' doesn't have a default value; nested excep

Hi there, I have a desired requirement from a client about checking to see if two values are an 85% match. So for example, if a user entered ABC, Inc. for one value and ABC, Co. for another, it would be flagged. This is just one example, if the similarity of names was in the middle or end of the value, it would also be flagged. I just can't seem to wrap my head around any logic to make this possible. Any suggestions? Thanks!

Actually i am getting a csv  document from sftp to the staging table i am writing expression rule to count the data. so here i am getting a error memory threshold reached during output conversion. Can some one give perfect resolution for these. 

Hi All, We are using MariaDB. Is it mandatory to provide after keyword in alter table query while adding new column? We are moving from lower environment to higher environment. In lower environment, the columns are in a certain order and in higher environment, we are trying to add the columns in the last and not in the same way as lower environment. Eg: In lower env, table is like firstname, middlename, lastname. In higher environment, it will be like middlename, firstname, lastname. But both environment CDTs will be like firstname, middlename, lastname. Will these cause any issues??

We have a record type hooked up to a table.  Adding new records works well.  But, there is an issue with record edits.  The record gets updated in DB, but the auto record sync following the record update fails.  Here is data from error email: Problem: An error occurred in executing an Activity Class. Details: Unable to sync due to a system failure. Recommended Action: Examine the activity class to correct the error and then resume. Here is some relevant data from tomcat-stdOut.log: [http-nio-8080-exec-734] ERROR com.appiancorp.record.service.RecordReplicaUpdateService - Loading updates to synced record type(s) in ADS failed, invalidated record type(s): ...com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system failure. (APNX-1-4521-016)...Caused by: com.appian.data.client.AdsUserInputException: APNX-3-1000-030: Invalid transaction data. Cannot update the same entity multiple times in the same transaction. Invalid id(s): ... Note: E

Hello, Having two environments (PAM and PRO, both on cloud), I want to copy the database schema from PRO to PAM under the name "Appian_pro". After that, on PAM environment, I want to delete the "Appian" schema and rename the copied schema as "Appian", all of this to operate with Pro data on PAM.Would be possible to perform these steps? Thank you in advance. Regards