Data Fabric

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?

How to apply Aggregation (grouping) based on condition as like Group by on condition in Mysql? Example: SELECT * FROM `TABLE` GROUP BY ( CASE WHEN `NAME` = 'AA' THEN `COLUMN1` ELSE `COLUMN2` END );

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 )

I want to generate a Column Chart from Expression rule which contains query aggregation on two columns , How can I generate a Column Chart for this. Below is the code of my Expression Rule index( a!queryEntity( entity: cons!MBUA_DSE_TESTSITEDATA, query: a!query( aggregation: a!queryAggregation( { a!queryAggregationColumn(field: "site", isGrouping: true()), a!queryAggregationColumn(field: "worktype", isGrouping: true()), } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: false ), "data", null() ) Below is the code on Interface having Column Chart: a!localVariables( local!myData: rule!MBUA_readChartView(), { a!columnChartField( label: "Column Chart", categories: { "Category 1", "Category 2" }, series: a!forEach( items: local!myData, expression: a!chartSeries(label: "Chart", data: fv!item.worktype) ), stacking: "NONE", show

Hello, I'm trying to figure out how we can set up alerts based on the metrics in our Health Cloud Metrics reports. For example, we're able to see the CPU Utilization metrics to the servers that are hosted in Appian. How can we set up an alarm/notification to alert my team when it hits a 90% threshold?

a!recordFilterList( name: "Employee Name", options: a!forEach( items: local!data, expression: a!recordFilterListOption( id: fv!index, name: rule!CMN_PLATTS_GetUserFullName(fv!item.employeeName), filter: a!queryFilter( field: 'recordType!{c3db295c-a167-41fc-84b6-90d578db6968}Employee.fields.{employeeName}employeeName', operator: "=", value: fv!item.employeeName ) ) ), allowMultipleSelections: true() )

The main question is about how Appian cache the data when you relate a record type to database tables. Also does this cache mechanism provided when you relate a record type to database views. 

Hi Guys Is it possible to run mulitple instances of Write Records smart service as a single transaction, i.e. if one of the instances fails, all updates made by previous instances are rolled back? According to docs, Records can only be updated for one record type at a time (https://docs.appian.com/suite/help/23.1/Write_Records_Smart_Service.html) So say I have a record type representing a bank account. And I have a process model to transfer money from one account to another. The high-level steps are: 1) Update balance of account 1 (deduct the amount) 2) Update balance of account 2 (add the amount) If step 2 fails, account 1 will be charged, but nothing will be added to account 2. If there is no option to run the 2 actions as a transaction, what is the best practice for handling such cases?