Records

Hi, I want to implement  a functionality, wherein I am displaying a button, and on click of that buttton, I am letting user to download a file containing data from the database. I am using exportDataStoreEntityToCsv() smart service to achieve this. But it is a 2 step process, and I am not quite sure how to integrate the download functionality in the button.  Can anyone help me in this ?

Hii,   I have created a read only gird and added my record. So, now I would like to use record action for multiple rows at a same time. Eg. I my grid for now I could able to approve only one row at a time , but now I need to approve them Bulk.

I would like to rename the source field name for a field in one of my record types ('source field name' is the field in the database table, holding the record type). In the record type, screen Data Model > Configure Fields, I am allowed to change the record field name (the field name visible in Appian), but the source field name is readonly! In this particular case, I would like to change "workzonecaseid" to "WORKZONE_SAGS_NR": Here's the current situation in MariaDB:

I want to create a date filter with the following options. 1. This month 2. Previous month 3. This Year 4. previous Year.

Hi Gurus, The Appian documentation (https://docs.appian.com/suite/help/22.4/record-type-relationships.html )states: If you use a process model to delete a Customer from the database table, any Orders referencing that Customer would have an invalid foreign key. Therefore, the database will either cause the delete operation to fail and nothing will be deleted, or it will delete both the Customer and all Orders associated with that Customer. If the delete operation fails, no sync is needed because data has not changed. If it succeeds, Appian will immediately sync the deletions from both record types. We defined a one to many relationship in the record type and a cascading delete in the database (mariadb) however data in the Orders table is not synced, do I miss something here? Btw not having a cascading delete in the database leaves the Orders records orphaned. Any ideas?

I am creating a Summery View based on a record with multiple one to one relationships that I want to use to display data in the view as well. However, I can't get the data to show up in the view by just referencing the relationship (although the relationships, and their associated fields, do show up as options when selecting the record field to be used). I can use a!queryRecordType to successfully access the data, but I don't want to have to make a query for each relationship if I can avoid it, since there are about 24 relationships and that would probably have an impact on the performance. I have created a local variable that just tries to call data from a relationship, but all it returns is null. When I change it to call data from the source record it work perfectly. I have also verified that there is data in the row being called, and the relationship works properly when used in the record type (shown in the second image). Below is the local variable that is mentioned above,

Hi Team,When I am trying to edit record type > Edit Record List>Image Columns.Below steps:the Image column by following the steps below: ● Under Columns, click Image. ● Under Display Value, click Display Options. ● Select Document Image. ●Under Display Value, click Image. ● Under Images, click Document Image. ● Under Document, click a!EXAMPLE_DOCUMENT_IMAGE(), and clear everything in the Expression Editor. ● Enter the expression: if(isnull(fv!row[recordType!AX Vehicle.fields.vehicleImage]), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row[recordType!AX Vehicle.fields.vehicleImage]) Getting below error: Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 55]: Invalid Content IDDue to this error record type is not loading, if i am not adding image column

I'm  trying to store array of files in database since it does not picks blob as a datatype any work around would be much appreciated.

Dear Team, We have a column in DB say file_number which have text values example 1;12 , 12;32 We are trying to query records where file_number is "1" using includes operator. With includes in query it is getting all the records which have 1 (1,12,13). We want the search to match exact to 1 only . Any suggestion ? One suggestion we have is to add a character when writing in DB like @1@;@12@ , and when searching pass @1@.

Dear Appian Community Team, I am having at a Record's Data Modal using data sync to the SQL database table. I would like to check with the team whether anyone knows whether we can map a Unique Column which is perceived as VARBINARY(16) on Appian Data Modal to ensure data sync successfully when the source code for the SQL is as below. "ABCD" RAW(16) DEFAULT SYS_GUID() NOT NULL ENABLE, In terms of the error: 

Hi all, I am trying to create a user filter wherein the option labels will come dynamically from an expression rule. I am not quite sure how to achieve this. Does anyone know how to do this ? 

I have a column in the record type of DATE type.How do I create "no of records day of the weak" column chart?

As an example, in Javascript I can do this:var test = {a:1,b:2} test.a = 'changed' console.log(test)and it will output this:{a:"changed",b:2}Because I mutated the value in key 'a' of the test variable.How do I do this in an appian expression?Trying this:a!localVariables( local!test: {a:1,b:2}, local!test["a"]: "changed", local!test ) Gives me this error:Expression evaluation error at function 'localvariables': A variable is incorrectly defined. Parameter: 2. Expected syntax: localvariables(local!a, ..., expr) or localvariables(local!a:10, ..., expr) So it seems you can't changed a key of a variable in an expression. Is there another way to do this? It seems like such an elementary operation...

