Records

I need some help to create an expression rule to check if my given time is within the range. For example, my process model will start running today at 6PM then should stop running at 5AM the next day. Now I need to create a validation where it returns true/false to check if the execution time is still within the range. Hope anyone could help me. Thank you.

I need the ability to sort an array of a Record Type similar to how for an array of dictionaries or CDTs you can use a!dataSubset() with the correct paging info.  I tried that with an array of record type and with the correct paging info using the record syntax.  It did not error out when called like todatasubset().  It just returned exactly what I passed in. Requerying the the database using a!queryRecordType() is not an option.  Until a form is submitted, I have to continue manipulating what's in local variables.  Because of the sheer size of the input fields and the quantities of fields, I can not use either a!gridField() or a!gridLayout().  I am looping through using a!forEach() in a card layout.  Removing and re-inserting back into the array is what I am doing for certain user sort functionality.  But, it's more efficient to then resort for all the remainder sub and sub-sub elements in the array. I prefer not having to cast

Is there upper limit on the number of related records fetched with dot operator on the parent record using record relationship? We see only10 records regardless of the total number of children records with one-to-many relationship.

I have a Class record type and a Student Record type with a relationship between them one-to-many.when I try to get a Class with all the students (every student contains classId) I get only 10 of them but I have much more.how can I fix it? a!queryRecordType( recordType: 'Class', fields: { 'Class.relationships.Student' }, filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'Class.Id', operator: "=", value: ri!id ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data[1]

I have created a Record Type which is bound to a Connected System and an integration which fetches data from a REST endpoint (web service) with data sync enabled. I was able to create a record list to view the fetched records in a table. I am trying to add a custom record list action which adds an item to this record type and eventually update and delete actions as well. As per my understanding we have to create sync expressions in order for these actions to work. I am new to the platform and I am not finding enough resources to help me understand how to perform CRUD operations on a service backed record type. Need help in pointing me to the right tutorials/links which can shed some light on this. Thanks.

Hi All, One of our old application was storing date time as TEXT format. Some of the values in DB for column called 'datetime TEXT" column are  5/15/2018 2:57 PM GMT-04:00 5/15/2018 2:57 PM GMT-05:00  3/12/2018 5:25 PM EDT 2/6/2018 1:48 PM EST Recently we are trying to add new column to store this value. Just say "dateTime" column with datetime type. On doing so we will be storing in datetime format for all new request after this update. But for older request the value will be in TEXT format as mentioned above. Can anyone suggest best way to convert and populate datetime for older request into the new column which i have created. dateTime(TEXT) dateTime 5/15/2018 2:57 PM GMT-04:00 ? old 5/15/2018 2:57 PM GMT-04:00 ? old 5/15/2018 2:57 PM GMT-04:00 ? old 10/18/2017 14:02 new 10/18/2017 14:02 new 10/18/2017 14:02 new

Hello, I'm using function a!recordData to return data from one of my records and I need to apply multiple filtering on the dataset: data: a!recordData( recordType: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident', filters: { a!queryFilter( field: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident.fields.{a1a9fdf7-1d9b-48eb-a147-2a233271d74b}adGroup', operator: "=", value: local!adGroup ), a!queryFilter( field: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident.fields.{3729b606-5b1b-4fb8-b16b-c9e929833ece}assignedTo', operator: "", value: loggedInUser() ) } ) When I use both filters, data is not appearing at all, If I remove the second condition I can see some results that are aligned with the first filter definition. However, If I use a!queryEntity function to retrieve the same data for the same entity I get 2 results ( the expected result). a!queryLogicalExpression( operator: "AND",

Hi, I am trying to use a!writeRecord function in an interface button save into block. Below is my code. Id is a Primary Key and is set as AUTO_INCREMENT in the database table. When I set the id as 0, it doesn't seem to accept the identifier and hence fails. What should I do in order to write a new entry into the table using this function? PS : I am able to update the record and the corresponding row in the DB with an existing identifier.

Appian documentation at - https://docs.appian.com/suite/help/22.4/records-data-sync.html#smart-services-that-automatically-sync-data mentions following Data sync will automatically sync any data changed by select smart services. I have the following database record type with the sync enabled. I am writing new record to DB using write to DSE smart-service. The record gets created into DB table, however the record list does not get refreshed. I have to do full-sync manually to retrieve the newly added record. Am I missing something?

Hi All, If you are going to create a New Record type and select 'I want to start from scratch' then there is only the option to proceed with the Maria Database, is this correct and your experience too, or do we miss anything?

hello everyone, I created a form action that allows me to insert records into a record list I created. I have modified some fields in the insert form so that they are automatically filled with automatically calculated values; I noticed that the moment I submit , the inserted record has the said fields empty, would you know how this can happen? I made sure that the data types entered are equal to the type declared in each field of the record list, so I am sure I did not accidentally enter a text type inside an integer :) . For more info I attach the error, and an example code of a modified field : ERROR: Problem:  An error occurred in executing an Activity Class. Details:  Each item within the input "Records" must be a record data type. Received: LBOWI - RegistroFirme. Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority CODE: a!localVariables( local!value : now(),

So I need to make a list of groups and what users are in those groups in Excel. There are a lot of users and groups so I'm trying not to have to do it manually. I can't just make the email addresses with the concatenate formula because I don't have any first/last names to go off of. I'm using groups in Appian and I just want to know how to quickly get these emails into Excel. There's at least 60+ groups I have to add into Excel. Thanks for any suggestions

Hi all, I'm creating user filters for a variety of fields in a record-backed read-only grid. How do I make it so duplicates don't show up in the user-filter drop down list?  For example, if you want to filter by status, there are two statuses available for all the records: Forecasted and Posted. How do I get it to just display Posted and Forecasted once, and not for as many times as there are records? I've tried union() on the 'name' parameter of the a!recordFilterListOption() function but that didn't work. Thanks for any suggestions!

Hi, Please let me know the solution for this, with proper justification. You have data from two unrelated tables. Which Appian objects can easily relate data from these two tables? a)custom data type b)Expression rules c)Record Types d)process models

