Records

As far as I know, the record search box on a record-backed gridField will do a search on the raw data of all of the columns in the grid. For example, searching for "username1" will return any rows that contain "username1" in any of the columns' raw data, regardless of how the data is formatted. If the column data was formatted to show First Name or Last Name, a search for "username1" would still return the row; however a search for the First Name value or Last Name value would not return any results, as this is a formatted value and not the raw value. I have a requirement for the search box to enable searching on first name and last name values, not only username. Are there any elegant solutions to enable this? The only ideas I have are not very elegant: create a daily username sync process so the database has the user's first and last names, then update the view / cdt to include these values. convert the record to an expression backed record and

Can anyone please let me know how to find the missing field in records !

Hello there! I am trying to put data from bigquery response API, into a table to create record types.  So far, I have been able to get the response from bigquery and convert it to appian values, the response looks like this: then, I created a rule to narrow down to the values, but as you can see, the column name does not come from the response, so it displays all the values as rows but on the following way : so as you see, I do not have columns  there , I guess the best way to go on this, will be to get the JSON response converted to an array, and then pass it to a table but not sure if this is possible, any advise?

Hi there, i have created a new record "Record_A" with 1:N relation to record "Record_B". In the record list "Record_A" I have added the field "Field_B" from "Record_B". (Record_A.relationships.Record_B.Fields.Field_B) No problem so far. The record list ist showing me all the relevant data from "Record_A" plus the "Field_B" from "Record_B". But it's not possible to search for the related field "Field_B"  in the record list of "Record_A". The search funcionality based only on fields from "Record_A". So I have tried to create a custom record field. Because I assume the custom fields will be included in the search matrix at least. But it's just not possible to reference to a field from "Record_B" using the relationship functionality. The supported functions are restricted for a custom field. Did I miss something ? [emoticon:c4563cd7d5574777a71c318021cbbcc8] T

we have a customer project where we use task chaining so that the user does not have to refresh the screen to see updated data. With the new record sync feature in Appian, will task chaining be necessary ? our data source for our records not external, i.e  the data is updated by CDTs within our Appian application to our database. Any help will be greatly appreciated. Thanks. Ani

HI Team , I have a requirement where i have query a data from DB in that one of the column returning a data like this  "abc;abc;dfg;vbn" I need to apply a filter on this can anybody suggest how can i achieve this?

a!localVariables( Â%A0 local!doctorsList:rule!HM_getDoctor(department: ri!requestedDept), Â%A0 a!columnsLayout( Â%A0Â%A0Â%A0 columns: { Â%A0Â%A0Â%A0Â%A0Â%A0 a!columnLayout( Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 contents: { Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 a!sectionLayout( Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 label: "Appointment", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 contents: { Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 a!dropdownField( Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 label: "Department", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 labelPosition: "ABOVE", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 placeholder: "--- Select a Value ---", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 choiceLabels:{"Gynecologist","Pediatrician","Psychiatrist","General Surgeon","Cardiac Surgeon"}, Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 choiceValues:{"Gynecologist","Pediatri

Hello, I am using Appian 21.2 on cloud version (MariaDB) and I have 2 Views: 1) one view with 30 columns and ~300k rows which works pretty fast2) second view with 85 columns and ~140k rows which takes around 8-9 seconds to load I know that using the standard smart services you cannot have more than 50 columns and max 100k rows and whenever I use the smart service Export SQL To Excel it breaks "max_statement_time" exceeded. Also querying a few rows from the second view won't be possible since it breaks. Any idea for OOTB solutions? Thank you!

Hello, I would like to set a connection from Excel to our CloudDB. Is it possible, if yes, how do I get the connection details and what connectors should I install? Thank you!

Not able to write data into data store entity (database) using Process Modeler

Hi, I have a very simple RecordType with a user filter (example : year). I've created an interface based on this recordType. When I test it from the interface, I enter a year in the field, then the grid is correctly filtered by the year. Question : you to get the filter value the user has selected (to use it later in an Expression rule for example) ?

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.