Data Fabric

I cannot able to use user filter in a!eventhistoryList(), even though i have added only one a!eventdata() why is that, how can i solve this ??

Hi everyone. I added a new Decimal field to one of my DB tables, but when I try to map this source field to the corresponding record field in Appian the Number (Decimal) type is not available in the dropdown (please see the screenshot below). Does anyone know what could be the reason for that? Even Appian recognizes the source field as Decimal, but still doesn't give me a proper option in the choice list. I would appreciate any advice on this matter. Thank you.

I´m doing the Appian Developer Course, and in the Build an Application Step by Step part 5 I have this error, related to the Record Type: Expression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 52]: User Does Not Have Rights to Perform this Operation. Can someone help me with this error?

Hi, I have a very simple need : I have a main Interface (Intf_A) displayed from an User Input task user of a process (Pr_A). In that interface I have a Button (related Action) used to display another Interface (Intf_B) which is a start Form of another Process (Pr_B). In Intf_A I have a Text field, and when I click on the Button, I need the text value to be passed to the IntF B. How may I do this without saving first the Text value in DB ?

Question : we have a employee table , we applied the partitions and indexes on the table to certain field. But the employee table is sync able record type , will the partition and indexes really gonna make any impact when i execute Query record on it  ?

With CDT, we can use @Version annotation for optimistic locking. Optimistic locking is a concurrency control mechanism in which it ensures that concurrent transactions will not conflict with each other. If there is a chance of conflict during transactions, the transaction having an older version number will be aborted. Can we achieve a similar thing using Records?

Is it recommended to store all record types in a folder  e.g. RecordType folder?

I need help creating a process model to evaluate and batch update the status of a large group of users (30,000+ records) based on detailed criteria. The workflow logic is as follows, with any identifying info removed: User Status Evaluation Process Initial Conditions If either of the following conditions is true: There is an entry in a related table where the status is not equal to "denied", OR A specific approval flag is set to true. Then: No further action is needed for this record — it can be skipped. Handling Rejected Entries If an entry exists in the related table but its status is equal to "denied": Check if there is another flag indicating confirmation of a related process or action. No Entry and No Approval If no entry exists in the related table and the specific approval flag is false: First, check if a secondary task or decision exists with a status of "approved." If no approved secondary task or decision exists, check for th

Hi, Thanks for your help in advance & much appreciated if someone has faced this design scenario already . Bit of background , We have a significant number of historical cases in a DB as we are decommissioning an outdated system . In a nut shell, These cases are not going to change or case count is not going to increase. case count is significant (10,000 or a million) & number of end users not too much ( around 100 ). We have a REST Api which exposes the DB (containing historical cases) mentioned earlier. I am creating a site to display this historical case data . I am planning to use record sync to load the data in to a record. As data is not going to change or increase, all I need is data load to the record, not really data sync , Can I still use Appian's record "data sync" facility? Do the "data sync" needs to be run daily ? or I can just load the data once and query the record to filter for example if the data remains static ? This is the interface

 Business Objective: When Speakers apply to speak at one of our parishes, they supply documents to support their application to be a speaker.  Many of Speaker will apply to speak year after year.  There are three types of documents General Documents that are required and are valid for many years.  (For example their background check is valid for 5 years). Event Documents that are required for each event they are applying for. (For example the contract for the events). Optional Documents to support their application and are not required.  These could be general documents or documents for a specific event. Required documents are customized for each of the Speakers.  For example, depending upon their country, there are different agencies that do background checks with their own forms and documents. There are two areas (interfaces) where the documents are uploaded; the Speaker Interface (this is NOT a portal, as we give the speakers Appian login credentials)

I have 3 records having one to many relationship  Timesheet(ID,IS_ACTIVE), Audit(ID,TIMESHEET_ID,IS_ACTIVE) and Comments(ID,AUDIT_ID,TIMESHEET_ID). When I tried to use single write records smart service, I am not able to populate value for TIMESHEET_ID column value in "Comments" table. Is it expected or do we have any other way to handle this?

While looking into the Dependents and precedents we found out that the issue was due to USER record type which is available by default in all environments. Has anyone faced similar scenario and how to work around it to successfully deploy the application from DEV to TEST ? FYI: 1. we have updated the instance version to latest release and also updated the User Record Type to latest version. 2. The missing precedent is the User record type fin the SS.

