Records

Hi, I'm trying to save into a local variable some data retrieved from an ER. But I would need to update some fields before to store it into my new local var. Is there any way to do it ? With the code below I can either cast the data, either create a new CDT local var with the new field value, but I did not succeed to do both.  (as my CDT could contain more than 50 fields I do not want to override all theses 50 fields in the code below). a!localVariables( local!vehicle: rule!TST_GetVehiclesWithFilters( id: 1 ).data, local!vehicleCast: cast('type!{urn:com:appian:types:tst}TST_Vehicles', local!vehicle), local!vehicleUpdate: 'type!{urn:com:appian:types:tst}TST_Vehicles'( make: "New Make" ), { local!vehicleCast, local!vehicleUpdate } ) Example : my initial data retreived by the ER is : TST_Vehicles : id : 1 make : "make1" model : "model1" ... ... ... is_active : true and I wo

I am looking for a way to create a range in a record filter. I want to be able to enter in a minimum and maximum value to query by, but that does not seem to be allowed as the options for a filter are only =, <>, or between. Is this a possibility, and if not, do you have any intention to update this in a later release?

I'm talking about something like a user picker search. Is that possible? I see you can have dropdowns but those are not user friendly when you have a lot of data. 

I want to delete record using process modeler how I can do delete operation?

How I can Update database record and show it in record

Hi, I want to update the record .Here I have written the expression for fetching  the data and it is working fine but now I want to update the status with help of Interface(means what ever user enter the value in status ,the status should be update).What changes should I do here . a!queryEntity( entity: cons!LA_ManagerStatusCons, query: a!query( selection: a!querySelection(columns: { a!queryColumn( field: "EmployeeName"), a!queryColumn( field: "Status"), }), filter: a!queryFilter( field: "Status", operator:"=", value:ri!Status ), pagingInfo: a!pagingInfo(1,5) )).data Thanks

Hi, My query is to write multiple data rows (array from the process) in the DB at one go, I have tried this with write to multiple data store, however, it is still overwriting all the rows and only the last value is present. Can any one help me on how to do this? Thanks in advance.

Hi experts, Request suggestions on the below scenario. Need to implement an user filter on a record type object, with logic including multiple columns of the table being queried. userFilter condition : column1 = value1 AND column2=(value2 OR value3) Presently using a!recordFilterList. Thanks

Team, I have a grid of 7 columns and which have data coming from one view (5 columns) and two columns in data coming from another view . It is causing a sorting issue in GRID because of multiple data set. All columns are part of only one cdt , is there a way i can club it on runtime and resolve sorting issue ? CDT : (FirstName,Lastname,email,created,username,count,active) view 1 - (FirstName,Lastname,email,created,username) View 2 - (count,active)

Team, I have an array of results from query and want to use the rows which have latest timestamp. So array have data like (username :abc,id,1,timestamp1) , same user have another entry but with different timestamp. Max is not doing the trick , any idea ?

Hi, I have a record type configured to sync data sourced by a web service with a scheduled sync that runs once a day. Everything works seamlessly as long as the webservice returns data as expected. IF in case the daily sync fails for some reason (for example: a connection timeout when calling the webservice) then all the record data is removed from Appian causing errors in the rules and interfaces that use this record type. Ideally, I would expect Appian sync to fail BUT retain the last synced data instead of cleaning it up and causing the record type to be inaccessible. Is there a way to work around this issue other than by writing additional logic in the record source expression to backup data before calling the integration and then restore if something goes wrong? Would love to hear your suggestions/ideas. Regards, Sunil Zacharia

I was trying to add one field to my existing CDT and as soon I add I am getting the following error message. HTTP Code: 500APNX-1-4198-000 Error Evaluating UI ExpressionExpression evaluation error [evaluation ID = 7UYV2XAP] : [valid:false,syntaxError:false,value:Expression evaluation error: An error occurred while executing a save: Expression evaluation error at function fn!objectReadAction_appian_internal [line 8]: blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];]

Hi, So I'm trying to implement the following simple domain model as part of a proof-of-concept. The NM_Nomenclature, NM_NomenclatureKind and NM_ValidityPeriod CDT's have been created as visualized in the domain model as can be seen below, id fields have been added as primary keys. When adding the MostRecentValidityPeriod relationship to the NM_Nomenclature CDT as follows. This generates a warning message stating that: "Multiple levels of nested data types detected. Consider creating a flat data type relationship instead to avoid nesting data types more than one level deep. Multiple levels of nested data types can complicate data access at child levels and reduce query performance." This particular design choice is made as a denormalization because I expect frequent access to the relationship MostRecentValidityPeriod and this allows for a one-to-one access relationship to the most recent validity period without having to consider/fi

