Records

Problem:  An error occurred in executing an Activity Class. Details:  An error occurred while trying to write to the entity "AX_Maintenance" [id=2ec391d4-a462-4e0e-92e4-b01ad2475087@3690, type=AX_Maintenance (id=3836)] (data store: AX Data Store). Details: org.hibernate.PropertyValueException: not-null property references a null or transient value: AXMaintenanceDT4830.vehicleid Data: TypedValue[it=3836,v={<null>,<null>,2021-11-25,0,o,Scheduled,<null>,<null>,<null>,<null>,<null>,srinivas.talasu@tcs.com,,,,2021-11-26,srinivas.talasu@tcs.com,2021-11-26,<null>}] Recommended Action:  Examine the activity class to correct the error and then resume. I am getting this error when I add details and storing it in data store. Can anyone help me to identify activity class

I have a grid that has been populated by a map in a local variable and I would like to export that data to an excel file. The data isn't in a record, so I can't set showExportButton to true. It isn't in a datastore entity, so I can't use exportDataStoreEntityToExcel, and it isn't a process report so exportProcessReportToExcel is out. Is there any other way to export this grid's data (or I suppose just the local variable itself)? 

Hello, I am trying to create one editable grid interface which fetches data from appian cloud database (employee) and populate the grid. This grid have should allow to update and delete options. I created the record action for update and delete button click but they are not working. Please share me some sample code.

Hi, I'm surprised to have to ask this question, but could you tell me how to access the value of a CDT field giving a number please ? I would need to use this kind of code : local!value: field(local!vehicle, 1) /* where "1" is the first field of the row */ a!localVariables( local!vehicle: rule!CJT2_GetVehiclesWithFilters( id: 1 ).data[1], /* Here I just display some data with fieldname */ property(local!vehicle, "id") & " - " & property(local!vehicle, "model") /* Now I would need to do the same thing, without using the fieldname, so I need a function that can do that I just tried to use the "property" function as an example but maybe is there any other function like "field" or other ? */ property(local!vehicle, 1) & " - " & property(local!vehicle, 2) field(local!vehicle, 1) & " - " & field(local!vehicle, 2) ) Regards

Hi all, A question about the difference in layout on record lists. We have a Sites page based on a Record List. In this Record we have multiple Record List Actions. However, having one action differs a lot to having more than one. Screenshot #1 - With one action Screenshot #2 - With two actions Is it possible to have two blue icons like in screenshot #1 next to eachother and above the filters while keeping the type Record List on the Sites page. Thanks in advance. Ranno

dear all, I have a record that it used to work.  Now appears the following error.   How Can it be solved ? Could be this related ?

So I've got an API integration that returns data in a single string field and I'd like to extract sections of the data to put into separate CDT fields. So the string that's returned will look something like this: "Advil 20 MG/ML Oral Suspension". I'd like to retrieve the data before the number, then everything after including the number. I've posted what I have so far below. What I'm wondering is how do I get the index of the first character that's a number? If I get that, then I can figure out the rest. Thanks! a!forEach( items: rule!NLH_GetPrescriptionDrugs(searchTerm: ri!search).result.body.drugGroup.conceptGroup.conceptProperties, expression: a!forEach( items: fv!item, expression: 'type!{urn:com:appian:types:NLH}NLH_Prescription'( rxcui: fv!item.rxcui, medication: fv!item.synonym ) ) )

How to filter records using time (like created time) .? In the same way we filter for dates like using date range, Can we create a filter for time range?

Hi,  I have a use case where while updating an already created Form, I want to limit the user to only update a particular attribute / field in the form where the rest shows as "Read-Only" For example, in the above case, I want to give an access to only update the Ownership % for particular users, and rest fields be "read-only".

