Records

Hi, We have a simple code to add a record in a table, and we need to display the total count result stored in a local variable (getting the result from an ER that simply counts the records in the table). When we execute the code, the record is well added in the table, but the refresh of the variable is not down (or the ER is not called ?). We are using a count variable to make a refresh with a refreshvariable function but it doet not work. Are we forgetting something ?  a!localVariables( local!count: 0, local!nb_element: a!refreshVariable( value: rule!CD_Count_CD_Test1(), /* count the nb of records */ refreshOnVarChange: { local!count } ), local!new_bank: ( 'type!{urn:com:appian:types:crm}CD_Test1', { code: 1, libelle: "Un" } ), local!erreur, local!success, local!cancel: false, { a!cardLayout( contents: { rule!SHARED_CardsTitle( icon: "address-book", label: "Bank testing"

Hi All ,  I have a scenario ,  When Person A opened any record in a record list ,                                for selected record ,related action is edit  the record At the same time Person B opened the same record that have chosen by  A and                         Person B tries to edit the same record then record should be lock ( Because Person A is already editing right ) then there is need to Appear like "Person  A is already editing " and could able to edit the record . How can I accomplish this task ????? Thanks all in advance [emoticon:c4563cd7d5574777a71c318021cbbcc8]

HI! I'm new to Appian, in order to save multiple image ID in my CDT do i need to mark the collumn as array?

Hi, I'm using a master/detail pattern with 2 grids, and I can observe an error when on the detail Grid I click Next paging (ex: set to "5-8 of 10") before to click on another row of the master grid. ERROR : "Interface Definition: Expression evaluation error at function a!gridField [line 74]: A grid component [label=""] has an invalid value for "value" and "totalCount". "startIndex" must not be greater than "totalCount", but "startIndex" was 5 and "totalCount" was 1." After browsing the forum I've read that I need to reset the paginginfo because the datasubset keeps the previous values. Could you tell what to add or change in my code example to make it working please ?  { a!localVariables( local!pagingCustomers: a!pagingInfo( startIndex: 1, batchSize: 4 ), local!customers: rule!CJT2_GetCustomersWithFilters( id: null, p

Hi all, I see that Appian introduce many interesting functionalities related to the record type but all of that are only present when data are sync. You can now sync 1.000.000 of rows by record type. I will use it but I'm afraid with the possible impact. As I know, Appian use an in memory database, I suppose sync data are stored inside. What happens when a big number of rows are sync (don't forget that all synched record types are stored in this kind of cache). ? How the database managed it in terms of memory consumption ? Is there someone have information related to it ? Thanks

Hello, My coworkers and I have been trying for a while to import an XSD that imports namespaces from other XSDs, something similar to this: ConnectivityRequest.xsd: <xsd:schema     xmlns="./ConnectivityRequest"     xmlns:xsd="">www.w3.org/.../XMLSchema"     xmlns:bacui="./UserInformation"     targetNamespace="./ConnectivityRequest"     elementFormDefault="qualified"     attributeFormDefault="unqualified"     version="1.0.0">     <xsd:import namespace="./UserInformation"/>     <xsd:element name="ConnectivityRequest">         <xsd:complexType>             <xsd:sequence> &nb

In what is a common design paradigm, I have cases that can have multiple assignees. Depending on the permissions of the loggedInUser(), they should either see cases which are assigned to them or cases through the entire system (Global Viewers Group). The global viewers group should also be able to search by assignee. One of the more common ways this way accomplished in the past was via a double query - one for the assignee table which returned the list of case ids and subsequently another one to the case table. I wanted to use the newer Appian Record functionality, and based on the Appian Playbook, it seemed that Appian had found a more performant solution to this common use case, but I am still seeing duplicates in my Record List View.  I tried modifying the Default Filters in the example application with the instructions here from the Appian Playbook: https://community.appian.com/w/the-appian-playbook/207/record-level-security-for-entity-backed-records under the Managi

Hello everyone, I am having trouble what function to use. What I am trying to achieve is I have a file name that says NEW_210917. I also have a list NEW_TXT_210917, RNW_TXT_TXT_210917, RPL_TXT_210917 and NEW_TXT_TXT_210917. Regardless of the file names on the list. I need to return the list that has NEW and 210917 on their names. So based on the given above. My result should be NEW_TXT_210917 and NEW_TXT_TXT_210917. Any help will be appreciated. Thank you.

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