Records

The dropdown field is malfunctioning, displaying all available values as a single combined option instead of presenting them as separate selectable options. Any idea what might cause this behavior.  This is the expression that I am using:  a!queryRecordType_24r4( recordType: 'recordType!{2c57b299-d666-427e-ba44-342541c31f8f}AMS Workflow Type', pagingInfo: a!pagingInfo(1, 5000)).data['recordType!{2c57b299-d666-427e-ba44-342541c31f8f}AMS Workflow Type.fields.{81363ed4-9bc0-44f3-b5ef-e723de125744}description']when i test it separately as an expression it gives me a list and not a single unit

In appian developer course, they mentioned CDT is used for Record type with no sync But in the next Leason , they mentioned CDT will be created automatically once the Action is created for record type with Datasync enabled. where we use CDT ? for non synced record type or synced record type

I have an interface that displays an interface with a form if a local variable is true, else it shows an interface with a grid. The desired behavior is once the user creates an item using the form, the grid will automatically update to display the new item in the grid. It does not do this. The user has to click the grid refresh button to see the new item. The form saves the item using writeToDataStoreEntity in the saveInto of the submit button. On success, it changes the value of the boolean which causes the grid to appear to the user. The grid is a record-backed grid. Changing the grid to use a DSE or changing the form to use a record are not allowed. A process model is also not allowed. Placing the recordData in a local variable and using refreshAfterVarChange does not update the recordData. Using the refreshOnVarChange parameter in the grid does not refresh the data. Placing the grid interface in a local variable with refreshOnVarChange also does not cause the recordData to update.

Hi Team, Just want to know. How to find time complexity and space complexity for Appian in-built functions since its not available in each Appian documentations. Is it possible to find which kind of algorithm used for creating there in-built functions for all the cases like best-case and worst-case sceneries.  Thanks and Regards, Vigneshkumar Radhakrishnan

Hi Experts,I m using read only grid in my interface, where i used expression as data source . If I search the column data correct results are not showing up. Lets say if have fields with status " NOT started" i can see 3 rows of data in grid, but if i search for "Not Started " and hit enter. only one result is showing up in grid. How to solve this Thanks

I am trying to open record summary for requests but whatever record I open I'm getting record doesn't exist. I attached my code I can understand something is wrong but couldn't get what I was missing.  The ri! Request relation is of type request relation. Anyone can help? a!sectionLayout( contents: a!forEach( items: ri!RequestRelation, expression: a!cardLayout( contents: { a!linkField( links: a!recordLink( label: "link", recordType: a!match( value: index( a!queryRecordByIdentifier( recordType: 'recordType! Request', identifier: tointeger(fv!item[requestRelation.field.AppId]) ), 'recordType! Request.fields.applicationId', {} ), equals: 212, then: 'recordType!ABC', equals: 213, then: 'recordType

Hi Team,  I am using custom record field for date difference function (a!customFieldDateDiff), however the problem is that this function rounds off the date to floor. eg 10.99 Days will be 10 Days. do we have any other function which will do the job correctly ?  Thanks in Advance 

Hi All, I am using Oracle DB and in Appian want to create CDT for few tables. I am able to create CDT for few but for few I am not. Below is the statistics I noted.   Total no of columns in DB Total no of rows in DB CDT? Table1 68 9977 Created Table2 51 106881 Failed Table3 45 14 Failed Table4 42 26191 Created Table5 41 14 Failed Table6 36 60354 Failed Table7 32 100878 Failed Table8 32 328 Created Table9 31 2559 Failed Table10 29 39602 Created Table11 29 21581 Created Table12 29 268 created Table13 28 13565 Failed Table14 28 42 Failed Table15 27 83742 Created Table16 27 16792 Created Table17 27 944 Failed Table18 27 497 Failed Table19 26 59 Failed Table20 25 3480 Failed Table21 23 5982 Created Table22 22 195 Created Table23 21 1236 Created Table24 21 1126 Failed Table25 21 339 Created Table26 20 1688 Created Table27 20 501 Created Table28 19 88502 Failed Table29 19 1286 Created Table30 18 1073 Created Table31 18 17

Facing the following error when creating a new record where record sync is enabled. No recent changes in the code or in the record. The record is marked as synced but its data has not yet been synced. More than 50% of the hard disk space is available in the server. Doesn't seem to be a disk space issue. 

Hi, we have migrated Appian to a new infrastructure, so we are trying to align the two environments but the deploy returns errors on some recordTypes.It seems that Appian doesn't see some recordTypes even though they are there. If you click View Record List the message is:The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = XYSYS] at function a!recordList: Record Type {urn:com:appian:recordtype:datatype}4ce79cd7-05b5-40a0-923d-e15cc988b782 does not exist (APNX-1-4198-000). But if I search for the UUID I find it.And the record syncs with the db without error. Has this ever happened to you? Thanks

I'm trying to build a reusable expression rule that queries a RecordType in Appian. I want to pass the fields dynamically via rule inputs to control which fields are selected during the query.

I have an issue I'm stuck on. We have this value writing to the DB for this column: And here it is after the Write to Records node: Does -2137483649 mean anything in the crazy world of data? I tried searching it but didn't return anything useful.

