Data Fabric

Hello, I'm trying to create a relationship between two records in Appian. In the database, I have already defined the primary keys, foreign keys, and constraints correctly. However, when I go to the record type view to create the relationship and select the field from the table that contains the foreign key, I’m unable to select any field from the related record. The primary key field does not appear as an available option. Could you please advise on what might be causing this issue? Thank you.

Service backed records sync configured .  Sync by Identifier Expression configured  Webapi configured  when external system hits appian webapi it gets synced with identifiers and able to see it on Records -> Data Preview But issue is we are not able to see it on Grid while configuring it using a!recorddata. And also sync data not showing up on view records list (default records preview) 

Hi, the grouping is not working as expected in bar chart when i am using a!recorddata. I am working on PST time. So, any record which is created after 4 PM PST is grouped as the next day. Let's say I have 2 records, one at Feb 12, 3 PM PST and another at Feb 12, 5 PM PST. When I apply a filter for Feb 12, the bar chart actually shows me data of two dates, Feb 12 and Feb 13. The record which is created at 5PM PST is grouped to Feb 13. It is most likely due to the time difference(8 hours) between gmt and pst, as I can clearly observe any record after 4 PM PST is grouped to the next day. Is this behaviour expected? Please suggest me a solution.

I have an interface where collecting the information & storing in record type.  Then sending this record type rule input to process model to store in db using write records  However before that write records node, I need to update a few of the fields of the record type.  I have tried to update the fields using the following expression, however the data which got from interface is becoming null and record type is updating only with the expression values. Can any one pick it up and shoot it?

Hello Community, I don't know if I'm searching the wrong terms to find answers in the documentation, so I'm going to lean on the community for some insight into my situation. Background:  We are dealing with a rehosting scenario transitioning from Appian Cloud to another environment configured differently.  I am unable to make changes to the new cloud space environment.  I can only work redesign of our app.  In Appian Cloud, we were the only system in our cloud space and utilized JDBC to connect to the underlying MariaDB.  The new environment is a shared space.  The use of JDBC is causing issues with the other tenants interfering with our data and tables.  We have been asked to transition to the use of the connected system object.   Questions:   1.  The database was set up in Appian Cloud by a different resource.  When attempting to build a new Connected System to our MariaDB, it's requesting a username an

I have a stored procedure (called from Appian’s Execute Stored Procedure smart service) that reads from a view and then creates, updates, or deletes rows in a materialized table that is also sourced from that same view. The view is heavily used by multiple applications, so I created the stored procedure smart service to read the updated values from the view and reflect them in the materialized table. This process is triggered by various create or update forms across different applications. Most of the time the stored procedure works, but sometimes it fails with the following error: Deadlock found when trying to get lock; try restarting transaction How can I reduce or avoid these deadlocks?

Hi Team, We are facing an issue when we try to fetch the data through a query entity with a specified column sorting. When we execute the expression we specify the column on which sorting needs to happen. But when we get the result back we see two sorting columns in the result set. Is there any reason that might cause this? This is causing us perfomance issues

Team, good morning! I’m facing a situation similar to some previous discussions here in the community about how to handle large numbers in Appian. I’ve seen topics mentioning Appian’s integer limit, where values may end up being converted to infinity, as well as recommendations to store certain values as text. However, my scenario is different. I’m not dealing with values that will never be used for calculations (such as phone numbers, ID numbers, zip codes, etc.). In my case, I need to store values that may potentially be used in calculations in the future — I don’t know for sure yet (the client hasn’t provided this information), but the possibility exists. This application will be used by wholesale clients who deal with very large revenue amounts (in the billions+). Because of that, I want to handle this situation as conservatively as possible. I’m using Oracle, and I defined these fields as NUMBER(15, 2), in appian it gets converted to

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?

Hi Appian Community, I am currently working on optimizing the performance of our processes in Appian and would like to monitor the memory usage of individual processes. Specifically, I am interested in obtaining the Appian Memory Units (AMUs) consumed by each process and including this information in our task reports. This way, we can query these reports using Process Analytics. Does anyone have experience or insights on how to capture and report the memory usage of processes in Appian? Any guidance on integrating this data into task reports and making it available for analytics would be greatly appreciated.

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?