Records

 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?

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

I'm trying to save the filter with Or and 5 criteria. but it only let me save 4. do you know any workaround or what is the litmit of this a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter(field: "year1", operator: "<", value: 2021),a!queryFilter(field: "year2", operator: "<", value: 2021), a!queryFilter(field: "year3", operator: "<", value: 2021), a!queryFilter(field: "year4", operator: "<", value: 2021), a!queryFilter(field: "year5", operator: "<", value: 2021) } )

Hi I have a table in my appian/Jdbc database and I am using write to Dse smart service to persist data into that table. Is there any log file in the system logs which tells me what data is written to what table and the timestamps ? Thanks

Hi Team, I have to show KPIs information in Dashboard based on a specific user logged in and for a specific status. For example, For user1 when he/she logged in, he wants to see how many active/completed cases showing as KPIs Dashboard. I don't want to handle that in the interface, because that will take a considerable amount of time and hit the performance. Instead, I want to store that info somewhere for example in custom record field; but again, I am not sure that also feasible. FYI: assignee info and status are part of the case table not in any related record. Any other suggestions? Regards, Ghanashyam

Hi Team, I have two CDTs with a one-to-one relationship, which I have already designed and stored. Now, I plan to create records from the database tables. However, I encountered an issue when trying to define the relationship in the records due to the existing CDT data model design. In my current setup, the child table's primary key is used as a foreign key in the parent table. My requirement is to fetch the parent table data along with the corresponding child table data. However, with this setup, I am unable to establish the one-to-one relationship in the records as intended, and I prefer not to make any changes to the existing CDTs. Could you suggest a solution or provide guidance on how to achieve the desired relationship in Appian records without altering the CDT design? Parent :TP_EmployeeDetails TP_EmployeeAddress

Hello, all I have been requested to use the record picker component and use the selected records in the picker  to filter out the records (by identifier) in a read only grid.  The record picker returns a list of variant and I need a list of integer in order to use the filter in the grid, otherwise it will return an incompatible type error. Is there any way this can be done ? the local!selectedApprovalID does return the values I am looking for, but I am getting an error :  " Cannot apply operator [IN] to field [approvalId] when comparing to value [TypedValue[it=197,v={TypedValue[it=1,v=12],TypedValue[it=1,v=23]}]]." There was an answered question in this forum to use the index() function, but that also returns the same error. Please help,   been stuck with this issue for some hours now. Thanks.

I have the requirement of adding Event history comments for a record. As the comments needs to be encrypted, we can encrypt the data once it's written in DB. While getting the data in record I am decrypting the comments in the Record List Configuration. I am getting the decrypted comment in the record List but in the interface of Event History I am getting the encrypted text (same as DB) even after syncing the record. As in image, I want to apply the same decryption rule as "details" parameter over "comment" parameter. Let me know if we can leverage any function or is there any work around for this.

Hi, I am facing issue record type syncing system failure, after updating record in process. The primary key i am using is BIGINT type.

how many related actions and record actions can be added in record, is there any limit?

While testing a connected system point to a Postgre DB we are getting Test Failed. Where is the log file to find the details of what is causing this

Hello,  I have a problem creating a query in Appian, which was previously created in SQL. Basically, we have 2 tables, the main one with the CASE numbers and the status, and another one where we record the historical movements of those cases: Main Table : CASE IDCase Status 1 Active 2 Active 3 Active 4 Close 5 Active Secondary Table: HistoryCase IDHISTORY IDCASE LogText CreatedDT 1 1 Created 11/23/2024 10:34 2 1 Updated 11/23/2024 10:34 3 1 Assigned 11/23/2024 10:34 4 1 Updated 11/23/2024 10:34 5 1 Closed 11/23/2024 10:34 6 2 Created 11/23/2024 10:34 7 2 Updated 11/23/2024 10:34 8 2 Assigned 11/23/2024 10:34 9 2 Updated 11/23/2024 10:34 10 2 Updated 11/23/2024 10:34 11 2 Updated 11/23/2024 10:34 12 2 Closed 11/23/2024 10:34 13 3 Created 11/23/2024 10:34 14 3 Updated 11/23/2024 10:34 15 3 Closed 11/23/2024 10:34 Our SQL query has subqueries, where we look for the last "Update" of each "CASE", so one we h