Records

Hi All, We are using Orcle Database for our DB in Appian. Recently, our client want to display last updated record at the Top on Grid list. In order to fullfill this we introduce the UpdateOn[Oracle datatype date and Appian Datetime] column in our table, as we have more older record, it was hard to show updateOn date on them. We copied Created date[datatype Date in Oralce and  In Appian Datatime]. We see there are lot of record( more than 12000) which display date out of Range on updateOn column in Appian. Kindly see below. App: 1000789 Date out of range (-739921) App: 1000790 Date out of range (-739921) App: 1000796 3/10/2009 2:06 PM EDT App: 1000800 3/11/2009 3:10 PM EDT Kindly help me here. Regards,

Hi  I am using a recordActionField as link in one of my interfaces. To open the form on click of that link as modal window, I am using the related action.  When I try to show the current value of that field in related action "Display Name", in the interface, it shows me [unnamed] for most of the records and for some it shows value, though every record has value for that field.  If I use the same related action and pass other fields of same table in Display Name using rv!record[], they are displaying completely correct. Can anyone help what can be the root cause. Screenshots attached:    When using rv!record[recordName.A] field creates unnamed issue When using rv!record[recordName.B] field but works completely fine here

hi, i want to fetch data from list of list  robotic process variable in the workflow and process one by one in process model.

Hi, We are using Appian version 22.1, cloud database. Basically, we are trying to fetch Record Details (uuid, record fields, record data source,etc) from log file "hc-record-types.csv". For records that has been created from Appian CDT, we were able to fetch details successfully. But, records which has been created directly from the database schema table , datastoreentity uuid is empty in logfile. So, it is not possible for us to fetch record details from csv file with the help of datastoreentity uuid. Can you please help me where or how to find the uuid of database tables for which CDT not created in Appian OR Is there any other way to fetch record details apart from log files??

I need input a user or group type value, and filtering data. but a question emerged, if field of table is a list of user of group type, "in" of operator is not working. a!queryFilter( field:"c1", operator:"in", value:ri!user ) data: Dictionary  c1 List of User of Group - 2 item     user1(User)     user2(User) c2 ... c3 ... I expected when I input one user, if the user in the list, data is able to filter. 