Hello, Why forms are not submitted in my record views? I've made an example with a simple interface :  a!localVariables( local!tfiValue:"", a!formLayout( label: "Form", contents: { a!sectionLayout( contents: { a!textField( label: "Text", labelPosition: "ABOVE", value: local!tfiValue, saveInto: { local!tfiValue }, refreshAfter: "UNFOCUS", validations: { if(local!tfiValue="test","not defined",null) }, validationGroup: "testGrp", required:true ) } ) }, buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", submit: true, style: "PRIMARY", validate: true, validationGroup: "testGrp" ) }, ) ) ) In the designer it works fine : if the field is empty, the submit tests the value and as it is required the warning appears  Validation is

was not able to select a field in record type in appian as it is greyout in configure fields tab

Record Grid refresh option is not refreshing 

Hi there, I have problem setting up the SQL sentence "SELECT .... IN " in query database smart service.  if I directly writing "SELECT .... IN ('1234','5678')"  in the SQL Statement, it will work. if I have create a process variable to be the string '1234','5678', then put the following sentence  SELECT .... IN (ac!str)       and assign the process variable to this ac!str, it will not work. I dont know what's the problem here, as I can't hard coded in the SQL sentence, the string need to be dynamic. Can anyone be able to help? regards, Lin

Hi, I am getting the above error when trying to access the product details. The process model is working fine.  This is my Asset Management Record. When I try to select a product, I get the error message. My CDTs and DB fields match. So what field is missing?

How many types of records are there in appian and differences between them? Please provide document link as well for reference .

Hello All, We have created a record type and some related actions. The related action is based on process model and process model is activity chained. When we configure this record actions using "DIALOG BOX" then after record action gets completed, The data inside summary view is not getting refreshed automatically. User has to refresh the page to get updated data. Does anyone has any idea as to why is this happening? Or is it something appians default behavior?

Hi All, I have a Record type configured in a Grid and the Grid i have configured some set of columns which are coming from the Record Type. The Export to excel button works in Tempo. However in the Grid when we configure the Export to Excel button It is throwing an error.  It says expression evaluation error at function if parameter 2 line 73 invalid symbol found comma. But when i validate the interface it is working fine. Can someone help me out.

It seems that CDTs created in Appian and/or created from database tables then modified in Appian cannot be used with Generate New Action wizard in Record Types. It also appears that we cannot use CDTs made from scratch in Appian with Generate New Action wizard in Record Types. What is the root cause here? It seems as soon as you touch CDT from within Appian editor you cannot use it for Generate New Action wizards anymore (the Replace with existing object feature is not available or not working). Please advise. Related: Generate new action assistant Appian Community

I recreated the Record Type for my project to troubleshoot an issue with some fields not displaying, and now I'm not getting this "Generate Interface" button to automatically configure a Summary view. Is there a dependency I need to clear for the Record Type to recognize that there is no interface?  

Hi!, i´m trying to use the new action assistant, but each time i use it it creates a new cdt for each action, and it doesn´t allows me to choose my cdt. It´s rare because now you can create a record from a cdt, and then auto create a form to add record ¿but with another cdt?

I'm trying to review data offline for a scenario if user was to go to a location without internet connection but still wants to be able to review his data. Can I populate a grid field with the data from a record type that has data synced or do I no longer have access since I'm offline? In documentation it mentions to load everything onto a local variable and access the data from the variable. But by doing this I'm having trouble making user filters when using the local variable instead of the record type.

Currently getting the error below Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 29]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Team Lead"] has encountered an error. Expression evaluation error at function 'user' [line 29]: Null argument not allowedany ideas on how to solve this issue

what happen with CDT if we add extra column with database table?

How to have Record Level Security for my Appian Application where it restrict some users from editing a Record via a Site URL.

I couldn't get my DataStore to to republish a DataType association that's been around for a year. Finally, I created a new DataType from the same view and compared the downloaded xsd's Old one: <xsd:appinfo source="appian.jpa">@Column(name="isMultiplePlan", columnDefinition="TINYINT")</xsd:appinfo> New one:<xsd:appinfo source="appian.jpa">@Column(name="isMultiplePlan", columnDefinition="BIT")</xsd:appinfo> The view hasn't changed. It's still a TINYINT(1). Is BIT new with the MariaDB version? Thanks, Colin