Data Fabric

I'd like to show multiple DSE side-by-side on the same Excel sheet using Export Data Store Entity to Excel Smart Service node for each DSE. But, let's say the first DSE writes data between A1 and F13 cells. When I call the service again for a different DSE and specify Starting Cell = G1, it effectively overwrites all the rows from the first call leaving A1 thru F13 blank. I've also tried the old deprecated Export SQL to Excel plugin, but that doesn't work either. Is there any way to accomplish what I'm trying to do?

Hi Folks,  I have a question how do we add a row in the database and in the record when you click on the submit button in the readonly, I tried using a!writetodatastore function but didn't work well. Any suggestions will be helpful. Thanks

I am new to Appian and I am evaluating the Appian. I want such function depicted in the subject.  I searched in the "Discuss" and some threads said that I can use "Parse Excel to CDT". But I can't find such function in the community version. There are also some threads saying that some plugins can support such feature. But I can't find any plugins in the community version. Please anyone can confirm such functions are available in commercial version? Or any other alternate way to fulfill such function in community version?

Hello I am new in appian , and I am trying to update my CDT, . when I try to update, this the error "  Details: java.lang.IllegalArgumentException: The list of records to be saved must not be null or empty: TypedValue[it=3807,v={}] Data: TypedValue[it=3807,v={}] I created a process model for updating, when test in this environment the process is OK, So when create a related actions, I call my process model PC_UPDATED_REQUEST. ,and in my site, I click in UPDATE REQUEST everythings is OK, when change the data, and click in submit, the data does not change and I get the error Could someone help me please? Best regards

Hi, I'm trying to make a simple SUM query but it does not return what I need. The query returns a datasubset with 2 lines (quantities: 45 and 46), but I was expecting the query to return 91.(I would like to avoid using the sum() function in this example). Could you tell me what is missing please ? a!queryEntity( entity: cons!CJT_VEHICLES, fetchTotalCount: true, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "quantity", alias: "quantity", aggregationFunction: "SUM", isGrouping: true ) } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "type", operator: "=", value: ri!typeId ) }, ignoreFiltersWithEmptyValues: true, ), pagingInfo: a!pagingInfo( startIndex

This is the what i want , please reply . Thank You in advance.

I have data that is not fetched from DB.  The Data is in this format:  List of Dictionary - 2 items Dictionary id - 1(Number (Integer)) Max_days - 54 (Number (Integer)) Max_amount - 36671(Number (Integer)) Dictionary id - 2 (Number (Integer)) Max_days - 1317 (Number (Integer)) Max_amount - 15158 (Number (Integer)) What I'm trying to achieve is that I get the whole object that has the highest value for Max_days. So as returning result I should get  Dictionary id - 2 (Number (Integer)) Max_days - 1317 (Number (Integer)) Max_amount - 15158 (Number (Integer)) Can you help me, guys? Thx

Hello everyone! I created a scrip task to extract data from a .txt file and save it to CDT. However, my CDT also has a column to save the file name of the .txt file where I extracted the data. Is it possible to do it? If yes, can you explain how? Thank you.

Hello! We have Appian running with SQL server backend, and I want to find out where is user's first name and last name is stored. I searched all the tables but I can't seem to find it (I only see a table called dbo.usr, which only has the username, but no columns for first name and last name, and other fields such as Nickname/Email/City/State/Country/etc). Is this something stored in the database at all, and if not, where can I locate those data? Thanks in advance! 

The issue that I'm experiencing is that I have an list of dictionary's.The structure of dictionary's is like { date: 03/05/2021,  code: "113", amount: "0", id: 4001 }, - END DELAY { date: 01/05/2021,  code: "110", amount: "234", id: 4002 }, - DELAY { date: 22/04/2021,  code: "110", amount: "234", id: 4003 }, - START DELAY { date: 18/04/2021,  code: "113", amount: "0", id: 4004 }, - END DELAY { date: 13/04/2021,  code: "110", amount: "234", id: 4005 }, - DELAY { date: 09/04/2021,  code: "115", amount: "0", id: 4006 }, { date: 03/04/2021,  code: "110", amount: "234", id: 4007 }, - START DELAY { date: 18/02/2021,  code: "113", amoun

Hi, I'm trying to query an external data base using a!query function, like the next image. The Data Store have all cdt created from the third party credentials. I need know if i can use all appian objects normally with an external database.

Here, I have created a decision rule, My requirements are if I call this decision rule in the interface in the orgName field the tax Id and Address should be displayed. How can i configure this in the interface?

Hi there, In the SQL, we can use LIKE as the filter, but in the Appian, there is no such "operator". so in my case, I am trying to build a query to search a database by people's name. if using operator "includes" or "starts with" to search value "Michael", then it will return list of people, but if search value "Michael S", it will return nothing, but it should return some. in the SQL, we can use LIKE 'Michael S%', but dont know how to implement this in the Appian. Could anyone here can help to point a direction? Best regards, Lin

