Data Fabric

Hello. I have multiple Reports that are Task Report Types by process model. While the report itself returns data, a!queryProcessAnalytics() returns no value for data. I'm not sure how to make or update the connection. Thanks.

Hi, I have a grid, where in a dynamic link will be there. If i click on the link, the selected row should be passed as parameter to another process model. In the 1st process model, i have added process variables. if i click the link in grid, nothing is happening.  how to achieve this?

I have a dropdown component and a record-based read-only grid on the interface. My requirement is to refresh the user filter value based on the dropdown values.   I am using Appian 20.4 version

Hi! I have the FAQ record type that has a related record type Answer. https://www.screencast.com/t/YBLj0uEs When trying to update an existing FAQ, have this in the context expression https://www.screencast.com/t/xV2KlFZU52Y but nothing is getting attached in the Answer field in the interface. https://www.screencast.com/t/xi5hw978bsK When testing the answer parameter part separately, i get this result with Text field present and correct, but can't figure out how to attach it to the interface form for editing a FAQ https://www.screencast.com/t/YMzR0SFxNi New to using record types and, especially, their relationships. Hope to get some guidance! Thanks!

a!localVariables( /* Query the parent */ local!Employee: a!queryEntity( entity: cons!TOC_EmployeeEntity, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "Employeeid"), a!queryColumn(field: "Departmentid"), } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), ).data, /* Query the many-to-one child */ local!Department: a!queryEntity( entity: cons!TOC_DepartmentEntity, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "Departmentname"), a!queryColumn(field: "Departmentid"), } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), ).data, a!gridLayout( label: "EmployeeDetails", /*instructions: "Seleccionados: " & local!selected & local!selectedItems,*/ headerCells: { a!gr

Hi team, I am unable to write the data in data store entity. Data is getting stored in process variable but when I am trying to store the same process vaiable data into appian db, only auto-generated key value and a new row is getting stored and not the whole data which I am trying to store. Please help me in this regard. Below is the process model- For fetch data from API, I have the following configurations as shown in the screenshots below- I am getting the data as list of texts as you can see in the above screenshot. I have created a CDT from the table. Table and CDT structure can be seen below-    I have created a process variable which can be shown in below screenshot- Below are the screenshots showing the Write To Data Store Entity node configuration   Now after running the process, the value in the process variable is not getting saved and not in table too. However in the table, blank rows are getting added with a auto generated incremental i

I have created a view by joining two tables in my database. I have added the view into the appian datastore,  when i click on save and publish, im getting the below error.

i have configured custom record field in the vehicle record,  but unable to see the same in record list view

Hi Everyone, I am new to Appian and development in general, so, thank you for taking the time to help! In the Query Your Data Lesson 6_E1, we are asked to create a aggregate query in order to display vehicles by make.  I am able to display the results, however, the results in the drop down menu show the alias and also the entire results in brackets.  I am trying to have the drop down menu only display the vehicle makes. Expression Rule: At the beginning of the lesson in the solutions, it says that I am to use a local variable function and gives this as an example or maybe even as the solution: However, when I tried to wrap the previous code in the function and then index it through .data, I get an error.  So, then I just duplicated my previous expression rule and basically used this exact code and still get an error.  Can someone help me understand indexing everything after the .data and what I am missing?

Hi Everyone,  I've got a CDT that has an Id as a Primary Key and then a Numeric field that is a reference to a previous same-cdt entry id. Starting from an ID I need to back-track all the way to the first "father" entry. All should be done using Expression Rules.To give you an example I would like to start from contract ID:4 and backtrack all the way to ID 1 (that has no father id) I managed to achieve the backtracking with a process but I can't make it work with a reduce() or a forEach() function. Has someone found something like this in his history? Best regards, Luca.

We have a table with below fields we want the output with same firstName, lastName and phoneNumber with different city Table Result can we achieve this by a single DB query without writing any views/sps...

I have scenario as below - Country List Country Code Field Name France 1 Country_Field Germany 3 Country_Field USA 4 INTAKE_FIELD EUR 2 INTAKE_FIELD I have to populate a column in generated excel which must contain values after translation based on selected value of Field Name in mapping with Country List and Country Code. Output file must generate column like below - 1 4 13 27 89 5 7 8

Hello There, Could someone please let me know if there is any plugin which we can install to mariadb, which shows me queries Appian application is firing. We have received notification from database that there are lots of queries firing as cross join and it should be fixed by index. We have checked indexes and mostly indexes are in place. Therefore any tool or any help which help us fixing this issue would greatly be appreciated. Thanks

Hi, I am trying to save data in appian db which I am getting from an api call. API is : https://run.mocky.io/v3/ac936aeb-6ae5-46e1-ab38-b953ab3ac2a5 [Below is the body that I am getting after running API call in Appian] [{ "FXRateMicroservicesSuite1": [{ "FXR": [{ "FXRateGET": ["test step 1", "test step 2"], "link": "FXRateGET.com" }, { "FXRateMiscellaneous": ["test step 1", "test step 2"], "link": "FXRateMiscellaneous.com" }, { "FXRatePolicyServer": ["test step 1", "test step 2"], "link": "FXRatePolicyServer.com" }, { "FXRatePOST_DELETE": ["test step 1", "test step 2"], "link": "FXRatePOST_DELETE.com" } ] }, { "Script2": [{ "Test cases": ["test step 1", "test step 2"], "link": "Script2.com" }] } ] }, { "FXRateMicroservicesSuite2": [{ "FXR2": [{ "FXRateGET2": ["test step 1", "test step 2"], "link": "FXRateGET2.com" }, { "FX

After the data sync in Records the data is in cache to retrieve swiftly. Where can we see that data after the data sync in records to compare with the previous data sync?

The Appian Documentation below does not explain how to prevent the updating of an existing value. I want to bring in new data, but if the primary key already exists, then I want to retain some of the old data while updating other values. I tried doing something like: if(isnull(rule!Query_Existing(pv!data.PrimaryKey)), "new data", "old Data") and save into the field And the rule above passes the primary key and searches for the "old Data". The rule works by itself, but when I do this if statement, I get a null pointer exception.  Appreciate any help on this. https://docs.appian.com/suite/help/21.4/Write_to_Data_Store_Entity_Smart_Service.html Updating an Existing Value The data that you write can update an existing record when a primary key is properly configured for the entity and provided by your node input. Saving a New Value Saving a new value for an existing record does not merge the records, the old record is overwritten.

Hi Team, Record view summary not getting refreshed after the update related action. Its reflecting only i click manually on the record summary view 

Hi All, I am using a record to show the data in read only grid along with selection. I have to use a database view as a source for record,along with user filters,export to excel functionalities and search box. Since it is a view,I am unable to do the Data sync.But it lands in a performance issue as it takes more time to load. Is it possible to do Data sync for a view? Thanks in advance.

HI All, I want to query all of the data that older than 30 days in the DB.  Can an someone suggest me how to achieve the filtering thing from db? Thanks in advance

I have created one process report and then I fetched the process report data in grid by using a!queryProcessAnalytics function. then i have created link for user to complete the task(for link i have used a!processTasklink function) . when i click on the link it shows this error, the code for process task link, please suggest a way to solve this error  and Is their any alternate way to do it? .

In the function a!queryProcessAnalytics the sort field in pagingInfo can contain multiple sort field without conflicting the result data correctly? I have two fields that are to be sorted together but it seems the results are conflicting because of it.

Hi while making a column chart by make and category i can see the make detail names but my category names just appear as numbers  can somebody help me as to how to get this fixed

I am getting the below issue while updating my CDT. The data source schema does not match the type mappings: Wrong column type in GDMPMDEV.dbo.VT_VW_PRCF_MODULE_PARAMETERS for column Description. Found: ntext, expected: NVARCHAR(255) (APNX-2-4056-000)

I created a view and CDT on top of it;however Data Store is failing to publish the new entity with below error:  The data store "FAS" [id=5401] was saved but cannot be published: An error occurred while trying to modify the data source schema: (conn=267964) 'Appian.FAS_VW_GET_WORK_REPORT' is not of type 'BASE TABLE' (APNX-1-4178-000) I downloaded the DDL as mentioned and it doesnot look appropriate, please check the DDL update suggested below: /* UPDATE DDL */ alter table `FAS_VW_GET_WORK_REPORT` add column a_id bigint not null; @Table(name="FAS_VW_GET_WORK_REPORT") @Column(name="COUNT", columnDefinition="INT") @Column(name="USERNAME", columnDefinition="VARCHAR(500)") @Column(name="ACTION", columnDefinition="VARCHAR(255)") @Column(name="DATETIME", columnDefinition="DATETIME

Hello there, I created a view and CDT on top it. Data store is failing to verify and Publish the new entity. Below is the received error:  Added XSD for reference @Table(name="FAS_VW_GET_WORK_REPORT") @Column(name="COUNT", columnDefinition="INT") @Column(name="USERNAME", columnDefinition="VARCHAR(500)") @Column(name="ACTION", columnDefinition="VARCHAR(255)") @Column(name="DATETIME", columnDefinition="DATETIME") @Column(name="CASE_ID", columnDefinition="INT") @Column(name="CLIENT_TYPE", columnDefinition="VARCHAR(255)") @Column(name="TRANSACTION_TYPE", columnDefinition="VARCHAR(255)") @Column(name="TRANSACTION_SUB_TYPE", columnDefinitio