The total number of sync rows with the web source is 136,614 but in the Record List there are only 82,874. After each sync with the web source the number of rows in list are different (80,000 - 90,000).What could be the reason?

Data is residing in DB but is it possible to show encrypted data in UI instead of actual value?

Is there an easy way to switch tabs from process to monitoring, or split the tabs? It's so struggling to be clicking all the time

I'm trying to get the list of the custom data types that uses date and time field in it, from the whole application. Kindly post your suggestions, Thank you.

Hi! I have 2 related tables that I have access to BUT do not own. Let's say the 2 tables are Recruiters and Members.Recruiters has an interface showing recruiter records. This is the entry point of the portal.I want to have a column in the Recruiter interface that holds links to the Members interface. The Members interface must show records in the Members table depending on the value of multiple columns of the recruiter row clicked.Take note that I do not control any of the 2 tables so I cannot make the "blessed way" of using those columns to build a composite primary key. I need a way to pass those column values to query and filter the records in Members table and display them in Members interface.How do I structure this UX / logic in "idiomatic" Appian?

I have a record configured to sync data with an on-premise table using a 'SQL Server Data Source' connected system to connect to the database. Due to changing requirements, I’ve disabled the scheduled sync in the record type and deactivated the user ID on the SQL Server to prevent data fetching. However, I still see authentication requests to the server, which I believe are from the connected system object. Is there a way to disable the connected system without deleting it?

Hi , Can anyone help me with this please!. Thank you for the help in advance. local!pdf , ri!upload: recordType!ABC(), . .... ..... shadeAlternateRows: true, addRowLink:a!dynamicLink( label: "Add", saveInto: { a!save(local!pdf, append(local!pdf, ri!upload) ) } ) I am trying to add a new row , but maybe i am using ri!upload as value  i am unable to get the desired output , the interface iis showing the same uploaded images  every time i click on add new image link. 

I created a simple RecordType and defined relation with User for createdBy and modifiedBy. I added recordlist to new Site. It was working few days back. Today I am getting the following error.  Nothing has changed in last few days. The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = HE53D] at function a!recordList: An error occurred while retrieving the data for "User". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000). Synced the recordtype few times through manual or data edits through data preview screen. Please help me with why this is happening today? 

Hi Expert, Can we use a POST integration API which actually queries data from a third party system to configure as a Sync Record Data Source, if yes  then how ?I have created an expression to get the data using the integration object which is working fine in the Expression rule while throwing error on using the same in Record Type. Thanks, Gaurav Singh

We have 3 records in our application say record A, record B and record C. Record A is having one to many relation with record B where record B is having one to many relation with record C. Record A is having generic details, record B is having section details which can be multiple and record C is having one editable grid having multiple entries which is present in the above section. We are facing issue while displaying and saving the value into the rule input since we are not able to use [fv!index] for record variables. We are using only one rule input of record type A. How to make sure to show the values properly and save them properly?? This is just a mock UI i created for explaining the issue. Add member will add one more row in developer details grid. Add Team will repeat the whole section again.

Hi Experts, I'm getting following error while deploying the record type object to higher environments : "Record type Test Expedited Order cannot be synced because its record fields do not match the fields in the source. (APNX-2-4195-003)" I'm using two sync enabled records "Test Expedited Order" and "Test Authorized Agency" with many to one relationship between these two records where mapping is as shown below.As of now I have to manually update the mapping of the record type post deployment so as to make it working. And after updating the mapping and saving it there is no difference in the version of record. In above image the highlighted once are the version created due to deployment where as the latest one and the version 2 are after manually updating the mapping. Is this a known issue with the records type or is there a way possible to get this fixed. ?

I am inserting excel data to data base using write to data store entity smart service  .  I need to inset two more fileds of data which is user inuput data which will be entered when uploading the excel  through the write to data store entity  .  I don't know how to acheive it. Can anyone help me?

f I initially leave some fields unmapped in a record type and later decide to map them, what happens to the data in Appian? What should be the best practice? Let's suppose for instance that the system will need some unselected fields soon, but not yet