Records

Hello All, In the code snippet. the data is coming from a view configured. The field sendingName_RSO contains a list of names and the field will hold more than one value. Now I have added a user filter in the Record having a dropdown values of users from the constant defined. When I give "includes" in the a!queryfield to get all the records assigned to a particular user, it gives the below error Error Evaluating UI ExpressionExpression evaluation error [evaluation ID = ad938:9cef1] in rule 'recordhomepage' (called by rule 'sitehomepage') : Cannot apply operator [INCLUDES] to field [sendingName_RSO] when comparing to value [TypedValue[it=4,v=firstname.lastname]]. I wanted to check if there any way we can pass "includes" or "in" in the a!queryfilter in an record user filter. a!localVariables( local!sendingRSO: getdistinctusers(cons!ALL_GROUPS[1]), a!recordFilterList( name: "Sending RSO", options: a!forEach( items: local!sendingRSO, expression

Hi. I need to learn how to apply multiple conditions to a query filter as illustrated below. What is the correct syntax to achieve this as the compiler suggests there is an issue but the test call seemed to work. Thanks.

Hi everyone! I am working with BigQuery, and I have been able to get the response from a database I have there, the data comes in JSON format, so with a help of an Appian expert, we were able to create a dictionary to make it show from this: to this: Now, I need to create records based on this data, just as you can do with the spaceX exercise, where you get data from API, and make a record based on that data without storing it on a table or data base in Appian.  So, I want to do that with this data but when I try to create a record with the dictionary I showed above, I get this error: I guess is because I am no longer getting the response directly from the API or web service, and I'm manipulating it to create the dictionary, so I was thinking on doing an a!map function but I have not been able to succeed Any insight onhow I can get a record to display that data? PS. I need to have it as a record to create a user filter view, to filter some of the fields I'm getting

What annotations will be used if we have to skip a particular field and the remaining fields fetch in the database? ex: i have 10 fields but i need only 9 fields and those are fetched in the database?

Hello There, Is it possible to get a raw data dump of the table(s) that back the Tempo news feed? I have an old application that heavily utilizes the News feature in Tempo and I'm looking to migrate entire capability to a custom implementation that can be exposed within a Site. Thanks Jin

Referencing an older post, https://community.appian.com/discussions/f/rules/13526/set-default-multiple-options-for-record-under-user-filters-in-the-record/61489#61489, it doesn't seem like setting multiple default option(s) for a record user filter is possible. But 3 years have passed and the label is dubbed "Default Option(s)", which indicates to me that maybe multiple default option(s) is now possible. If so how would I configure it?  Currently, I can pass in a single value in the "Default Option(s)" section: ex) 1, and return all the records with field value 1. However, when I pass multiple values in ex) {1,2} it returns all records and doesn't filter on 1 or 2 for that field value.

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.