Records

Background on the issue: 1. Created a related action against a synced record. Created a record parameter inside process model. 2. Mapped the action inside Interface: a!recordActionField( actions: { a!recordActionItem( action: 'recordType!{7aeac830-25f0}Task Assignment.actions.{596dfe95-567c-36ec}acceptAndTakeAction', identifier: fv!row['recordType!{7aeac830-25f0-44}Task Assignment.fields.{2acffd98-059fd5a2}TaskId'] ) } ) 3. rv!record is passed as input to Process model { rtTaskAssignment: rv!record  /* Task Assignment */} 4. Received only few information inside process model:  {TaskId=3, Workflow={WfId=8173, Label=4501_PRA110_WEEKLY}, Owner=} Expected: {TaskId=3, WfId=8173, rptId=89, Stage=23, Status=17, RoleId=9, ActionId=, Owner=,  isActive=1, createdBy=System, createdOn=25/06/2025 10:18, updatedBy=System, updatedOn=25/06/2025 10:18, GrpId=14575} We are observing this with other related actions as well. All the fields are correctly mapped inside record. How to

So i created a constant for all the company names which is normally a best practise in the appian application.  and then i called this constant in a filter But then when i was using the filter it wasnt working and all the values were showing in the same line idk why this is happening can anyone guide me how to rectify this error.

I am currently streaming logs onto a syslog server and would like to come up with a series of programmed alerts to identify potential security risks. But it's not always clear how to use the log fields to come up with these alerts. Has anyone done this exercise before and can provide some more info on which fields can be used in which ways to identify potential security risks? *For example*, the authz-audit.csv log records information about the authorization of already authenticated users within the system. I could check the Decision field to see if someone was DENIED access to a certain uri (Action Target and Action Name fields), but (a) it's hard to understand some of the info within the fields and (b) it's unclear how to distinguish a legitimate denial from a potential security threat. Any ideas would be much appreciated. FWIW, I'm currently grabbing the Streaming logs and have already looked through the Logging Documenation.

when user with basic permission they click on  Record action they got  above error ,If same scenario try by myself with administrator permission  it's work fine for me , Basic user have appropriate security permission for Record access and actions   Note: If we think it is related to access issue either we get 401 or 403 issues but it get's different one 

I have a column in database view of type decimal (20,2) and it can take both negative and positive number. Now on downloading excel doc via out-of-the box feature (Export Data Store Entity to Excel), all the number are being quoted inside single quotes but not the positive ones. Any way to get rid of this?

Hi Everyone,  I have issue that I am syncing the records with sync record smart service within a process model in batch after the excel upload ;the excel have around 67k+ entries I am inserting the data using strore proc after some data manipulation ;  after the sync completed when I check in the data preview section for updated records they are available there but when I try to query the records I m  not getting those newly added rows. So I did manual sync then I was able to query it. What could be the reason can anyone help?

How do i add a new manual action in the summary view with an auto generated interface. Is that possible ?

Hi, After migrating to 25.1 version, we are unable to download excel from any of the records. The file will be attempting to be downloaded and fails after timeout. Below is the log we found in tomcat file, Caused by java.lang.reflect.InvocationTargetException Caused by java.lang.RuntimeException: Fontconfig head is null, check your fonts or fonts configuration

Hi Champ, I want to call an related action from an image component using the link parameter. Is there a way to do that? Regards, Ghanashyam

I have update and delete options in my related actions tab , but i want to remove the related actions tab and add the update and delete options in the summary view (Job Details) tab itself. Can anyone guide me how its done.

Hi all... i have a database-table (postgresql) with 3 columns: id (integer), year (integer) and cost_pre_hour (numeric(10,2)). I would like to use this table as a source for a dropdown.As choicelabels I want a contaminated string in the format: ‘Price for year ’ + [year] + ‘ (’ + [cost_per_hour] + ‘)’[cost_per_hour] preferably formatted with 2 decimal places. I just can't get it to work. what i tried:in the record-type another calculated field:a!customFieldConcat( { "Price for  ",recordType!<recordType>.fields.year," (",?????????" euro/hour)"})for ????????? i set:text(recordType!<recordType>.fields.cost_per_hour,"#.##0,00")orcast(typeof(1.0),recordType!<recordType>.fields.cost_per_hour)or other internal-cast-functions or/and combinations.I got the error Could not cast from Record Field to .... CastInvalid or something like thatWhen i try:tostring(recordType!<recordType>.fie

Hello, We are running a query on Synced Record data using a!queryRecordType where we need to filter based on a list of Text. This is the query filter we are using: a!queryFilter( field: 'recordType!recordName.fields.email', operator: "in", value: ri!email ) The record field is type Text and contains users' emails, which vary in how they are capitalized. The rule input ri!email is a list of Text String. When we pass in only a few items to that rule input we are able to return the expected results and we do see the records being returned with the email field matched in a case-insensitive manner. However, in our implementation we need to search on a large number of emails where the capitalization is not consistent across data sources. When we pass in 173 items to the ri!email rule input, we do not see the results being returned as expected with the email field matched in a case-insensitive manner. Then, if we update that 173-item list to make t