hello I'm on 25.1 and I have the below Use Case: I need to display on a read-only grid a short list (5 or 10 items at least) of last opened Record of a given Record Type. basically I need to store on a table the interactions over a Record List (every time a user clicks on a Record Link) in order to display the "last opened records" as a table I was thinking on replacing the Record Link with a startProcessLink which stores this transaction on a table (recordId, user, timestamp) and then open the Record Summary as a task, but this has several disadvantages: - the record page has several tabs (summary, attachments, other related data ....) which might requires additional effort to refactor - transforming the record interaction into processes might have performance issues any thoughts/suggestion about how to deal with this? thanks

Hi , We have a requirement of Loading Data into a new Table / View from 4 different tables (These 4 tables don't have Record , those are old tables They have CDT) .  In terms of Performance and New features of Records which approach will be better ? 1. Use Store Proc ( Creating a new table > Select required columns from 4 different tables > Insert into new table )  But in this case , everytime if our 4 tables get updated in Prod, We have to run this Store Proc        2. Create a materiliazed view .  but I guess in this case also , we have to update our view if there are entries in those 4 tables       3. Create a normal view from 4 tables  But Record Sync and other data fabric features won't work here I guess Can anyone please help here ? Thank You in Advance

I have an interface where a user is able to click on several choices in a checkbox. Each selection is stored as a separate row in a data table that is linked to their user data.  Adding new choices is easy as you just write a new row for that box. Removing them is a bit more tricky. Is there a standard best practice for this row addition/subtraction process? 

Hi All I am working on version 24.3. I have started exploring Appian AI capabilities and to start of with I find a!recordsChatField() a great component to provide to the user. So as a use case; I have a record which has user filters available. I want to use a!recordsChatField() so that we can provide better experience to the users so that they can use natural language to get filtered records rather than using user filters of records. I have gone through the forum but didn't find any handy tutorial which provides practical example of using the a!recordsChatField(). The only thing i was able to find is the document for the component: https://docs.appian.com/suite/help/24.3/Records_Chat_Component.html Can anyone please guide how can I use this field. Any link to academy online for the same will also be useful.  Thanks in advance!!

I replaced all the cdt to interact with the data using records. for some reason it is not saving the values in the database, nor in the process history fields. But if I check the variables, the values are correctly populated. Is there something I'm missing?

I can't tell if this is an appian problem or a DB problem and am not sure where to begin looking for the problem. When writing to a record I get this error: I wasn't getting this error last week, which is frustrating, but I am now. As far as I can tell, I haven't changed anything that I am aware of that might cause it. The table exists in the db and the table permissions seem to be fine. Doesn't seem to be happening with other tables and I don't have access to appian's error logs. Any ideas as to what I should do next? 

Hi,  I'm trying to find the root cause to why I can't see any records in the "Data Preview" screen of a Synced Record Type. The application works normally and I'm able to push a full sync without any issues. Other records stored in the same database are available in "Data Preview". Context: The data is stored in company hosted SQL Server. Error message: Preview currently unavailable due to an error on the source   Any recommendation to logiles, or actions I can take to understand why the data isn't displaying is appricated.  Thanks for your help  

I'm currently practising in  appian community environment. Is there a way that I can do some hands on on CDT's and Plug Ins.

Hi team,    I have written a expression rule to update a particular row of a record. The Expression rule is working as expected while unit testing but does not work when called in Script task.Could someone please help?

Hi Appian Community, we have one application for which development is completed and planning to migrate it to new UAT instances,  Already have created many records configuring data source in admin console by name like "jdbc/ApnDev001" have plan to create new data source with the name of "jdbc/Appname" in new UAT instance,  while doing to observed that we need to change data source for existing records causing field UUID get changed, and this leads to huge changes at application level wherever we have used these records. Is there any way we could fix this issue (rename or create new data source) without major changes. any form of guidance would be welcomed, Please help.     Thanks,  Shree Krishna tiwari    

Hi Team, I have written query record type with filters to get the records which are reviewed one year back. Filtering based on field "reviewedOn".Currently when i am testing this rule, getting records those have "reviewedOn" is null. How to eliminate these records which have "reviewedOn" is null.Attached Query and output for your reference:Please suggest if any solution available to fix this.a!localVariables( local!lastOneYearReviewedAttestations: index( a!queryRecordType( recordType: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation.fields.{9cc9f1c8-8b6c-4200-94d0-b992949d4303}reviewedOn', operator: "not null" ), a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestatio

Hi All,We have an application which will receive various details from an external system including primary keys for documents which are used for retrieving documents from another system. We receive these details via an API and a task is created for the user to process the same. When the task is being processed by the user, the external system might update the data again which includes adding or removing documents. Since the task is opened by the user, he will never know whether some update has happened to the task or not. We thought of using some refresh variable but it does not seem to be a viable solution. Also it might lead to performance issues since the number of users and number of tasks will be high. Is there any way to handle real time updates and show them in UI?? Any suggestions would be helpful 

I'm currently exploring all the possible ways to insert record in a record type (for e.g. StudentDetails is my Record Type) but I have String fields as process variables. one way I know is (i) Gave Input Variable of StudentDetails type and in Script task Output  mapped the values from process variables  and used write records.