Records

HI All, We have been constantly facing an issue with Appian Records where whenever a smart service writes data to a table using write to records, an error is triggered like - Modified Source Rows By Primary Key: 246113, 246112, 246117, 246107, 246111. Manual Sync never fails afterwards and is always successful.Note: We have multiple records referring the same Table which fails.

Hi All, I want to understand, whether we can write query and retrieve data from any table if we use the EDP - by using the Business Data Direct Query option. Need to get the confirmation on this Regards, Bharat

I am using custom record field to extract completedOnDate (custom field) from completedOn(date and time) field. But there are sceanrio where ,when I am changing time zone ,date returned is still in gmt but not according to user timezone because of this when I am quering like below,few extra work items are displayeda!queryFilter( field: 'recordType!{ee5aa46d-0228-430f-a794-1134a11fbcc0}CMGT_Task.fields.{d7e1c9a9-03ae-4bfd-bbe6-2edc7e8d915f}completedOnDate', operator: "=", value: today() ), How to fix this issue ,so that date is based on user timezone only and not in gmt

I am getting this error while trying to create record action. The error is  "Your record actions and supporting objects could not be created. Try generating them again or configuring manually."

No warning or error message is displayed when the user uploads a file containing duplicate advisor code and Line of business. I need validation message when I am uploading more than 1 entry with same data. that is if the excel consists same line of business and advisor code then I need this validation messagea!forEach(items: local!constructData,expression: if(count(index(fv!item[local!constructData.advisorCode],wherecontains(fv!item[local!constructData.lineOfBusiness],tostring(local!constructData)))) > 1,"Duplicate Line of business",null)),

Hi there, i want to use the a!pickerFieldRecords interface component but I want to control which record fields the user is querying against when typing into this, and I also want the suggestions/selected value to displayed using a custom record field I created which is a concatenation of the two fields I want the user to be able to query against. Is there a way I can do this?

Summary: The Generate Sample Data feature for a Record Type fails. The issue also reproduces with a newly created, minimal Record Type. Environment: News / Region: Unknown / Appian Version: 25.4 Issue: In Data Preview → Generate Sample Data, the following message appears: We encountered an issue and could not generate your sample data. Click REFRESH ALL DATA in the Additional Configuration panel and try again What we’ve verified: Database permissions and data sync are normal. Source = Database / Sync = Enabled / Primary Key = Integer (also fails for a newly created Record Type). AI services available: Claude Sonnet 4.5 and Claude Haiku 4.5. The same issue reproduces for multiple users in the same environment.

概要：Record Type の サンプルデータ自動生成が失敗します。新規作成した最小構成のRTでも再現します。 環境：News／リージョン：不明／Appian Version：25.4 事象：Data Preview → Generate Sample Data で We encountered an issue and could not generate your sample data. Click REFRESH ALL DATA in the Additional Configuration panel and try again 確認済み： ・DB 権限、同期は正常 ・Source=DB／Sync=Enabled／PK=Integer（新規RTでも同様に失敗） ・AIServiceはClaudeSonnet 4.5、Claud Haiku 4.5が使用可能 ・同一環境の複数ユーザーで同じ事象が再現

For a Dashboard with a series of KPI's we have to elaborate more than 5000 entries, Because we have to calculate median, mode, min, max on a series on time range on a actions log. How we can achieve that using only records and not doing some use of stored procedure?

I am exploring solution in Case Management Studio , Could you please help me understand whether task that is used in the Case management studio application will be alive until  the parent  process model completed  1) Suppose I have planned for 15 tasks in the cases management studio for a case , will the process model alive until those 15 tasks getting completed or it will be short lived once the particular task completed process model will be closed and new task will be generated  2) What are the limitations we have with case management studio application ,  Any help is greatly appreciated

When using the Sync Records smart service in a process model targeting a service-backed record type, the node appears to only sync the first 100 records (and returns 100 as “Records Updated”) even when I pass more than 100 identifiers.1. Manual sync on the record type successfully syncs all records and respects batching.2. Scheduled sync also syncs all records.3. Smart service only ever syncs the first 100.My integration and sync expression pages correctly and return more than 100 records when called independently, and there is no documented 100-record limit in the Appian documentation.Has anyone else found this to be the case when it is stated to work with up to 1000 records (and does when used with non service-backed records)Thank you.

We are building an Appian Portal interface that queries and displays data from a record type (MEPub_PublicCases) using a!queryRecordType() and renders the results in a custom a!gridField(). The interface behaves as expected when previewed in Appian Designer: Records are returned All requested record fields display correctly in the grid Paging and sorting work However, when accessing the same interface via the Portal Site URL, the grid does not display any data, or the data fails to load entirely. This occurs even when: No filters are applied (initial load querying all records) fetchTotalCount: true is used Required fields are explicitly listed in the fields: parameter The record type security includes Viewer/Admin access for the relevant service/integration account Expected Behavior When accessed via the Portal URL: The portal page should successfully query the record type Records should display in the grid exactly as they do in Appian Designer Paging and sorti