Hi All, We need to integrate with another application using their Sybase DB. I just wanted to know whether we can have sybase DB as a secondary DS in Appian .

Hi All,I've experienced an issue with the data store. After an upgrade to 22.4 we face the below error. The data store "XXX" [id=0000] was saved but cannot be published:   The data source schema does not match the type mappings: More than one table found in namespace (, ) :  Just to explain the background we're using synonyms for many db objects (because the target objects are in another schema that is not default for the Appian FID). I've seen a comment from an Appian employee under below article that 'support for Oracle is coming in 22.4.'https://community.appian.com/discussions/f/data/10323/unable-to-find-table-or-view-for-oracle-dbDid anyone else have this problem? Any tips? Thanks in advance!

Hi Experts, Our client have a specific requirement for which we need to migrate all the data from Oracle on Premise database to the Appian Cloud Database i.e Maria DB.What all are the step involved for the effective data migration.Note: Tables are yet not created in the Cloud database. Thanks, Gaurav Singh

I need to perform full sync for a record when there is some tables updated in the Database. Is there a possibility to perform full synchronization in a process model without passing any identifiers to sync records smart service. Thanks

I have an action in a record type. I've set up a very simple visibility rule for it, but it behaves weirdly. The record type has a field Canceled of type Boolean and it cannot have null values. The visibility rule is configured to show the action only if it's not canceled. The action is available for users in a read-only grid and in a Related Actions tab of record's overview. There's always correct behavior in the Related Actions tab. In the read-only grid the action is shown only if I add a check for NULL to its visibility rule. And in that case the actions is always visible in the grid, no matter if it's canceled or not. So it behaves like Canceled is always NULL, though there's always a value. What might be causing this problem? We are still on Appian 21.4 hosted in our environment, not sure if it matters.

Hi All, Could someone please help me understand the difference between data Sync and immediate data sync for record type. I was referring "https://docs.appian.com/suite/help/20.4/Record_Type_Object.html#data-sync and in that I am confused with the topics "Data sync" "Updating synced record types"   Under "Data sync" the below criteria is given: You should only enable sync for your record type if: Your source data changes infrequently outside of Appian and it doesn't need to be synced into Appian more than once a day.   Where under the topic  "Updating synced record types" it talks about immediate update? Thanks Faisal

Hi All,We have an issue while trying to publish the Data Store.Couple of points to give you a background: Appian User is not assigned with proper Default DB Schema - the schema where all of the tables and views are held - (Therefore we're using Synonyms) After upgrade to Appian 22.4 we're unable to Verify / Publish the data store We have found the workaround by adding schema  annotation to all CDT XSD <xsd:appinfo source="appian.jpa">@Table(name="TABLENAME", schema="SCHEMA"). This workaround fails however when the CDT in question has 'primitive array'. In such case Appian creates a related table for the 'array' field.Because those tables were created in another schema we now cannot publish the entire Data Store. We have multiple such tables, therefore we would appreciate any help (Other than changing the default schema - which is currently not an option in our business case). Can you please advise if you

Hi! Does anybody know if there is a data limit for and export sql to flat file? I've been asked to research that as our App need to export large numbers of data in the future! I know it's. deprecated but it's what we have developed and I don't think the product owner will want to update de feature! Thank you

Title: Record sync issue post write to DB smart service call Body: I have used Write to datastore entity smart service for updating a record in database table, this works fine via a record action but when I'm using a related action, I am getting sync issue in recordType after related action process flow completes and returns back to the record summary dashboard. Below are the logs I could find for the issue: 1. Loading updates to synced record type(s) in ADS failed, invalidated record type(s) 2. 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-4205-039) Can you please let me know why is this issue happening and how to fix it.

No longer need assistance, thanks!

Scenario is need to filter the data based upon user access to certain business unit id,forum id.Business unit id's are different sectors of business and they are mapped to certain forum id's.Business unit can have duplicate forum id's. they are stored in table like  user id bu id forum id 117 4 80 117 4 103 117 4 114 117 19 80 19 also has records with 103,114 forum id but we need records on the above mapping but when we try to filter it out by querying and storing in a local variable not able to filter out records for mapping of(19-114,19-103). local!buid(filter:userid), local!forumid(filter:userid,buid), In a interface we are using a record type in data and in filter we are using logical expressions.