Records

. Getting error while executing . Pls advice where i am making mistake configuring

Hi, I'm trying to create a user filter in a record that filters a combination of 2 fields. I've tried to use a!queryLogicalExpression() inside a!recordFilterListOption() for the filter and didn't work. Is there any other way to do this? My other option is to create an interface with this filter but i think it would be better to have it as a user filter in the record. Thanks, Ignacio

Hi All, I have a web service record type with some related actions, currently I'm facing an issue when I click on the record action on an interface, the record action consists of a very long form , but what I believe is triggering the error are the paragraph fields, some have a character limit of 500, and 3000, but when the record has empty values the form shows as normal or when the sum combined of the characters of the fields is less than 1700 it also opens as normal, as soon as one of the fields is more than 1700 characters or one is 1300 and the other field is 500 the interface is showing  an error with no details. I checked the main data type of the form the length for each field is correct.  "An Error has occurred" is all it says. If anyone has seen this before I would appreciate the help thanks!

Has anyone run into this error before? We have a rule that calls a stored procedure given an input, then returns results. One day a user ran into an issue where the SP was returning null, but the next day the SP was returning results. We've done no code changes, so I took a look into the logs and found this error: Where it says Error Msg = ORA-01013: user requested cancel of current operation. However, I know the user ran into this on the UI only and didn't cancel anything on the backend. It also seems like it was not a timeout issue since upon checking rdbms logs, the execution times were very low. Does anyone have any suggestions on what this might be or what we should look at for further investigation?

context:I have 3 interfaces that communicate with each other, What I need to do is give users the ability to open a project and from the project detail interface have a button in related action that opens another interface that allows the user to add employees to the project.This is the path they take:"GP_ProgettoInterfaccia" > "GP_ProgettoSummary" > "GP_CreateOrUpdateGPprogettoAnagrafica"here all in order:[View:/cfs-file/__key/communityserver-discussions-components-files/16/GP_5F00_ProgettoInterfaccia.txt:233:29]>[View:/cfs-file/__key/communityserver-discussions-components-files/16/GP_5F00_ProgettoSummary.txt:223:27]>[View:/cfs-file/__key/communityserver-discussions-components-files/16/GP_5F00_CreateOrUpdateGPprogettoAnagrafica.txt:335:25]. The record types involved are: . The problem is that once I get to "GP_CreateOrUpdateGPprogettoAnagrafica," I can't populate the multipleDropdownField. In the standalone interface, I c

Historically, we’ve used Data Sources and Custom Data Types (CDTs) to manage our data integrations. As we transition to using synced records for our new application, we’ve encountered a challenge related to schema access in SQL Server. Currently, our SQL Server Data Source is configured with a username that has access to the database. However, any synced record created under this data source only has access to tables within the default schema. Our data model spans multiple schemas within the same database, and ideally, we need to connect tables across these schemas within a single synced record. One workaround is to create separate data sources for each schema, each using a different username. However, this would require maintaining multiple data sources for the same database, which adds unnecessary complexity and overhead. We’re seeking guidance on the best way to configure our SQL Server connection so that synced records can access tables across multiple schemas wit

I have a readonly grid with a record as a source. This record Lets say "Main Record" is having a relation ship with other record - "Related Record". Grid has fields from both records. When Applying filters I want to avoid getting records from "Related Record" which are not active. Lets take below sample data of "Related Record". Relationship is one to Many. ID_MainRecord Division Is Active 1 Sports 0 1 Study 1 I have applied filter as  a!queryFilter( field:Main Record.Related Record.Division Operator: = Value: "Sports" ), a!queryFilter( field:Main Record.Related Record.isActive Operator: = Value: true ) Still I am getting one record in Grid I am expecting no records at all. And the record I am getting is having "Study" in division grid field. How can I get it work.  Some how how the first filter is not working as "Sports is there in the relationship field I guess. Thanks in advance for your atten

Unable to see "create new data type (CDT) in community edition . Is it removed permanently .

IN Date Range User Filter  I have to restrict user not to select any Future date in To Date 

Do you know if there's a maximum limit on the number of record types that can be created in an application? I have a database with 700 tables, and I'm not sure if Appian can create this many record types, or if I need to create an architecture that only creates the main tables. Thanks!

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