Records

Hi everyone,  I'm having these 2 tables. For each table I created 1 synced record, in synced record for Leave, I set a many to one relationship with Status, and by contrast, I set a one to many relationship for Status to Leave.    I ran a SQL script in DB to update statusId values to 3 (UPDATE User SET statusId = 3) and when I check again, SELECT * FROM PPL Leave WHERE statusId <> 3 returns 0 result. After that, I went into PPL Leave synced record and do a fully sync. I'm expect to see the synced record data to be updated to be the same with the table (all statusId = 3), but instead I can see no change in the sync record, and query SELECT * FROM PPL Leave WHERE statusId <> 3 returns 2 results (which I'm assuming after the sync, data in table was updated to be the same as in sync record).  Is this a strange behaviour or did I set up something wrong?  Also, if possible could you explain for me the

I have a read only grid where I will search records and filter it and from there click on record link and navigate to record summary and from there when I navigate back to same readonly record grid i want search results to be retained with searched text. I tried passing the value as ri. But since Summary interface is already configured with static value in Views its passing as null. Any idea how to get it done?

Is it possible to configure record link on row selection on read only grid. I have tried selection Save Into to set a value with selected record id but not sure how to configure record link here.

Greetings everyone, I've been going over the Applian Academy Step-by-Step #5 pertaining to designing record types.  I've created the record type for "AX Vehicles," but when I save there and attempt to configure the database source, the "Choose Database Table" is empty and I'm unable to proceed.  Please offer any advice you can. Thanks in advance!!!

im working with records and i want to export the data that im showing in the record, to do this i want to use the parameter showExportButton and it says that this parameter only applies when a record type is used as a source in the data parameter. in the data parameter im using the function a!recordData, the button to export is visible but is not working, anyone there to share the solution?

Hello, In record filter not in operator is not working for multiple selection.  for single selection is working. If I passed IN operator, then working as expected.  can anyone help me on this? please find code for reference.

Hi Folks , When we create a CDT we get an option to hide it from pickers and auto complete , what's the use of it , in what scenarios can we use it ?

We're using a record type, but one of the record field types needs to be changed from integer to text. I can update it in the database, but when I try to run a sync in hopes of being able to change it in the record type as well, the sync fails. How can I achieve this? I do not want to delete the field and create it again since it's referenced in a lot of objects that we use.

I'm getting this error after completing Exercise 5_Records Part 1 in the Appian Developer learning path. I reviewed the steps, and I still don't know what's causing it. Can anybody tell me what's causing this and how to resolve it?

I have this code which I use to query task report. I want the filter to check if the asignee groups are in an array of input groups. Take a look at the working example first:a!queryProcessAnalytics( report: cons!GBD_Report, contextProcessModels: cons!GBD_Process, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100, sort: a!sortInfo( field: "c2", ascending: true ), ), filter: a!queryFilter( field: "c4", operator: "=", value: ri!group ) ), ), This works because ri!group is not an array but a single group. However when I turn the ri!group into an array of groups, and instead of operator "=" use operator "in" so basically check if group is IN an array of groups I get no data

Good day Some users asked me if it is possible for us to have a kind of "Global" saved-filters. By today, each one of them need to fill the fields and go to Manage Filters > Save filter as .... But as they are store operators, they have a lot of filters that they wanted shared between them. After saving we have the following Filters: We wanted to define a global version of this, so every user in that profile might have access to it. Is it possible to do ? Or at least a user can export their filters for the others to import ? Thanks in advancecc.: [mention:a897b8cf98a0422ea0250353deb54416:e9ed411860ed4f2ba0265705b8793d05] 

Hi Team, I need contained both records data into single record and display to the read-only grid in Interface  

I have two tables with n number of columns out of which mobile number, plan, and amount are common in both tables, we are getting data into tables from two different locations, now i would like to show plan and amount from two tables for which mobile number is same and to be shown in same grid, Can we do this simply without using complex logics and local variables

First, in the project that I am working currently we do not use the record sync, I have a case when I perform an action even though I am using the refreshVariable function and also activity chaining in process models, the interface is not refreshed without refreshing it manually. What can be the problem?

