Records

First, please let me know if the following is correct regarding transaction control when using the Write to Multiple Data Store Entities Smart Service. If the same entity is accessed by multiple users at the same time, the update executed later will always take effect. I know that procedures can be used as a method to access tables (entities), but do you know if there is a possibility of inconsistency if a procedure and Multiple Data Store Entities have access to the same table (entity) at the same time. Is it an anti-pattern to also access by Write to Multiple Data Store Entities for a table accessed by a procedure? This is a question.

Is it possible to perform multiple inserts or updates in the Query Database? I understand that the method using recordTyoe and relation is recommended by Appian, but I am asking this question to achieve exclusive control of updates to multiple tables. I know that this can be accomplished by a procedure, but I would like to know if QueryDatabase can be used as another technique.

Can Delete Records and Write Records be performed in the same transaction? I would like to do a rollback if either Delete or Register/Update fails.

Hi, My team is trying to create a chart that warns users when an app is used the most. As soon as the user execute a process, we insert in Database some information (timestamp, typology, current user, etc). To generate the chart we use the following code: a!lineChartField( data: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales', config: a!lineChartConfig( showIntervalsWithNoData: true, primaryGrouping: a!grouping( field: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales.fields.{88cbc07e-c205-4ccc-8c3f-9245ea2bfbf1}timeStamp', alias: "timeStamp_hour_primaryGrouping", interval: "HOUR_OF_DAY" ), measures: a!measure( function: "COUNT", field: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales.fields.{dbcf9179-1efb-4c26-aac4-bc7c25fbded7}id', alias: "id_count_measures", ) ) ) The problem is when we use "HOUR_OF_D

In related action , after submitting a form ,the form must gets closed and it must enter details in db  but after submitting the form it is not updating the details in db and the form is not getting closed can someone please with this

I want to access sql result data in Custom Output of Query Database Smart Service, but I get an error. I would like to access the ResultSets, like in the Execute Stored Procedure Smart Service if possible, can I achieve the same operation in the Query Database?

I am using expression to configure a user filter for my record. The expected result for the choices is more than 5000 but the record batch size has a max limit of 5000.  Is there a workaround?

Hi All, We are using a queryentity to retrieve the data from DB View. While retrieving the data we are seeing below intermittent issue. Our query rule is too long, I have attached that. Any suggestions to optimize this rule.   at function a!queryenti[View:/cfs-file/__key/communityserver-discussions-components-files/16/Query_5F00_Code.txt:320:240]ty an error occured while retreiving the data. Details: unexpected error executing query  Thanks

How can I export the data from read only grid (on an interface) with and without any filter, not from any CDT or record type? Need to get only these fields in exported file.

The data store "ISR Data Store" [id=163216, uuid=_a-0000e3b5-3910-8000-9ba5-011c48011c48_35304] will be saved, but will not be published: The data source schema does not match the type mappings: APNX-2-4056-000{Schema-validation: missing column [fundingSource] in table [`ISR_StudyMedicalReview`]} (APNX-2-4053-006 Here:ISR Data store in Data store object,  fundingSource is new column, ISR_StudyMedicalReview is CDT. When I tried to move to another environment during inspection I am getting this error .How can I solve this? Thanks

What are procedures in data base

I have modified the CDT by adding one columns in one environment by XSD .Now I am trying to deploy that CDT object to other environment.Can I directly deploy that CDT object to other environment.or do I need to do anything in the Target environment before deploying.CAn you please suggest me steps to deploy CDT

does it automatically update in all places where it has been used?

Hi Team , We are getting intermittent connection issues while  using a expression rule, which retrieves data from DB source . Please find below logs for your reference .  Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: The data store entity does not exist, has been deleted, or you do not have sufficient privileges to access its data. (APNX-1-4261-001) at com.appiancorp.expr.server.fn.query.QueryEntity.getDataStore(QueryEntity.java:253) at com.appiancorp.expr.server.fn.query.QueryEntity.queryentity_appian_internal(QueryEntity.java:155) at com.appiancorp.expr.server.fn.query.QueryEntity.executeQuery(QueryEntity.java:115) at com.appiancorp.expr.server.fn.query.QueryEntity.executeQuery(QueryEntity.java:99) at com.appiancorp.expr.server.fn.query.AbstractQueryExecutor.op(AbstractQueryExecutor.java:66) at com.appiancorp.core.expr.fn.Signature.eval(Signature.java:182) at com.appiancorp.core.expr

We are using data-sync records and allowing Appian to automatically generate the tables. We ran into an issue where the maximum row length of 65535 bytes is being reached in MariaDB so we are unable to add any more columns. The issue here is that Appian defaults text fields to varchar 255 and "long text" to 4000. Therefore, if you have 16 long texts in a record type, you're already at the row limit. Further, there is no way to change the text length in the Record Type Designer. Changing a field length on the DB side require us to go back into the Record Type Designer and re-map the field since the data type has changed. Consequently, we need to also remap all references to the record field, which is a tedious task.  1. Will Appian enable an easier way to change text lengths in Record Type designer without needing to run a SQL script, remap the field, and repoint all field references?  2. Does Data Sync support the TEXT data type instead of VARCHAR? I believe TEX

When creating a service backed record having more around more than 10,000 records, there is a error. How to resolve that error? Should I go for disable sync options and then create.

I am using the export button in a record grid field. However, when the Excel file is downloaded, some of the fields have long URL links in parentheses next to them. I am not sure how to get rid of the URL links. I think this is because one of the links is a a!recordLink() component and another link is created through a personalized expression rule. Wanted to see if anyone else had insight about this on getting the link to show as normal rather than a super long URL. I have provided a screenshot of what the Excel file looks like below. 

Hi I have a form on record type page the data when I submit the form is not updating after I submit the form?

i

https://docs.appian.com/suite/help/23.1/Delete_from_Data_Store_Entities_Smart_Service.html#:~:text=The%20Delete%20from%20Data%20Store%20Entities%20Smart%20Service%20lets%20you,node%20input%20of%20type%20EntityDataIdentifiers. Hello, we using Delete From Data Store Entities smart service to delete a nested entities up to 2 levels with cascade All option Data seems to be deleted fine from main entity as well as nested entities , but record types seems to be not synced. If I use queryRecord - I'm still seeing deleted data from cascaded record , but if I use query dataStore entity deleted record not returning as expected . Appian documentation says automatic sync is supported on on nested CDT's until 1000 rows, my tables  have less than 1000 rows in total - any thoughts ?  ..

Hello everyone! I had created a record type who gets data from a process model. Inside that I want the date to be shown as feed-style record list. But with the last updated Appian version, the  =a!list does not work anymore.  It does not work when I call the record rf!record, also does not work when I call the record  rv!record as the documentation suggested. The only way that I can manage is to query data with a!queryRecordType.  Since I query data into an expression first, there it shows correctly: 21 different items. Meanwhile the record who use the same expression, shows only the first item, 21 times.  Any suggestions how to fix it? Or does exist another way to create a!listViewItem in the latest Appian Version? Thanks in advance

Hi Champs, I have a requirement where in portal, I have to fetch user details from IDP and show it in a dropdown or in a autocomplete list? I have two questions here? 1) How to fetch data from a IDP ? will it be a API call ? If Yes how to do that 2) Will portal support this use case? Regards, Ghanashyam

Hi After doing changes in CDT for newly created requests it will work fine and process will fetch the updated details but for inflight ones it will be still old CDT is there any way to get the updated cdt to inflight instances

Hi All We have a requirement to read the file clasification i.e. internal,public,confidential etc. We are usng readofficedoccustomprops function & tried with multiple functions & smart services. But did not find the function/smart service for it to get clasfucation for all file types ( docx,pdf,excel,csv,ppt).using readofficedoccustomprops function & MS Office Read Custom Metadata plugin , we could able to get the Classification for external type files but when trying with clasification as internal /confidential it is giving error with file metadata. Can any one faced similar issue to read metadata of all type of files .Please share with us.

I want to the same result as this SQL query "SELECT WorkType, COUNT(DISTINCT Site) AS DistinctSites FROM your_table_name GROUP BY WorkType;" in using query on data entity. I am able to get the count of sites and Group by WorkType but count of sites is not distinct.a!queryEntity( entity: cons!SD_TEST_DATA, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "worktype", isGrouping: true ), a!queryAggregationColumn( field: "site", alias: "site_count", aggregationFunction: "COUNT" ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: false )