Records

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.  

I have a table X which does not have a primary key. the format of data is something like this, Indentifier for Request Emails [non Unique] Column A ABC123 useremail@email.com A ABC123 useremail@email.com V XYZ582 User2@email.com D I have to create a record to view this data. Notes: there is no primary key to this table. Indentifier column is currently marked as primary key in table. this table is not handled by Appian and is only referenced for data. the table has more than 800 thousand rows at one time on average. the custom plugin breaks if user tries to export all data at once. [Business req. on export from Appian] The record list breaks with following error: Expression evaluation error at function a!gridField [line 27]: A grid component [label=“”] has an invalid value for “totalCount”. “totalCount” must not be null or less than the number of items in any of the “data” arrays, but “totalCount” was XX and the

Hello everyone, I would like to solve this issue I recently have had when trying to set a default filter within a record type. The problem is basically that I can't set this filter by the owner (List of strings) field when it includes the loggedInUser(). I'm setting the filter exactly as I described before and it doesn't solve the mentioned problem, it keeps throwing the error over and over no matter even what operator I use (have tried with IN, = as well). I would thank to anyone who can give me and suggestion to solve this problem. Note: I already know it has something to do with relational database relationship which creates a new table when setting a List of Strings as a child value in a parent table and within this new table it storage a reference to the father table. It seems like a!queryFilter() (which is the used function in these cases) doesn't make the usual map of hibernate to turn the Relational data to Object data and it gets i

There are files in our Appian folder that contain DOCX and HTML files types. I am able to download the DOCX documents from Appian but I can't download the HTML file types.