Hello,I have a requirement that the support team can insert new rows into the table(Using SQL insert statement) as part of application support. After that end users can modify the newly inserted row values from the application.Somehow write-to-datastore-entity(both smart service & smart function) is inserting again a new row instead of updating the current row. This is happening when users are trying to update the values for the newly inserted row through SQL insert statement only. I have tried by setting the valueToStore as rule!getdetailsById(ID:1234).data. No luck, still it is inserting a new row.Appian V19.3 on-premise Database: MS SQL server  Thanks. 

Hi All, Could someone help me on the below? I want to export a read only Grid Data in an excel when the source is not a record type but a Query Entity? Thanks Faisal

Is there a best practice with regards to finding an exact match from a delimited list inside a MySQL table column using a query rule? Assume that standard, better solutions are out of scope - i.e. mapping tables to avoid the delimited lists inside columns, or using multiple rows for each ID and account number. Example: Clients Table ID Account Numbers 1 12345, 123456 2 123456, ABCDEF Query for 1234 should return no results (exact match desired). Query for 123456 should return 1,2. Query for 12345 should return 1, but not 2. ("includes" in Appian would return 1,2) My current solution is using MD5, but wondering if there is a better method. ID Account Numbers Account Numbers MD5 1 12345, 123456 827CCB0EEA8A706C4C34A16891F84E7B, E10ADC3949BA59ABBE56E057F20F883E 2 123456, ABCDEF E10ADC3949BA59ABBE56E057F20F883E, 8827A41122A5028B9808C7BF84B9FCF6 Query using "includes" and MD5(parameter) correctly returns expected results. i.e. A user inputs &q

Hi, we have a record of type entity backed .when we export 5000 records to excel, it displays error in the downloaded excel as "Query has failed: An error occurred while retrieving the data".  Please suggest Thanks in advance

Hello, I am trying to build the process backed record but When I am configuring the data for the record and after selecting the Process clicking on the next button getting the following error. Error Evaluating UI Expression Expression evaluation error [evaluation ID = Q5L1EJAM] : A columns browser component [label=“processModelBrowser”] has an invalid value for “nodeConfigs” when fv!nodeValue is [id:[Process Model:25769],uuid:0002e46d-b6e0-8000-fc63-7f0000014e7a,typeId:23,name:]. “nodeConfigs” must not have a null value for “label”. Thanks in advance. 

Hi I am facing issue while entering the new record .When I enter the new record  ,previously record is deleted from table. So what should I do?

When the record link is clicked the database should also be updated. Is there any way to achieve this functionality?

Hello, We have dumped data from PROD Database to UAT Database , even after successful dump we cant see the data in Application where as in UAT database it is present. Can you suggest us what exactly to do Thanks in Advance

hi community, i have a requirement like i need to send a meeting form that is been assigned to a set of groups and there should be a related action that can add or delete groups within that meeting form for  selecting groups i have used a group picker and stored that selected values as ids within a cdt attendees with meeting id as primary key and i have got this groupids using this meetingid and stored into a  local variable by converting that groupids to groups in related action form but i when i remove a group that is already existing it is geeting removed here in the form but it is showing within the record  can anyone explain how can i solve this problem this is the code related to related action from and ri!attendees store groupisds related to a meetingid and ri!meetinginfo stored meetinginfo a!localVariables(local!groups:a!forEach( ri!attendees, togroup(fv!item.groupid)), a!formLayout(label:"Update Meeting Information",contents: {a!columnsLayout(column

I have in the CDT a field of text box within a specific size. I'm writing an expression rule that I would like to get the size of the specific field in my CDT. For example , I've field named "Notes" ,type "VARCHAR(100)"  , so in my expression rule I would like to get the integer 100 . There is a way to do so?

Hi, When I have to add data within a 1-1 relation between 2 tables, I call the "Write to data store entity" Smart Service to add the new record in the parent table and then, from this component output, I retrieve the generated key Id, to set the Foreign Key in the child table. How would you do for a 1-N relation? Is there any way to add the data in the 2 tables (1 record in the parent table, and N records in the child table) in a simple way without doing any loop to set the FK ?  What is the better way to do it please ?

Hi all, I am getting below error when i call executestoredprocedure smart service , when I manually opened the process in monitoring mode and restarts the node, it is working. Kindly let me know the possible reasons and solution. Thanks in advance.