can we have dynamic label for columns in appian record type. For Ex. For current year, it should display 2023, for next year it should display 2024 and so on. Is it possible to have this implementation done?

I have a readonly grid backended with recordtype with 3 user filters, Initially all the data is showing and filters are applying when we select user filters, that is fine but my requirment is no data should be shjown in the grid untill we select atleast one user filter,  Can we achieve this? If yes how can we do that

Hi teamWe have moved an existing application to a new schema, and we are also getting rid of the old CDTs in order to use Record Types instead.I need to know how to apply the 'type' function where the new schema name is SierraUniformMike and the recordtype name will be SUM Onboarding Case 'type!{urn:com:appian:types:PRE}PRE_OnboardingCase'( id: null, case: rule!DCM_newCase( reference: joinarray( { "PRE", text( rule!APP_default(value: now(), default: today()), "yymmdd" ), rule!APP_generateUUIDSegment(6) }, "/" ), parentID: null, priority: null, milestone: rule!PRE_getCaseMilestoneByUUID( milestoneUUID: cons!PRE_UUID_ONBOARDING_CASE_MILESTONE_OPEN ), assignment: null, type: rule!DCM_getCaseTypeByUUID( uuid: cons!PRE_UUID_CASE_TYPE_ONBOARDING_CASE ), createdOn: now(), createdBy: loggedInUser() ), createdOn: now(), createdBy: loggedInUser() )OK, I

I am using PostgreSQL database for my application. This database is hosted on the AWS cloud server. I want to move it to the Appian Cloud server. How can I achieve this?

I am trying to cast record fields, and I am having that one field that is referenced in another record and when using the casting rule i am including this field. now when i write into the record using write record node: The input "Records" cannot insert or update a record which is referring to different referenced records via mbappid at the same time. To create a reference to a related record, include either a relationship reference or the required common field value for "mbappid". Location of conflicting changes: record(id: 123570) my approach was: a!forEach( items: pv!familyMembersDetails, expression: rule!CR_recordType( record: fv!item, status: "DEACTIVATE", mbAppId: fv!item['recordType!{record}record.relationships.{record}relrecord.fields.{}mbAppId'] ) ) but it still returns the error 

Is anyone aware of any frameworks or apps available for user-managed reference data? This is, a component for users to add/edit/remove lookup data, add/remove relationships, etc. 

Hi all, I am loading thousands of rows in a sync-enabled record through Import Excel into database plugin. How to deal with errors from process execution when trying to import date/time Excel columns with no current date (or Null). Is it any alternative rather than inserting a default date/time value?  Thank you for any suggestion, 

Please provide possible fix regarding below issues. 1.) 1 error occurred in Report: NGP_RPT_PliDecisionSummaryGrid 100% of errors due to: Expression evaluation error : Rule 'ngp_tab_plidecisionsummarygrid' has 2 parameters, but instead passed 0 parameters. 2.) 7 calls, 12037 ms peak average, 0.7% of total, 0.1% prepare, 96.4% execute, 3.5% transform, depth: 0, breadth: 12 3.) 5680 ms peak average - NGP_PAR_Send_Notifications (0002e36e-a0f5-8000-a2f0-010000010000) -> GOA Request Cancelled

I have a parent record case details which is having a one to many relationship with another record task details. When the data of caseDetails is loaded on first load of interface in rule input or local variable either using query record or process model, then I'm using count() or length() function to count no. of items in related record "task details" which is populating in relationship of caseDetails in same rule input or local variable. Count or length both are returning count as 1 only. But, if I make any changes in loaded tasks list and it's updated on any user action then count is showing correct count of items in that relationship.

I Have a Requirement like, I have a Process Variable called 'DETAILS' which is of 'RECORD TYPE'.post submitting a particular form the data will be writes to Records. Then I have to use a Script task in order to change the PV 'DETAILS' Type from Record to CDT and use the PV as a CDT type value for upcoming nodes 

I have a record lets say A thats a child of record Parent. I will create multiple reports for Parent from child record. Record list action should fetch the parent id from the child record where i am going to configure the record action field and that value should be passed as process model parameter