Data Fabric

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

Can we export charts or images in excel?

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?

Hi Team, I am using a record-based grid to display data. But unless search button is clicked, data does not get loaded to grid. Thanks, Kavya

Hi everyone, We are planning to connect Appian to an on-premises SQL Server environment. Due to security and network restrictions, Appian developers do not have direct access to the on-premises SQL Server. As a result, we are unable to directly inspect table structures or view data stored in the database during development. To support smoother development, investigation, and testing activities, we are exploring whether it is possible to view and reference on-premises SQL Server data from Appian. Specifically, we would like to understand the following: Is it possible to synchronize or replicate data from an on-premises SQL Server to the Appian Cloud Database? If so, is there a way to browse and inspect table data using a GUI similar to the Appian Cloud Database? Thank you in advance for your help. Hatsune

We have a database table where we store a reference to a Record Type (it could be the Record Type name, UUID, or a string like "()"). The requirement is to convert this stored value into an actual Record Type object at runtime so that it can be used in expressions or interfaces. For example: cast( 272, " 'recordType!{b12345-12345-12345-12345-c12345}ABC' " ) Is there any built-in function or best practice in Appian to achieve this dynamic casting?

I am trying to use a create new record action to insert a new record into my table and based on the grid I am showing to the user they only can see records associate to an related record. I would like to be able to pass in the primary key for that parent record into the record action so I can default that field to use that value and not allow the user to associate to a different parent on accident. It is possible that there is not data in the grid but I would still know the primary key of the parent record to pass in.

When creating or editing a record type, you can see the URL of the record list. How can I read this so that I can create a link button to the record list for the user? I don't want to see a single record, but the complete list. The solution is: a!urlForRecord( recordType: cons!SODA_PGN_RECORD_TYPE_PGN_REQUEST, targetLocation: â`˜TEMPOâ`™ ) I was just missing the function a!urlForRecord().

Hello, I have a question related to End-User Reporting tool. In the Appian Community it is mentioned that this tool was last updated on May 2023. Since then this listing has been archived. I would like to know if there are going to be any new versions or upgrades related to this tool in the future. Can we use this utility for future application building. Thank you.

{ { '1': { loggedInStatus: "Succeeded", timestamp: { sessionDeletion: "", lastActivity: "", login: "2025-12-03 07:43:17" }, sessionId: "abcb9532-b5f5-4e2f-8946-8f08a17e307f", status: "Active" }, '2': { loggedInStatus: "Succeeded", timestamp: { sessionDeletion: "", lastActivity: "", login: "2025-12-03 08:27:31" }, sessionId: "08ad7f98-85f6-4fd5-a072-6278731cbfef", status: "Active" } } }Here in this example I want to access a field "sessionId". I tried to wrap this using a!flatten () but still it doesnt work. Any help here ? Thanks in advance.

Some of the queryRecordTypes are working slow for us in prod. I am trying to monitor the performance and it has something 'performanceView.breadcrumb.recordQuery' highlighted. What does that mean and what part of the query/record it points to? Any idea Also, Appian do recommend using queryRecordType to get the data from the related records too but when I have filters and logical expressions applied to them they are performing slow.