Records

Unable to write to the source due to system error. Error Details: INSERT command denied to user 'dbadmin'@'%' for table `dbo`.`CM_AUDIT` Facing Above error when trying to insert data to CM_RECORD Table  After Creating Trigegr using below SQL code CREATE TRIGGER `Audit` AFTER INSERT ON `CM_RECORD` FOR EACH ROW BEGIN INSERT INTO dbo.CM_AUDIT (COMPLAINT_ID, ENTITY_TYPE, CREATED_BY, CREATED_ON) VALUES (`CM_RECORD.COMPLAINT_ID`,`CM_RECORD`, SUSER_SNAME(), GETDATE()); END

I'm using the Deployment API, specifically to import a package. In the documentation, there is no reference on how to add a package to a specific application. It's unclear then why it displays the following error: ``` INFO Inspecting the package 'Test.zip' of the external deployment.ERROR Failed to find an application [uuid=424242placeholder2424] for the external deployment [uuid=424placeholder42424]. ``` Any ideas on how to resolve this?

Hi  I want to save another column with value same as the primary key. how can i do that Thanks

I have changed a cloumn from varchar 300 to text, in dev its working fine and If I try publishing the datastore its fine in Development Environment but after deployment in SIT Environment it is giving me error on the same column while I tried publishing datastore. Database Configuration XSD Configuration

Hi All, We have a Entity based record, in which multiple views were manually created. Requirement is to set some dynamic icons or text as the name of the Views. I have tried the below code to show an icon but the output is not as expected. Appreciate any suggestions on this. Thanks in advance. View name coming with attributes as:

Hi All, I have one requirement where a entity backed syncd record list is configured with initial sort on created date column to show the latest cases first. Now they want to change this sort to change and show the oldest case first when they apply any record filter. For example: I selected a record filter to show only Open cases, then the sort of the grid should change to show the oldest case first. Any idea how we can achieve this?

Hi Champs, I want to create basic user dynamically through coding. Can that be possible? Regards, Ghanashyam

I am using write to record smart service in my process which is breaking when I start this process with a basic user who has a viewer permission on record (and that user can successfully view record details on screen). I am writing into SCC Case record without any events. Also, when I change the assignment of the node to whoever designed the process, then the process works as expected. Can you please help me with this issue ? Error The input "Records" refers to an invalid record type. The record type does not exist, has been deleted, or the user does not have sufficient privileges to access the data. Logs 2023-11-20 10:31:56,000 [ajp-nio-0.0.0.0-8009-exec-773] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=268442382, classname=com.appiancorp.process.runtime.activities.WriteRecordsActivity com.appiancorp.suiteapi.process.framework.ActivityExecutionException: The input "Records" refers to an invalid

if( 'recordType!{3a147a0e-d35e-4fa0-96f7-d91590fdf68d}NZP Maintenance.fields.{b3c7019a-c216-42e6-b725-b7c67abec412}requestType'="Medical", rule!NZP_DASH_MaintenanceSummaryView(maintenance: rv!record), rule!NZP_DASH_MaintenanceSummaryViewForPen(maintenance: rv!record) )

Hi, Getting error "Preview currently unavailable due to an error on the source" while retrieving the data from DB View with Record Type also Expression Evaluation Error while querying with QE. Verified that view has a column wherein unique values are present and same is used as PK in CDT. Only thing is, this view's load time is approx. 20.17 seconds.    Anyone can suggest what would be the solution for this.

I was working to add a row in an editable grid that uses record types. I kept getting errors with indexing when I tried to use append in the add row link. I found a solution by saving a value into the list as shown: This seems hacky, but it works. Does anyone know of an easier or better way to do this?

HI Team, I am configuring the record list and i have 2 columns completed by and completed on, I wanted to show these columns only when user selelect user filter completed, How can i pass record filter value to showwhen

Problem: When applying a!toJson on a record type, record fields of type user will be converted to JSON objects. When casting the JSON back to record type, it fails to convert the user object (dictionary) to User type with error: CastInvalidCould not cast from Dictionary to User.  Example recordType!Test(id: 1, createdBy: "user 1") - createdBy record field is USER type a!toJson on the above will return a json object with nested createdBy object: {"id"=1, "createdBy": {"id":"username1"}} a!fromJson returns a dictionary with createdBy as a nested dictionary: {id:1, createdBy:{id: "username1"}} casting to recordType!Test will throw error CastInvalidCould not cast from Dictionary to User. Changing the record field type from user to text would eliminate issues in JSON conversion, but it takes away the ability to use record security rules by user fields. Another workaround is to flatten out a

Hi  I am using a!recordData to show data in my gridField  Now I have a requirement of implementing a button wherein If I click that button all the data should be selected ( i.e. the ids of all the records should be saved into a local variable ) But now I am not finding a way to index the recordData at once  Can anyone help me in this ?

Hi all,I have defined a process variable in a process model with CDT type. It is working fine in all environments. Now I am adding some new fields into the CDT and published the datastore. Its working fine in dev. When I moved these changes to higher environment( just moving the CDT and scripts and not the process model where the pv is defined as CDT type), its not working as expected. The newly added fields are not present in the CDT type process variable in the process history while debugging and the pv datatype shows with ^ symbol. Can anyone help with this?

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