Hi, I need some ideas. I am accessing external data using an API and building a record, type - Web Service to store customer information. The API requires a group name to return customer details. Example: Company A → 20,000 customers Company B → 30,000 customers When you pass Company A, it returns the customer details for that company. Now I am facing a challenge. When i call only Company A it goes fine. when i introduce foreach for company B then it is not possible as the sync limit is 1000 by Appian.  I am using the Batch by Sequential Values method. In my integration, I have set paging to return 1,000 records per call. error message i get: "The Record Data Source cannot return more than 1,000 records in a single batch. Batch size was 2,000." Note: I cannot reduce the API limit below 1,000 records because we have many companies, and doing so would significantly increase the synchronization time. sample Code: a!localVariables( /* Call the int

I am using a!queryEntity() to query a DB table where I am only using 2 filters to fetch the results. I am also using pagination for it. Also, this issue is not occurring for all the records. It just occurs intermittently and it also resolves the moment we try to re query using same data. does anyone knows what could be the reason for it? This is the complete error: An error occurred while evaluating expression: XXXXX (Expression evaluation error in rule XXXX at function a!queryEntity [line 4]: An error occurred while retrieving the data. Details: Unexpected error executing query I doubt if the batch i set might be causing it? I have set the batch size to -1? Does it have any impact in query performance?

We have a Record Filter "INSURED" in a case level . For example we are having 3 insured names for a particular policy, we want only those 3 names to be diplayed. Currently all insured names from table are displaying. We couldn't able to pass any filter like rv record or any primary key to fetch the particular insured for policy. Is there any way to implement using record filter or we have to go with manual filters?

I am getting weired error while saving data to records. I have a table which has onlly three not null column. I am passing values to all of them. But I am getting constraint violation error for createdby_tcxt which is not even not null. I passed value for it as well. I checked DB structure, checked records many times. Even I am getting data into the process model to update. The error is like " Data constraint or integrity violation: the createdby_txt field doesn't have default value. Anyone has any idea why I may be faving this issue.

Hi, I am looking to set up this configuration in Appian and I'm not sure how to approach this. I am designing a task manager application where a single task can be assigned to multiple people. So in the interface form, it will list generic task details such as task name, description, due date, and who the task needs to be assigned to. If I assign it to Alice, Bob, and Charlie, then I want to create three tasks with each one assigned to each individual.  <Interface form> Create a single task to "Do Laundry" and assign to Alice, Bob, Charlie. <Data store> 1 - Do Laundry - Alice 2 - Do Laundry - Bob 3 - Do Laundry - Charlie This way I can see if each person has done their task. I assume I need to use a for each loop somewhere in the process model? How do I code this in the process model to create X number of tasks and write X number of records?

In many cases, we have to do join other than primary key for the tables as same can't be configured with sync Record type and ultimately, we need to depend on  Database views and we loose many capabilities of Sync Record type

I'm trying to write into a record and earlier it was getting written but now it just pauses indefinitely at "write record " node. no error nothing , no discripancy in data too

I understand that Record Types are generally preferred over CDTs in modern Appian development. However, apart from plugin compatibility (some plugins only support CDTs), are there any other real advantages of using CDTs over Record Types? In what scenarios would choosing a CDT be the better or recommended approach compared to a Record Type?

My Requirement is I need to fitch data from a view where all the columns are unique except 2 column data i need to show the unique data in the records page just filtering these two records. can you please help me with this using a!queryentity()

Hello! I'm wanting to create a Synced Record Type for Salesforce objects for use within Appian. I successfully created the connected system for Salesforce, but when I go to create an Integration using the Salesforce Connected System, I'm unable to get pagination to work correctly. The SOQL response shows the "nextRecordsUrl" and the first batch of records. However, after playing with the expression rule for the Record Type, I'm still unable to get the Integration to know that it should query the "nextRecordsUrl" instead of attempting the same SOQL query. Essentially, I can't get pagination to work. Has anybody had success building out a Synced Record Type for Salesforce records without building out a custom HTTP Integration, but instead relying on the standard Connected System? Any help is appreciated!

Hello — I would like advice on how to aggregate some data. ## Purpose- The goal is to trace daily changes in workers' working hours. ## Data structure- Each record represents a user's single work session and contains: - **RECORD_ID**, **USER**, **START_TIME**, **END_TIME**, **DURATION**- A user can have multiple sessions in one day, so one user can have multiple records for the same calendar day. Example:RECORD_ID | USER | START_TIME | END_TIME | DURATION1 | A | 12/23 10:00 | 12/23 12:00 | 1202 | A | 12/23 13:00 | 12/23 15:00 | 1203 | A | 12/24 10:00 | 12/24 11:00 | 604 | B | 12/23 10:00 | 12/23 12:00 | 1205 | B | 12/23 13:00 | 12/23 15:00 | 1206 | B | 12/24 10:00 | 12/23 12:00 | 1207 | B | 12/24 13:00 | 12/23 15:00 | 1208 | B | 12/24 16:00 | 12/23 17:00 | 60``` ## Required aggregation steps- First, aggregate these records by **user + work date** to compute each user’s total working time per day.- Then, calculate the **average daily working time per organizational u

Hi, I have a read-only grid with the selectable parameter enabled. Lets say as a user i select 2 or 3 rows in a grid and then when i try to filter the data using the user filter, is there a way to unselect the existing rows ?

In my application, I am trying to associate the same document with different Activity IDs. However, when I go to the documents section, I get this error, which seems to indicate that it is impossible to manage the same document ID on different activities. However, the relationship is 1 document, many activities. Does anyone know how to solve this problem?