Data Fabric

Hi Appian Community, we have one application for which development is completed and planning to migrate it to new UAT instances,  Already have created many records configuring data source in admin console by name like "jdbc/ApnDev001" have plan to create new data source with the name of "jdbc/Appname" in new UAT instance,  while doing to observed that we need to change data source for existing records causing field UUID get changed, and this leads to huge changes at application level wherever we have used these records. Is there any way we could fix this issue (rename or create new data source) without major changes. any form of guidance would be welcomed, Please help.     Thanks,  Shree Krishna tiwari    

Hi Team, I have written query record type with filters to get the records which are reviewed one year back. Filtering based on field "reviewedOn".Currently when i am testing this rule, getting records those have "reviewedOn" is null. How to eliminate these records which have "reviewedOn" is null.Attached Query and output for your reference:Please suggest if any solution available to fix this.a!localVariables( local!lastOneYearReviewedAttestations: index( a!queryRecordType( recordType: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation.fields.{9cc9f1c8-8b6c-4200-94d0-b992949d4303}reviewedOn', operator: "not null" ), a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestatio

Hi All,We have an application which will receive various details from an external system including primary keys for documents which are used for retrieving documents from another system. We receive these details via an API and a task is created for the user to process the same. When the task is being processed by the user, the external system might update the data again which includes adding or removing documents. Since the task is opened by the user, he will never know whether some update has happened to the task or not. We thought of using some refresh variable but it does not seem to be a viable solution. Also it might lead to performance issues since the number of users and number of tasks will be high. Is there any way to handle real time updates and show them in UI?? Any suggestions would be helpful 

I'm currently exploring all the possible ways to insert record in a record type (for e.g. StudentDetails is my Record Type) but I have String fields as process variables. one way I know is (i) Gave Input Variable of StudentDetails type and in Script task Output  mapped the values from process variables  and used write records.

Hi Appian Community I am using a web service to fetch the records I have synced all the records successfully but, in the list, there are less records available.  Sync successfully for 10046 records but only 6549 available in the list

Hi everyone, I'm having this issue and trying to find some help/ recommendation.  I'm having this process report that contain 1 row of data. But when I run the expression rule to query it with 2 different user account, I get different results, even though the 2 accounts are in same All Users group and that group has Viewer level security in my report.  With my main user account, when I run the query I get that 1 row of data back as output - expected With my test account, I get null value as output - Even though when I open the report I can still see data displayed.  Is there any other areas apart from security level that I should look at?  This is my code snippet, I just input in the context process model and report if( ri!isMissingMinimumInputs, if( ri!doReturnData, {}, a!dataSubset() ), a!localVariables( local!columnConfigs: if( not(rule!GBL_isEmpty(ri!columnConfigs)), ri!columnConfigs, a!queryProcessAnalytics(

From the Grid Layout list i need to add to the other Selected List which is Related Record Data. So when calling this grid interface i am facing issue in the Parent Interface that. When I am selecting more that one item from the list it throwing me the below error. Please let me know how to rectify it Interface Definition: Expression evaluation error [evaluation ID = 033a4:c74b3] : An error occurred while executing a save: Expression evaluation error: Cannot update List of DIL Product User Trans; length of assign value list (2) does not match length of the list to update (1) 1. No Error while selecting 1 item from the list 2. If select more that on item from the list it throwing the below error

Hi, How we can create dropdown using record data?

Hello, I'm creating a process model to synchronize a database with a record type.In the process, I created a node that uses the "Sync Records" smart service.According to the documentation, synchronizing more than 1,000 records requires a loop.I've followed the steps, but the "Sync Records" smart service doesn't return anything inthe "ac!RecordsUpdated" variable, which should be used to avoid an infinite loop.Here are some screenshots of the configuration and docs link. docs.appian.com/.../Sync_Records_Smart_Service.html The import to the database is successful, but the record type is not synchronized.

Hi everyone, We have configured a process report to retrieve all active processes. Additionally, we have a query to obtain the active process ID for each case based on the Case ID. However, we are encountering an issue where multiple values are appearing in the column of the process report (mapped pv value for column in process report). As a result, some of the active process IDs are not being queried correctly. Could someone please help us understand why multiple values are appearing in the process report? Is it because the process report contains the value changes from the process history?

Hi,What trying to create a sample data for a Record Type but is throwing the below error. Even tried suggestion given on the error but again throwing the same. Kindly let me know what else can be done. 

Hi Team I am using an environment specific date constant. This is an array of dates constant .. I want to deploy to higher environment but in such a manner that the constant should be null ( because I will be appending values in it via process model as part of logic later ) While deploying I am passing nothing in the custom properties file  eg :   content._a-0000ed12-853e-8000-9c18-011c48011c48_2772176.VALUE= But when seen in higher environment it comes like this :  I wanted it to be blank ( i.e. nothing in the constant ) .. somewhat like this :  Is there any way we can achieve this via custom properties ?

How can i check what value appian returns?

Hi all, For context, I'm trying to display a record type "Files" which as of last week has hit the memory threshold (800,000+ records). The record type is still legacy. When I try to access the record via Tempo > Records > Files, I'm displayed with  "The Requested Record Type Is Not Available An error occurred while retrieving the data for "File". Details: Unexpected error executing query ...." I've tried a few approaches but the most noteworthy one is  :  1) Updating the default filter criteria to only show Files that were created the last 2 years. The problem with this is if I need to access something older than the 2 years I won't be able to. In short, I just want to limit the Record List view to maybe 200 records but the data source having access to all 800,000+ records so that I can still have a functioning record that can display the appropriate views when accessed individually. Thank you.

So I have a process where a user uploads a .csv or .txt file with numbers. Those numbers are then extracted and ran through various validation checks. When a user uploads it in a .txt file, no issue. When it's a .csv file, the very first value, a fn!char(65279) is always added before it, so it's failing the validation check. Like so: When I copy the expression and paste it into the rule input of my validation expression rule, that first number always fails the validation check. But if I remove the fn!char(65279), it passes and works. A quick google search showed me that this is some sort of whitespace character. So I tried adding trim() to the variable that hold each individual extracted number, but that doesn't appear to make a difference. Does anyone have any idea? To either prevent that char from being extracted with the data, or to remove it after extraction? Thanks for any help.

Ran into an issue where any writes to record A were failing because record B had a sync issue. Record B was the Event Type Lookup for Record A, which was why record A writes were failing. The error in our logs is below: It sounded like the issue here: (+) Appian Community, however the difference was that our scheduled daily sync for record B passed just that same morning. No updates were made to record B, and no new data was added to record B recently enough to cause the issue. In addition, while there was a warning icon next to Sync History for record B, there was no history of any failed syncs, and once I manually synced, the error and issue went away. I'm not sure what happened how to go about checking what kind of invalid data popped up. Anyone ran into this before? TIA

What is the main difference between a!queryRecordType, a!queryRecordByIdentifier and a!recordData. When to use a particular one?

I'm setting the Record-Level Security and I have this Expression: if( a!isUserMemberOfGroup(username: loggedInUser(), groups: cons!MIN_Administrator), /* Show all records */ null(), /* Show only records that belong to the particular company*/ a!queryFilter( field: 'recordType!{5608cfad-fc67-4a81-93b5-722c9b55f2c5}MIN Test API.fields.{d1b51e83-1de8-430a-8d7c-e6e433601ad4}company', operator: "=", value: "*CompanyNameAsAParameter*" )) If the current user belongs to the Administrators group, they'll see all records; otherwise, they'll only see those whose "company" field has a specific value ("*CompanyNameAsAParameter*"). This value will vary depending on the logged-in user. Is it possible to pass this parameter from the interface, or is there a workaround?

I have a Record Type with a large data. When I add it to a Site I can see all the records but I want every user see only their related data using a particular field ("user"). I'm using the showExportButton and showSearchBox properties and if I filter the RecordType I lose them. Is there any way to filter the data for every user and continuing using all the parameters of the Record Type? Thanks!

As you can see, I'm creating a new Record Type from a Webservice. I get de data properly. But when I try to sync the data in the Record Type I get the following error: Type could not be inferred due to inconsistent types for field(s): discountPercentage I think the format is ok. Do you why I getting the error? As you see bellow in the Expression Rule commented code, I map the fields formating the decimal fields but I don't to do so because I would map all the fields. Any idea to solve it? Thanks!

Hi  I have related records : Purchase Orders - item code, qty Items - item code Pricing - item code, price, effectiveDate An item can have multiple prices so there is a 1 to many relationship. I am wanting to use the custom record field on the Purchase Order record to calculate the cost of the Purchase Order ( Purchase Order. qty * latest pricing for the item) I have an expression rule that returns the latest price for an item however the custom record fields does not allow us to use expression rules. Also, since an item can have multiple prices, I am not able to get the latest price from just using the . notation from the related records. I need to have the cost in a custom record field , as I need to aggregate the cost by supplier. Please advise on a way to achieve this. Thanks

Hi, I'm using email to trigger process model. By setting public events in process model, I'm able to get data into process variables. When I'm trying to write it Records, I'm getting below error. The input "Records" refers to an invalid record type. The record type does not exist, has been deleted, or the user does not have sufficient privileges to access the data. I understand that record types doesn't have permissions. But how to provide permissions is what I need know. Thanks in Advance. Thanks, Sadhu Surendra

We have a record with a large complex Security Expression defined in Record-Level Security. When querying this record using an a!queryRecordType, the query takes ~1,500ms (90 rows, ~ 16 columns) When querying using a!recordData in a gridField, the query takes over 13,000ms To make the test fair, we have have kept just 1 column in the grid showing the ID of the record, and have not defined any sorting, no filters are applied for either query When the record level security is turned off,  a!recordData in a gridField takes 253ms to run. What might be causing a!recordData to perform so much worse when record level security is turned on?

Hi All, We have below requirement, please read and assist me on this. We have 2 Event data:                                1. Request Event data                                2. Task Event data We need to merge above 2 dataset and show details in a single page with using Event Timelines patterns/components. Can you please check and assist how we can achieve? When we are taking Event Timelines patters with selecting records type then, we can select only one record type as a time under Event Timeline components but we need to take both records type and then make the relationship on script level. Please provide solution for achieving above. Thanks in advance. 

I'm developing a Help Desk application and need to create a column chart for priority. When a priority is clicked, its ID should be stored and passed to a drilldown grid but the current code is displaying the ID as the label instead. a!grouping( field: 'recordType!HD Request.fields.priorityId', alias: "priorityID ) If I use 'recordType!HD Request.relationships.priority.fields.value' directly in the field, it throws an error. Any suggestions on how to display the label name? Thank you!