Records

Issue   Hibernate Error from WriteToDB Smart Service in a process even though new row is successfully inserted to the underlying Oracle Table. There is no underlying oracle error. Error  - ( I have renamed CDT & Datstore & JavaClass Names  )   An error occurred while trying to write to the entity "PARENTCDT" [id=5933241b-7d12-4cd4-a2e3-6854e5d4b895@2558, type=PARENTCDT(id=4480)] (data store: DATASOURCENAME). Details: org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save(): ParentClassNameDT8243 Data: TypedValue[it=4480,v={<null>,,,,,,<null>,<null>,<null>,<null>,,,,,,,<null>,<null>,<null>,,,,1,<null>,,<null>,,,,,<null>,,<null>,<null>,<null>,<null>,,<null>,<null>,<null>,,<null>,<null>,<null>,,<null>,<null>,<null>,}] Details   This error started

Hello! I am having a hard time trying to understand how to put or format my response from bigquery to create records and filter views easily.  So far, I know you can only connect to bigquery via API, using GET method you can get this response So I get the response, that part is fine, then I noticed Appian takes whatever that comes in the body, as the values to use as columns, however, in this case, the values I need, are into the subsection 'rows' I was able to access that by using .body.rows but that takes me here  which as you see, does not come with column names, so Appian is not able to understand how to put that data into the record type. Now, I was able to use the input rule on the response, to map to a dictionary and it works: But then, I get this error on the record type  How can I use my response to be a dictionary, on the record type so that I can work with filters and sync and so on, if my response is coming like that?

Hi, I would like to confirm if there's an audit functionality in database record. For example, a user SQL updated the data in one table via backend, is there an audit in the database itself where we can see what/when/who made the changes backend? Thanks in advanced!

Hello community! I am trying to create a filter view for my record which is a service backed record, I am not sure If I even did the process correctly as I followed the tutorial described here https://docs.appian.com/suite/help/21.3/Service-Backed_Record_Tutorial.html and it helped me getting some things done, I have now created the filters but the thing is, my data is coming from BigQuery, and this data comes in JSON but does not have the table schema, instead it comes as f(for field):[{v(as value:"Argentina",v:1,v:Jon...}] So, I had to do a dictionary then convert into data subset by using todatasubset Now, I have the data displaying on the service backed record as it can not be used as normal record, and I have been able to create the filters , but when I go to the site and I try to select any of the options, it does not work, it loads like it is going to change something, but it doesn't as you can see on this screenshot As you see, the filter should give me record

Hello, Now, I am making an application with an existing Oracle DB.However, in the existing DB, the number of columns in the two tables is 64 and 69, which is more than 50. (I know that if the number of fields (columns) exceeds 50, CDT is not created, and it was not actually published in the Data Store.) If it is for the purpose of inquiry, creating a view table would be good enough. But to insert, you have to insert into an existing table rather than a view. If you cannot change the existing DB, how should you configure it? Thank you.

Hi All, We want to have read and write access directly to Appian cloud database from our external system.  Is it possible through Enhanced Data Pipeline. Is there any other way possible?

I would like to upload CSV files directly form MariaDB to a specific location on Google Drive (for big extracts). Is MariaDB configured (any default plugin) to perform this kind of a smart service, if yes, do we need to create a service account on the domain to perform the OAuth 2.0 auth?

Hello, I am using readexcelsheet() to read an Excel File with multiple sheets. I have used functions mentioned below in the excel sheet. CONCAT(), TRANSPOSE(), SHEET(), CELL() Upon using this function I am getting some errors. please  I don't understand why the readexcelsheet() is trying to read/evaluate formulas.  Shouldn't it only read Data(output of the formula) ?? If readexcelsheet() is not expected to support files having above mentioned functions, please suggest an alternate way to use those functions.  

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) ?