Records

Hi, I'm new to Appian and I'd like to create a total field. example: field1+ field2 + field3+ field4 ------- total  and I'd like to display the total in a text field  thanks,

Hi All, I have a requirment in my Interface that I am displaying the data in a grid through Expression rule . But in that there are some fields like say isA , isB and isC  with 0 and 1 value in database . But now the The condition is that I have to show the Yes , No , N/A instead of 0 and 1 on some conditions like 1. If isA is 0 in database  then isB and isC should be N/A in the grid and isA will No in the grid 2. If isA is 1 and isB is 0 in the database then isA will be yes , isB will No  and isC is N/A in the Grid 3. If isA is 1 and isB is 1 in the database then isA will be yes , isB will be Yes and isC yes/No based on value in database Thanks in advance

How to call a stored procedure in appian which is present in DB? I mean like if its table/view we can create cdt's and create data store entity constants, then we can call that constants in rule / interfaces right..., like wise ..., how can we call a stored procedure...?

Hi, I was sure that the question had been already posted, but I did not found... Could you give me a simple way to get the GUID of any Appian component (except for Process models which already display it) please ?  Ex : the GUID of a specific constant or an interface Regards

Hi All, I created a grid using a rule input from CDT. I used selection to add the selected column to another interface. I have 29 rows and the page shows only 10 rows. I want to select al 29 rows on selecting all rows. But it only selects the first 10 rows in that page. I want this to apply to all the pages in the grid. This is my UI, I want to include all those 29 items by clicking select all , but it selects only items in the current page. Thanks in advance for your solutions.

Hello everyone, Given that I have a file name "Test_210908" is there a way for me to get "210908" then convert it to a date 09/08/2021? Any help will be highly appreciated. Thank you.

Hello, I have a gridField which reads the data from a CDT. What is the best solution filtering the data having the operator "includes" and use multiple filters? Thank you!

Hi All, We have a postgre SQL DB connected to Appian system. And one of the column is a primary Key and the type of the Primary Key is UUID. However the Type of the UUID column is not compatible with Appian. In such scenario how to insert the data and how to retreive the data from the database. If anyone has done it in any other way , Please help us in finding out the solution. Thanks, Harsha

I am trying to filter out some problematic records from an API request. Please could you help with the following code? a!localVariables( /* * Run the "queryEntity()" function on "cons!TDW_CHANGE_REQ_DETAILS_DS" to retrieve data for the * first 50 data store entities and store this in a local variable named * "local!entities". */ local!entities: a!queryEntity( entity: cons!TDW_CHANGE_REQ_DETAILS_DS, query: a!query( filters: { a!queryFilter( field: "schemeId", operator: "not in", value: (70011, 70012, 70019, 70306, 70317, 70326, 70328, 70359, 70752, 70924, 71086, 71241, 71243, 71245, 71247, 71249, 71251, 71257, 71262, 71263, 71266) ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) fetchTotalCount: true ).data, /* * Construct an HTTP response that contains the information that we just stored * in "local!entities". */ a!httpResponse( /* *

Is there any way to direct the user to a record summary page after submission (creation) of the record? We suggested a confirmation page with a recordLink, but the customer would prefer not to click another link to get there. The only hacky way I can think of is to chain the user to the a user input task to display the record summary interface, but this means no record navigation, related actions, etc.

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