Data Fabric

a!localVariables( local!statusFilter: null, /* docs.appian.com/.../Task_Report_Tutorial.html */ /* Basic steps to follow: */ /* 1. Create a Process Report object */ /* 2. Duplicate an existing process report, e.g. active_tasks */ /* 3. Create a Document constant for the report, e.g. TASKS_REPORT */ /* 4. Replace the value parameter of the refresh variable */ /* local!taskReportData with a process analytics query e.g. */ local!taskReportData: a!queryProcessAnalytics( cons!WSAACTIVE_TASKS_POINTER, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1, sort: a!sortInfo( field: "c2", ascending: false ) ), filter: a!queryFilter( field: "c5", operator: "in", value: local!statusFilter, applyWhen: a!isNotNullOrEmpty(local!statusFilter) ) ) ), There is still code left, which is not effecting the above. The error as of now at : " local!taskReportData: a!queryProcessAnalytics ". In order to highlight the error , I ha

I have the following queries related to Data Fabric: Is Data Fabric feature available in Standard capability tiers in 24.2? Is Data Fabric and Data Fabric Insights different? If Data Fabric feature is not supported in the Standard tier of 24.2, how to use reports created in the old version (24.1)? Please share your input.

I have Created a Report Using Data Fabric Self Service Analytics with Grid. If I wanted add any User Filters i didnt find anyway to do that. By Default Filters are there but Post Creation of the Report, if we want to filter the data i am looking for. Please do let me know if is there any way to it Thanks, Praneeth.

Is there anyway by Using the Chatbot I can be able to Access the Application Data ? Thanks, Praneeth.

Hi All, I have requirement where i need to clone "Users" system record. we are in 24.1 and create record from record source is not available. when i tried to create using webservice its not allowing query functions.  Is there a better way to achieve this?  Thanks,

Given a list of files, having obtained the list of their relative sizes, I have to iterate on the list until I obtain a maximum size (for example 10MB) and from the next file start again with the same process, iterating until the end of the list

Hello All,Is there a way to track / get a count of number of nodes within the process models for each application that was created? I am currently reviewing all the applications that was created and I am stuck at this point during the documentation. I know there's a way in health check report to get the process model details which uses too many nodes but my task is to get node counts for each process model irrespective of max or min nodes criteria.  Any help?

Hi All, i am stuck in one scenario, i just want to create interface where rules would be displayed ,added and updated. i want to list all the existing rules to be display like below screenshot. There are several products with base prices and i want to set some tax percentages as per the product and countries. and my appian records are like below screenshot.

I use the related actions of the record type to change or delete records. The flow is as follows: ①Click the "Inquire" button from the list (button of record action)②Click the "Delete" button on the inquiry screen③The inquired record is deleted.Suppose that Mr. A and Mr. B are viewing the listings at the same time. In this case, if Mr. B tries to open the inquiry screen immediately after Mr. A opened and deleted the record, an error will occur. (Error message: An error occurred while applying the context of the related action)Is it possible to handle this error?For example, to move to a screen that displays an arbitrary message, etc.Thanks

Hello! Im having trouble trying to resolve this. I have a record Action that can be activated only when a client goes to the Activity Log "Customer Registration retries on: 28/06/2024 9:23 GMT-05:00" three times, but im having trouble for the query to find me that activity log without the date.

I have a record that I use in many interfaces, querys. I need to change the data type of a column in the database. If I make this change, the references to that field are lost and I have to edit all the objects that use the field from that record to reference the new field type. This can be avoided somehow. That is, appian updates the reference of the record.field automatically.

By Using a!recordsChatField() we can get the One Particular Identifier data and its Related Data. But If i wanted to get data for Multiple Identifies. Example : I am having employee and Education Details and Address Details and Certification Details. Now i want to get the Details employees who are L2 Certified and Who Qualification is MCA ? Is There any way to do this by using or Records Chart Field or any Chatbot. Please let me know is there any way to do this. Thanks, Praneeth.