I have a column in the record type of DATE type.How do I create "no of records per month" column chart?

Hi there, is there please any function which will return the last letter from a text string. For example if: local!invoice='FY20221227" then the function will return 7. Thanks

Hi Team, I am working on the history table of my Appian application. I created a new table in the database having a similar column of my application in addition of 3 new columns modifyby, modifyat, and operation(create/update/delete). I created a corresponding record type/data type as well. The entity mapping on the Datastore is also successfully done. Now while I am updating my code on create/update/delete interface to fetch the action history of my app, I am getting errors. This is the code:- buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", saveInto: { a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{b5d840ba-2408-425d-b829-510414356ac2}serialnumber']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{d7f705b2-c020-47c9-95c4-cbe0e6df18a2}addedby']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-94

Hi,   I want to filter a record by its data types. Which type of filter I need to add on my records Type?.

Hi Everyone We're trying to write multiple records using write to record smart service on interface. But we're receiving below error -- The input "Records" must only include records from a single record type. can anyone please let me know what is wrong with the below code? a!writeRecords( records: { ri!taskDetails, ri!caseDetails }, onSuccess: a!save(ri!teadOnly, false()), onError: a!save(local!error, fv!error) )

Can we pass data of CDT type into a database table using Execute stored procedure smart service just like how it is done using Write to datastore entity smart service? Or else do we have to pass each and every data of cdt as a separate parameter using Execute stored procedure smart service? Thanks in advance.

Hi,Can anyone tell the difference between Write to Data Store Entity Smart Service and a!writeToDataStoreEntity() function?? I am asking in the context of place of usage. As best practices, what are the specific places we can use the above mentioned? And is there a way to catch the error occuring while writing to DB using Write to Data store entity smart service???Thanks in advance

Hi all! For my application, I need to acquire the data type and length (and the number of decimals in case of a float) of all the fields from a single Record Type (and preferably the source fields as well). Now, as far as my knowledge goes there is no out-of-the-box solution for doing this. For acquiring the data types of a Record Type I have made the following solution:  /*Partly based on the solution provided in https://community.appian.com/discussions/f/general/23723/map-with-variable-key */ if( rule!isVoid(ri!record), /*use your void check expression here */ {}, a!localVariables( local!xml: toxml(ri!record), local!json: a!fromJson(a!toJson(ri!record)), local!keys: a!keys(local!json), local!types: extract( local!xml, cons!XML_FIND_TYPE_START_DELIMITER, cons!XML_FIND_TYPE_END_DELIMITER ), cast( typeof(a!map()), reduce( a!update, local!json, merge(local!keys, local!types) ) ) ) )

I've got a dictionary of values and I would like to either loop through it for a grid, or convert it to something I can loop through. How might I do that?  For example, I've got this dictionary: {A: 3.1, B: 2.2, C: 1.3} I'd like to have a table that is something like Name for the first column containing A, B, C and Value for the second column with the various numbers in there. I'd like to also record a similar in thing in the database. How can I do that? 

Hey Appian Community Team, I am currently trying to map v22.3 relationship properly to an outer join that is SQL based query which is a view itself. Fundamentally im talking about inner and outer join to map for e.g. PID to REF PID. I was thinking of source filter but it will probably face limitations as well. An extract of the code is listed below (SELECT A.REF_PROPOSAL_ID, LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CODE END, ', ') WITHIN GROUP (ORDER BY CATG.CODE) CATEGORY_CODE, LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CATEGORY END, ', ') WITHIN GROUP (ORDER BY CATG.CATEGORY) CATEGORY FROM ABC_PROPOSAL_CATEGORIES A INNER JOIN ABC_PROPOSALS P ON A.PID = A.REF_PROPOSAL_ID INNER JOIN ABC_CATEGORIES CATG ON B.PID = A.REF_CATEGORY_ID GROUP BY A.REF_PROPOSAL_ID ) B,

He everyone! So, I've created a ER to fetch data from database, using a stored procedure. However, it seems being limited by 1000 record by search. Is it possible to change this config. If so, anyone can tell how should I procced ? One option it to dismember the search and do it little by little, until fetch all data requested, but I rather to try something more easy and smart.

Hi, I have a situation where there is a need to identify the duplicate entries in a database table and delete the duplicate rows. How can I do this?