I want to have a custom record field, get data from related record field with out any aggregation it is a text field(like  we have group_concat and group by in SQL). I want to have this field as I want to apply sorting in read only grid on this column

My situation is as follows:I have a Vehicle record, an Employee record and a Driver mapping record between them. A vehicle can be reserved by a driver at a time, but in it's history there can be many previous drivers. I want to make a custom record field that shows the current driver assigned to a given vehicle so that i can use it throughout my application. However I am not sure how to do this with the aggregated custom fields. Since aggregations basically do not care for the specific thing i want (I want to show the employee name of the driver that has the latest start date on the mapping table).Is there anything i can do for this? Or do i just have to rely on relationships and generally querying relatedRecordData appropriately to satisfy this situation? 

Hi, I have readable grid in which i am using arrow icon, so if I click on that arrow so that row should go up and upper row should come down. I can get all data items from current row, but how I will get data from previous row, So I can apply swapping conditiin

I am storing the values to sql in gmt format ,when I fetch  The data back and show it in grid Iam changing to clients timezone but it stores in db as gmt while querying and showing in grid making difference in the time I checked separately but the issue is in sql we need to conver to local timezone and use it.Is there any way,please suggest I'm using view to fetch data and show in front-end

I noticed that if I use sql to update data, the data in record type need to sync manually.  I want to know is there any way that the record type can sync automatically once I update data in db. In sync options tab I only saw Schedule full syncs, but It can't suit my require.

Hi Appian Community, We recently ran a Health Check on our application and encountered a performance finding related to a Record Type. The specific issue is with the "Data Query and Default Filter" step, which is taking 4322 ms to execute. Context: We have a Record Type (recordType!ABC) that pulls data from a database view containing all case types. A default filter is applied using the "Expression" option. The expression used is:             a!queryFilter(   field: 'recordType!ABC.fields.transactionId',   operator: "=",   value: 46 ) Note: The transactionId field is indexed in the main underlying table Any insights or recommendations would be greatly appreciated!

Is there any way to recover deleted documents in Appian Environment. We had the docids for the deleted objects, Is it possible to recover them? 

Hi, I have a field 'allocatedTo' in the database table with longtext type, which is translates to Extra Long Text type in Appian Record. While trying to edit a relationship with another record having 'username' field as Text type, 'allocatedTo' does not show up in the dropdown. Strangely, it worked fine first time, now shows error in the relationship. What could be the issue ? Thanks.

Can anyone help me with what the error is about. It showed up when i clicked summary view.

My input will be emailaddress in eachline  on the UI"values": [ { "id": "d7971ace-7ca5-ec11-8132-0050569773df", "emailAddress": "testing.test@test.com" }, { "id": "50363345-b494-ec11-8131-0050569773df", "emailAddress": "test2.test@test.com" }]This will be the response of my integration. when the response is 200 then I want to store the entered emailaddresses in new table as seperate rows and the IDs from response should get mapped to those emailaddress in DB .How can I achieve it 

My input will be emailaddress in eachline  "values": [ { "id": "d7971ace-7ca5-ec11-8132-0050569773df", "emailAddress": "testing.test@test.com" }, { "id": "50363345-b494-ec11-8131-0050569773df", "emailAddress": "test2.test@test.com" }This will be the response of my integration. I want to store the entered emailaddresses in new table as seperate rows and the IDs from response should get mapped to those emailaddress in DB .How can I achieve it 

Hi, I'm facing the issue while executing a process. When I ran a process it'll insert data into database. The process is working in DEV & I deployed the code in test and tried to run the process but the record sync is failing. I can see the data is inserted into table but node is failed. Also, I tried to sync manually, it's still failing.  I found the below from logs, but not much help. If anyone have idea on how to resolve this error.  2025-06-03 09:53:23,215 [Appian Timer - 1] WARN com.appiancorp.common.ObjectSynchronizer - 1 services were missing users. 2025-06-03 09:53:41,677 [RecordSyncScheduler_Worker-2] INFO com.appiancorp.record.service.quartz.LoggingTriggerListener - Trigger [group: record_load_group, name: 43_663b0ec2-ac3e-43a8-9ea1-b226c63274cc] fired for job [group: record_load_group, name: 43] 2025-06-03 09:53:41,893 [RecordSyncScheduler_Worker-2] ERROR com.appiancorp.record.service.BulkLoadServiceImpl - Unrecoverable error in record data sync com

I gave an field as an primary key by mistake and now i want to give the primary key field to another field. Can anyone help me with that, iam new to appian.