Data Fabric

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?

Hi, all! I just prepared my site to get data nd put It inside a ri! to send to a table at DB, i tested at model process and just worked good, but when I try to do on the site give the follow problem. Can someone help? I really need make it works.

Hi everyone,  I need to export the data contained in a Read Only grid with variable Data Source, therefore I cannot use the default Export functionality available for Record and entity based grids. My grid can have two sources of data, one being the default columns I have on the report on which it is based and/or one or more columns that users can select with a UI we made. The grid then can have a mix of Report and Database data source. I tried the exportProcessReportToExcel function, but it only works with the data and columns set on the report. I'm looking for a way to export to Excel the whole content of the grid, whether it is an OTB function or a plugin. Thank you very much in advance. 

Hi Team, I was facing some issue while querying and performing larger data such as approx 1M+ data at a time. Considered I'm querying data from approx 5 table using some filter to reduce some search results and storing in seperate variable with the help of index() function. Even I'm having more data and I'm performing approximate n time (rare case n^2 times) as looping so Appian expression rule was failing shows as one pop up with please try later in the code such approx 502, 504. Is there any limit in Appian hold particular level of data or no such limit? Anyone has any idea is there any better way to handle this larger case of data... Thanks and Regards, Vigneshkumar Radhakrishnan

Hi All, I am creating Process Models, Process Metrics, Task Metrics Reports in the Appian. and then I am fetchiing the data from the report in the process models and using it. My query is what is the data retention period of those reports in Appian. Like how old data it could have and how can we configure this. ? and is it something manages by the APPIAN DB itself or managed by the organisation. if by the organisation than where we can find that configuraiton.. Thanks

Hi, After every user input task completed i have called write to data store entity to insert data to table so over all in main process i have called three times so after every user input task a new row creating the values is not getting updated but after every user interaction a new row is getting inserted. i have updated the details correctly like below in input and also in output tab i stored the ac values to cdt. kindly suggest me on this and autoincrement i have given to Id column in cdt Query:

when we apply multi-select dropdown .. comma separated value is getting store in table in single row ..but i how to put in different rows. Output i am getting  Field Field Value Dropdown 1,2,3,4 Expected  Field Field Value Dropdown 1 Dropdown 2 Dropdown 3 Dropdown 4

Hi All, I am new to Appian, during one of my solution development I have found that I have deleted the rows from the oracle table and when I am trying to test the expression rule where I used Query Generator to get the data from that table , it's stil returning the old data. So can you please help me to know that how can I clear some cache or sync it with my tables ? I am using query generator to generate that expression rule.

I am working on "Interfaces 103" in the lowcode4all curriculum. I made a mistake and deleted the PF_Goals Record Actions - Delete Goals and Update Goals. Now I am unable to generate any record actions. Please advise me on what to do next in order to continue building the interface.

Hi Is there a way to sync all records within an application? Thanks

Home Page displayed with following error message  An Error Has OccurredCould not find "store" in either the context or props of "Connect(XrayConnectedComponent(Pure(Interactive(XrayComponentSelectionManager))))". Either wrap the root component in a <Provider>, or explicitly pass "store" as a prop to "Connect(XrayConnectedComponent(Pure(Interactive(XrayComponentSelectionManager))))". Expected:Application Should free from expression errors

I'm updating my database table using the "Write to Data Store Entity" I have an array of uploadId's that are my primary key. When writing to the DSE, I'm passing additional information like the current time now() and some other text values.  In the error (see image below) you can clearly see that the first uploadId (10473) is passed with the additional information. However on the 2nd iteration (uploadId 10474) all of the additional values are null. How do I pass multiple values using this smart service?   Thanks!