How a record type can interfere with perfomance? Thanks

Hello All, I just want to know how can I update a specific field to a specific index? example is I have 3 list of items, and I only want to update the 2nd index first name to "Jerry" and not "Henry". I tried to use updatearray() but its only updating the whole data or I am missing something?  { index: 1, name: "John", lastName: "Doe" }, { index: 2, name: "Henry", lastName: "Doe" }, { index: 3, name: "Jenny", lastName: "Doe" }, Looking forward to anyone reply. Thank you!

Hi  I am using query record to fetch data from the database.Whenever i am using  query record to fetch image , its giving this error. I am using this code to get the image displayed on the interface: a!imageField( images: a!documentImage( document: todocument(index(ri!employee,'recordType!{89956f33-9ae6-45d8-9fb3-c45b6cc5877c} Request.fields.{87357f56-96ee-41b0-a7db-1972b5ab8161}imageid',null),) ), ), Its giving me this error: Could not display interface. Please check definition and inputs.Interface Def inition: Expression evaluation error at function a!imageField [line 4]: The image at index 1 in an image gallery component [label=""] has an invalid value for "document". "document" must not be null.

Hello, In our project, I have created an interface that has a file upload option. When I used that interface at views of some record file upload is not working. However, That interface is working fine in Appian designer and as a start form for process models at other places. Is it possible to upload files from interfaces used in views of a record? FYI, we are using this record on a site. If it is not possible, Kindly suggest any work around for it. Thanks, Shikhar

Background: In my application there is a simple paging feature that utilizes a server side application to retrieve data for each page of a grid that needs looked at. Upon receiving a response from the server, the onSuccess callback of the startProcess function that is called will use an expression rule which matches the data returned with data found in a view on the appian cloud db. This matching is done in order to alter one column of the data to fill it in with task Ids when one is found in the db for the given data row. Problem: Creating a new task works great and a task Id will show properly in the grid. Paging works great and existing task Ids will show properly. The issue is found when a user creates a task, navigates to a previous page, and then returns to the page where the task Id was. In this case the task Id will not be found. Walkthrough: Scenario 1Navigate to page 3, making previous page page 2create task, task Id showsnavigate to page 2navigate to page 3task Id is go

Hello Everyone, I had a requirement where I had to read an excel file and populate that excel data in a CDT (let's call it example_CDT) for displaying that data in an interface.  I did that and now the whole data is there as a list of items where items are of type example_CDT.  This CDT is already mapped to a table in the DB.  Now, I want to generate and download SQL queries that can be used to insert the data which is there in the list of CDT into the DB. Is there any Appian smart service available through which I can convert get SQL queries from CDT data? please consider example_CDT as a Nested CDT.

Hello I have a requirement that I need to create an interface to show some filtered  process history. An example would be to show all email, and user input tasks that have been run for a particular process. Any ideas on a solution to grabbing this info?  I see process reports don't seem to access this data. Thanks!

I have a txt file that i want to parse and convert to appian value. What do i use for this? Thank you. P.S. (readTextFromFile() was the previous function for this but was already unavailable in the current appian version)

Hi, I am new to Appian and in learning phase. I would like to know how do I treat empty resultSets while using using a!forEach  combined with a!queryEntity My requirements: Query a table When there are no results, return false  If there are results, iterate the results and return if the result set contains non blank items of a column I had added an if condition in a!forEach expression. I am using fv!itemCount>0 condition which works fine only when there are valid results. it is not going into the false block when the resultset is emtpy. How do i check a!queryEntity returns an empty entity/ data without any results? Your help is much appreciated! Please ignore any typos/syntax errors on the below snippet.  load( local!localCollections: a!queryEntity( entity: cons!MY_ENTITY, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "myPK", operator: "=", value:6 ), ignoreFiltersWi

Hi Team, We have a requirement to upload a file, read data from it and display the data on a button click in an interface. We have tried this in a two-step method by orchestrating this in a process model: 1. Uploaded the file using "fileUploadField" component and submitted the form. 2. Reading data in script task and navigating back to the same interface. But here the drawback is until unless the form has been submitted the file won't store on Appian KC so we can't read it. Also, the user has to perform two actions 1. upload the file and 2. click on the "Import data" submit button. Find the below image for reference.   Is there any way to implement this task with a single click? Thanks in advance, Mahesh

How I remove a view from my record? I cant seem to find this anywhere. Something is wrong about it and I cant even find the "Generate Interface". Thanks 

I am trying to make a table like below, how is it possible to merge the common URN no. for different customers? Can you please provide me an example?