My read only grid is having a column "Emp - Name" where we are concatenating Emp First Name and Emp Last Name and showing under a single column "Emp - Name". Here how to sort this column "Emp - Name" by clicking on the Header with both Emp Last Name and Emp First Name (First sort with Emp First Name then with Emp Last Name). "sortField" parameter is accepting only one record type field (In this case, i'm able to use either the firstname or the lastname to sort) Please advise.

Hi, While creating a custom records field..i cannot write an expression that exceeds 4000 characters and this is also explained in https://docs.appian.com/suite/help/22.2/records-data-sync.html#exceeding-the-field-character-limit Additionally expression rules are also not supported in custom record fields  If i have to write a Custom record field that has an expression that exceeds 4000 characters - what other options I have ??  Of course trying to make the expression shorter is an option but I am looking for other alternatives other than this. any help will be appreciated thanks jaideep

Hi, I have below Record Type(s) structure. Now when I try to load the column(s) data in the summary page from the RecordType "D", it is not loading. But, when I ran the "Data Sync" for the recordType "D" manually then I was able to see the data in the summary page. FYI: RecordType "B" is having a foreignkey relation ship with column data which is there in the RecordType "B". Any tips please. Thanks in advanse.

Use Case : I will be uploading multiple documents for a single question - Document to questions (many to one relationship ) I have a CDT for Question and another CDT for documents.(Questions and documents are two different tables in database.) Since, I need to populate the document id in the document table based on the questionaries entry - For now, I am getting the primary key of question table first (after making an entry in the database)and then  trying to pass the value to document table for multiple rows. I am making an entry in the Question table via the process model using write to data store entity smart service, then using a script task I get the ID (Primary Key) of the newly inserted Questions and save it against a new process variable. Then, there is another write to data store entity smart service and in the input node I have mapped the newly created Questions ID against the particular column. When there are multiple attachments, only the first row gets

How can I get the list of active and inactive users without using any plugin?

I added a new Record Type that is associated with a table in my database.  Next, I added Record-Level Security.  Then, I attempted to use the Generate New Action assistant to add a Create Action for the new Record Type.  I make no changes to the default values defined by Appian.  When I click the Generate Action button, I get the following message: Your record action and supporting objects could not be created. Try generating the action again or manually configuring the action and supporting objects. There is nothing special about the Record Type.  It is associated with a database table that has a primary key defined.  I have been able to use the Generate New Action assistant for other new Record Types without receiving this error. This error first appeared AFTER the recent system updates to the Appian Community Edition were completed. I have not received it in the past. I have added 4 new Record Types after the recent sys

There is a function getraurlstubbyrecordtype() in 19/.4 to get the url link directly to edit the record but its not working for 21.4. Similar way can we generate the URL in 21.4. Can any one help me with the code how to generate .  Thank you .

Hi, I have a main recordType along with few relationship. Now when I try to show one of the field data from the sub relationship, it was showing like a continuous data even though those are multiple record columns. I would like to show some type of character like ";" at the end of each column data. Example x; y; z instead of xyz Can someone advise on this. Thanks.

Hi, I have written an userfiler insider a RecordType with an expresson. When I try to use the filter in the user interface and after selecting the item from the dropdown, I am getting an error below in the below attached 2nd screen shot. Any advises please. I am getting an error like below

Hi, I need to provide a filter with a date range to filter data in a read only grid. Is there any specific control which can give the behavior similar to the RecordType user filter of type  "data range" (Attaching the screen shot)

Hi, I am using a RecordType to load the data into a readonly grid. Also, I am using few user filters to filter the data in the grid. So far so good. Now when I try to export the data into an excel it is loading only the columns which are there inside the grid. But, my requirement is load all other columns including the columns which are not there in the grid. I know there is one server to export data using the service "Export Data Store Entity to Excel Smart Service". I would like to know is it possible to export the RecordType into an excel using this service. Thanks.

Hello, I've created a datasubset using a!foreach. Now want to filter the data on the datasubset depending on the value for one field. Can you please suggest on this? a high level snippet is below. Below rule returns a datasubset & on that datasubset I am trying add a filter.  todatasubset( a!forEach( items: rule!Irulename(), expression: 'type!{urn:com:appian:types:cdt}|cdt_name'(fields:, completed: rule!newRuleToupdateafield )) )

Hi, We are using Picker field to search client name based on id, using an expression rule to get result of data subset when user enter id or client name. Minimum four char should provided by user in picker field search so that query will search the matching data and displays first 10 ids. For some ids while searching in picker field, getting an below error: An error occurred while retrieving the data. Details: Unexpected error executing query (type:LKTableDataDT2865], query: [queryentity expression], order by: [[Sort[id asc]]], filters: [((id = TypedValue[it=3,v=9000152]) OR (clientname includes TypedValue[it=3,v=9000152]))]) Here, in LKTableData we have records around 19lakhs plus. Regards,Sandeep

Hi Team, We actually have an related action in our record but when we try to open it from android mobile app it is very hard for us to see the related action icon, Even i was not sure why record title is taking the color of site navigation bar color ,Due to this the icon is too hard to visible to users, Please let us know if you have any suggestions Thanks, Udayasai

Hi  I have a main RecordType  which is linked to another RecordType "recordattorneys" which is internally linked to another recordtype "attorneys". Now when I try to set up "user filter", I am unable to do. Getting an error message like "Please add at least one filter option". FYI: I have a one-to-many relation between main recordtype and "recordattorneys" and many-to-one relation between "recordattorneys" and "attorneys"

When I tried to get data using a query filter for a custom picker and when I tried using record picker, I could find a significant performance difference. Record Picker was very fast when compared to a custom picker. How does record picker work and can we do the same for a custom picker also? And I  would also like to know how record type actually holds the data, is it like a cached memory or it fetches every time? Can someone help me understand this?

Need to immediately sync record data after executing the query database node. any work around helps.

Hi, We have a Record Type based on a MySql view, and we just added 2 new fields in the concerned table and in the view. When we used the RecordType, all works fine, the 2 fields are well visibles from Interfaces, ER, or the RecordType itself. The only issue we have is when we try to deploy this component with the Visibility set with the code below (cf screenshot). Please see the error is below. When we leave the "Visiblity" section to true (default) all works fine. When we put back the code with new fields, the error still appears. Yesterday to get out of this situation, we set the Visibility with an ER to not evaluate anymore the new fields with the rv!record[] function, to deploy it. Today, we tried again to set the initial code, an now, it works !?? Would you have any explanation ? Deployment log : 2022-06-15 13:53:19.88 ERROR recordType 6dfe1b0b-91a9-46c0-8133-d6c88103606b The recordType [id= uuid=6dfe1b0b-91a9-46c0-8133-d6c88103606b] was not imported

Hello  I am trying to generate Record Actions for my DB but for 1/2 of my Record Types I am unable to do so. I have tried to generate these actions both with CDT's generated by Appian and also by me (inside Appian) but I always get the following error. I have read similar threads but no solution.