Data Fabric

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

Is there an integration available for Appian and Alteryx? The goal would be to use Alteryx functions on the Appian record data.

Hi, I am facing an issue where I want to add all the value of a column and display it on the top of the gridfield, The source of data is a recordType (Adding the code down below), Please help me with this. { a!textField( label: "Sum Of Values", labelPosition: "JUSTIFIED", value: a!currency(isoCode: "USD", value: 0), readOnly: true ), a!gridField( labelPosition: "COLLAPSED", data: 'recordType!{b43afdfb-93b4-4d94-9708-ffa71f87754a}MWM Test', columns: { a!gridColumn( label: "Value", sortField: 'recordType!{b43afdfb-93b4-4d94-9708-ffa71f87754a}MWM Test.fields.{2682c5c7-76eb-4a9a-abf5-d409f2bc3f80}budget', value: a!currency( isoCode: "USD", value: fv!row['recordType!{b43afdfb-93b4-4d94-9708-ffa71f87754a}MWM Test.fields.{2682c5c7-76eb-4a9a-abf5-d409f2bc3f80}budget'] ), align: "CENTER", width: "NARROW" ) }, pageSize: 100, selectable: true, selectionStyle: "ROW_HI

text - "CM: Nick Hunt ECE: Fred Wang General Contractor: Villamar PM: Rick Chan RF Designer: Eric Chan ", output- CM: Nick Hunt  PM: Rick Chan RF

hey hi  all,  I am facing an issue with the expression rule that extract the data subset from the task report which in turn, I need to showcase the tasks for the user action to perform the tasks but i unable to fetch the right data from the expression rule    from above code snippets and snap shot i want extract only "REVIEW PROCUREMENT REQUEST" which is dynamic display name but it show the node          name in the expression rule even though it takes it show the display in the task report. thanks in advance!!!                                                                                                                          &

Hello everyone, I have configured a Task report and use this to resume a User input task from My task list. When I resume the process from process instances then I am able to resume, but when I click on the task from My task list, it is showing "The Requested Task Is Not Available The task may have been deleted or completed by another assignee". What will be the possible solution for this error?

We created a CDT called "Extraction_details" in Appian, which contains 36 fields such as "effective date," "agent name," "company name," and others. For each field, we provided an array, resulting in the automatic creation of corresponding database tables. Now, we are trying to create a view for these tables to display all the related data for a single "extraction_Id". But we are getting repetitive rows and data is being multiplied which is causing us more issues. This is related to the query https://community.appian.com/discussions/f/general/35170/need-to-export-process-variable-data-in-a-pm-to-a-formatted-excel-sheet by [mention:7da09a91ebba452c82a6b899cb44d590:e9ed411860ed4f2ba0265705b8793d05]  Is view creation possible?? If so can anyone guide us with it.Thanks in advance,

Hi Folks. Can anyone suggest how to add record action only as a page on site navigation bar? I believe it's only has a option to add record list. Please suggest. Note: I am asking this because there is need to show popup on click of button or navigation menu. Thanks 

I am working in my record type display interface.  One of the fields in our data contains an email address with the name of the person in this format: Bilbo Baggins <Bilbo.Baggins@TheShire.org> I need to extract the string between the < > and display that string as a mailto link in my results.  How do I write this, or if it's not possible to write this, how can this be achieved based on the data as it is? Many thanks in advance - 

Hello! We are using the submenus of the Appian sites (which only accept interfaces). We have a logic where, depending on the role of the user that accesses, when clicking on the submenu of the site you will see one thing or another: Role A: You will see a list of customers (through a record). So far so good, we can put the record list in an interface Role B: You will see directly the detail/view of your customer. Having only one customer associated, we want to avoid the double step of seeing the list of customers (where only yours appears) and click this customer. What we want is that when you click on the submenu, it takes you directly to the detail of this customer (similar to the functionality of a!recordLink). Do you know if there is any option to do this? Thanks!

I have a requirement to pull parent record and its related records. these are 1-many relationships, and 1 related record contains more than 10 rows. I cannot user a!queryrecordbyidentifier as i dont have identifier passed. this is based on date filters.  Any suggestion on how to pull more than 10 relatedrecords under the queryrecordtype() function. I am able to get all relatedrecords without using RelatedRecordData but i am not able to apply additional filters on relatedrecord data. Ex: I want request 1 data, and all the statuses of request 1 from status table which is in 1-many relationship. I only want active statuses that are more than 10 rows, for that i tried to use RelatedRecordData but limit is 10 though it only returned active ones as needed.a!queryRecordType( recordType:recordtype!parent, fields: {}, filters: { a!queryFilter( field: createdon, operator: "between", value: { startdate,enddate }, applyWhen: and(

Hi All, I am getting the below error "An error occurred in executing an Activity Class" at Write to data store entity smart service and not getting more details about the error. Below is the configuration for the smart service. Can you help me in finding the issue? Thanks in advance

Good morning, I need to create a source filter in a record to retrieve those modified in the last half hour. I tried using the now() function, but you mentioned it’s not valid for this type of filter. Does anyone know another way to achieve this? Thank you very much.