I have a record type called : Global Case  the fields for this record type are : caseId : Number (Integer) , caseTypeId : Number (Integer) Now this record is related to another recordType called : Global Case Type  the fields for this record type are :  caseTypeId : Number (Integer), caseTypeName : Text My database looks something like this :  Global Case :  CaseId CaseTypeId 1 1 Global CaseType CaseTypeId CaseTypeName 1 Dummy Case Type Requirement : I want to display on an UI the case and its caseType in a grid  Approach :  I did a query record type and queried all the cases and then used the relationship to display value. (Code : )  a!localVariables( local!case: a!queryRecordType( recordType: recordType!GCMF Case, filters: a!queryFilter( field: recordType!Global Case.fields.caseId, operator: "=", value: 1 ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ) ).da

hi I tried to connect postgresql datasource from appian community environment using connected system but cannot connect.Is something missing in the settings?

In-order to display data over a World map which is an add-on/ plug-in system is accepting the data in : local!test:a!map( 1:{ latitude: "18.1096", longitude: "-77.2975", tooltip: { content: "Jamaica" } }, 2:{ latitude: "35.9078", longitude: "127.7669", tooltip: { content: "Korea (South)" } } ), But while using forEach loop we are getting data from system in below expression and format a!forEach( items: local!getMatchedIntells, expression: a!localVariables( local!id: fv!index, local!name: "", local!lat: "", local!long: "", local!finalDt: a!map( latitude: local!lat, longitude: local!long, tooltip: { content: local!name } ), local!finalDt ) [{'1': {latitude: 23.424076, longitude: 53.847818, tooltip: {content: "United Arab Emirates"}}}, {'2': {latitude: 33.93911, longitude: 67.709953, tooltip: {content: "Afghanistan"}}}, {'3': {latitude: 41.153332, longitude: 20.168331, tooltip: {content: "Albania"

I am building a POC for leave management systems. Tables: Employee( holds employee details), Leave balance(holds leave balance and the leave type), Leave table( shows the type of leave and its maximum limit), and leave history(holds leave history of employees)  I am trying to check the leave balance for the employee with filter - logged in user and leave type . leave type is Integer. I get results of every leave type which is not my expectation. please help me fix this issue. I want only the leave balance for a particular type.  query o output:

Hi all, We are using a read-only grid to display data from a record and have the Export to Excel option available. The problem we are facing is that the Excel also includes the Edit and Delete Row columns which we added to the grid to add these functionalities to the interface. Does anyone know if we can select the columns we want to be included in Excel or how to delete these two columns? Thanks in advance.

Problem Statement : by using Self Service Analytics can i build elastic Search and it will show case me the data according to it ? Is there any feature or option to build a global search for entire project. If i Search like  i want List of Employees part of Some XYZ Project. then it should show case the data accordingly. Just like a google Search and show the Results(Grid, Reports etc) in Appropriate manner from the database. I have tried documentation but could not able to find anything. Please let me know is there any way to do it ?  Thanks, Praneeth

We are trying to use the Export Data store entity to CSV smart service to generate a CSV which then gets SFTP'ed to an external location. We have a scenario where if there datastore entity doesnt return any rows, the CSV automatically generates a CSV with the header rows and the second row contains the text - "No data available due to empty data source, applied filter/selection criteria, or fields visibility". Is there any way we can have the CSV exported without this text in the second row? I dont find any options in the smart service setup, but if any of you have a non hacky way of working around this scenario it would be great.

Hi Everyone, I have a requirement where I need to sort the grid on page load based on Priority . Eg.we have Critical, high and low priority. Critical priority cases will come at the top followed by high and low. I have given priority in initial sorts. In addition to that I have to sort with latest id on page load. So I have given both id and priority column in initial sorts so that it will sort on page load. This is working for the grid when the data source is coming from record. So the latest critical cases will come at the top since we have provided both id and priority in initial sorts. I have another grid where the data source is from process report. There I could able to provide only one initial sort(either id or priority). It is not working as expected when I provided two initial sorts(i.e Id and priority). Is there a way to provide multiple initial sorts for the grid where the data source is from process report. I need to sort both the columns on page load. Please help me to ach

I have a non-synced REST API that I am using to fetch data via an integration. This endpoint supports paging. In both the record data source and the integration, when I put a a!pagingInfo(x, y), in the pagingInfo test inputs, the data increments through pages correctly according to the values I give for x and y. But, in the data model test listing and the record list URL, the first 50 records appear (as expected) with the correct record total (more than 1,000), but when I click the next button, the next page is blank and says "No items available". I can click the previous button, and the first 50 records display again. The Paging Info drop down on the data model page is mapped to the correct rule input on the record data source. The Appian version is 23.2. Here is my code for the dataSubset in the record data source: a!dataSubset( startIndex: ri!pagingInfo.startIndex, batchSize: ri!pagingInfo.batchSize, totalCount: local!integrationResponse.result.bo

I want to loop through a list of 'Course' CDT and increment the local variable named progresspercent by 25 each time I encounter a Course with status "completed". E.g. a student is enrolled in 4 courses and 3 of them have "completed" status, the progresspercent variable should be 75 in this case. Following is a snippet of my code and a picture of the output I am getting.Can you please help me figure out how I can do this? a!localVariables( local!progresspercent: 0, { local!progresspercent, a!forEach( items: rule!ID_GetCourses(ri!collegeid), expression: { local!progresspercent + if( fv!item['recordType!ID course.fields.status'] = "completed", 25, 0 ) } ) } ) /resized-image/__size/640x480/__key/communityserver-discussions-components-files/16/Screenshot-2024_2D00_06_2D00_14-at-6.30.24_2F20_PM.

Hi all!Once we create a record via Web Service, we will be creating a Connected System along with Integration, now Appian creates us a new record data expression with a single rule input -> ri!batchNumber. Now, lets say I have a web API which has more than 2,000 rows of data. Now, at first iteration the batchNumber will be 1 and in next iteration the batchNumber will be 1001 i.e for each iteration our start index ---> 1 + ((batchNumber - 1) * batchSize) Now, do we have to handle this manually or Appian handles by itself ? i) Could anyone send me a sample working record data source expression code that handles the paging Info.ii) Do we need to handle this pagingInfo in the Integration also? A sample screenshot would be appreciated for both Integration and Expression

Hi, I am using a dropdown with values retrieved from a record. The record only has the identifier field and a text field. The issue is that when using the search option, it finds values that do not match exactly what is typed in the dropdown search box. For example, I type part of the name of one of the records ("real") and it correctly shows only one matching result, "LOREAL EUROPE SUCURSAL ENESPAÑA." However, if I add one more letter ("reald"), the results change and show two results that do not exactly match what I am looking for: "INDUSTRIA CORE ESPAÑOLA DE MODA" and "NEW ERA REMARK LIMITED". I understand that it shows these values due to the following, "INDUSTRIA CORE ESPAÑOLA DE MODA" and "NEW ERA REMARK LIMITED". If I add an "a" -> "realda", it only shows "INDUSTRIA CORE ESPAÑOLA DE MODA". Isn't there a way for it to search only for re

Hi All, I have recently updated a data type via a new version XSD , it was successful and I also went in and published my Data Store. And old PM which works fine in higher environments with the old version of the data type is throwing me this error every time I try to write to DB,  An error occurred while trying to write to the data store [MOR Data Store].  No values have been written. Details: org.hibernate.exception.ConstraintViolationException: could not execute statement (APNX-1-4208-004) Was this caused due to the update of the data type? any suggestions? thanks in advance