Data Fabric

Hi, Could you tell me why the "fv!row" is not accepted for gridColumn attributes other than "value" please ? How may I hide this column using showWhen ? a!gridColumn(  label: fv!row.label  => Improperly scoped variable  value: fv!row.amount,          => OK no issue   showWhen: fv!row.isactive  => Improperly scoped variable ),

Hello! I'm developing an application that needs to let the user upload and download pdf files. The problem begins with the fact that the size of the pdf can be from 200mg - >1GB. Is there any reasonable solution for this topic?. There's some way in which I can storage a big size PDF outside Appian and then call it back for its downloading?. Thank you!

Hi, I have a CDT that contains many lines. How would you construct a new CDT (new local variable) with merged lines (with average calculations) depending of a field values ? (like the picture below)  Naively, I would use a foreach and create some lists, but I'm sure Appian provides some great functions to make this stuff easier :-) (the question is not SQL-query oriented, I'm looking the best way to do it with SAIL from an existing cdt) Regards

Hi, I have a very simply code and need to make 2 things: - create a first list that feet a condition - create another list (exclusion) using the same condition I would like to see how would you do using a single foreach please ? a!localVariables( local!lst, local!goodVehicles: a!forEach( items: ri!vehicles, expression: if(and( fv!item.typeid = 1, fv!item.isavailable, not(fv!item.deleted) ), fv!item, {}, ) ), local!badVehicles: a!forEach( items: ri!vehicles, expression: if(and( fv!item.typeid = 1, fv!item.isavailable, not(fv!item.deleted) ), {}, append(local!lst, fv!item), ) ), { good: local!goodVehicles, bad: local!badVehicles } )

Hi, I read this thread but I believe my question is different: https://community.appian.com/discussions/f/data/10323/unable-to-find-table-or-view-for-oracle-db/45615#45615 1. I have an Oracle schema ADMIN, and another schema APP. 2. All tables are created and owned by ADMIN, APP has selective grants to those tables.  3.I created public synonyms for all the tables under ADMIN. 4. I'm trying to connect the appian datastore to oracle using the APP schema. 5. None of the ADMIN tables are viewable from the APP datastore. (When I create a CDT from database, none of the tables show up in the dropdown.) Why can't the APP user see the ADMIN tables? Thanks, Elisa

Hi , I am using Record type as a data source as grid field . I have the requirement to show the first 500 record list in the grid after applying filters and sorting. I did something like this. local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500), a!gridField( label: "Read-only Grid", labelPosition: "ABOVE", data: local!employeeData, columns: { a!gridColumn( label: "First Name", sortField: "firstName", value: fv!row.firstName ), a!gridColumn( label: "Last Name", sortField: "lastName", value: fv!row.lastName ) }, pagingsaveinto: local!pagingInfo )I understand batchsize will not help as it will return 500 rows for each page. Can some one help here

Hi, I am trying to save the user answers of multiple page survey interface in one local variable as a json object to save it to the database. I have rendered these multilevel questions from part of the json object like that: { "sections": [{ "sectionname": "1. Legal Information, Disclaimers and Acknowledgments", "sectionlevel": 1, "sectionparent": "root", "questions": [{}] }, { "sectionname": "1.1 Legal information", "sectionlevel": 2, "sectionparent": "1. Legal Information, Disclaimers and Acknowledgments", "sectioninstructions": "Test Instructions", "questions": [{ "questiontitle": "Legal Terms of Use", "questionnbr": "1.1.1", "questioninstructions": "Test Instructions", "questiontext": "Feugiat sed lectus vestibulum mattis ullamcorper. Tempor orci dapibus u

I have 2 rows in the excel file. I am reading that excel file into Appian by using readexcelsheet function.  While reading I give the start row 1 then it is showing an error. when I give 0 that it is working, don't know why?

I am working on a requirement where I need to show the read only grid to the user and user will be able to filter the data. I need to show the sum of filtered column values also to the user. I was trying to cast the record type to CDT in the following way but it was showing castInvalid: cast( typeof('type!{urn:com:appian:types:INV}CDT_NAME'()),  recordType!recordName)

Hello All, I need to open a dialog box when i click on Add/Modify Action/Related Action. While I do so for Add New Item, I want to pass a parameter to the process.  Unable to do it using a related action as it requires an identifier which does not exists when you add a new Item. Any suggestions to achieve this requirement.

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!