Records

Hello Everyone, How can I set current schema to a particular schema/database in phpmyAdmin to ensure I execute queries on tables within that schema only. I tried with USE <Schema_Name> . This is not working.  Regards, SG

Hi Team, Is it possible to run SQL(sql is like - select and some condition between 5 tables in cloud database) in expression rule as array values-> to execute other expressions rule in unnamed rule. If possible, please share some example  let assume I'm currently queried data using sql and takes the one of the columns and adding into my custom unnamed rule input. Problem is that its take more time.  If its possible to queries the data using same sql statement as one of the parameters that will save my time eg:  a!localvariables(local!result,a!queryRecord(sql: "SELECT id FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id JOIN table3 t3 ON t2.id = t3.id JOIN table4 t4 ON t3.id = t4.id JOIN table5 t5 ON t4.id = t5.id WHERE t1.column1 = :value1 AND t2.column2 = :value2",parameters: a!queryRecordParameters(value1: "some value",value2: "another value"),fetchSize: -1)); so i assume if that local!result contains the same id which i rune

Hi All, I have created record from a view. By default  filtered to bring only data which is active and in "Edit List" I configured columns and set "rows to display" as 50. Am getting below error message . But when i change the "rows to display" equal to or less than 33, error is not popping up. Can anyone suggest why this is happening? Thanks in advance

Dear all, I'm facing an issue regarding the full sync of a RecordType via Smart Service, which contains a field with Unique constraint This is what I'm trying to implement: First, a large amount of data (several thousand rows) is uploaded to my database table. In that process, first the old data in the database is deleted, because appending the new data would violate the Unique constraint. After the new data is in my database table, I want to do a full sync on my RecordType The problem is, the sync via Smart Service results in an error due to a violation of a Unique constraint. The source data does NOT violate this constraint. I'm pretty sure the issue is that Appian still holds the old data in the RecordType. So when trying to sync the new data, Appian compares old and new data with the same Unique field, which results in the error. This error does NOT happen when triggering a full sync manually. I guess to make my approach (syncing via batches and Smart Service) possib

So, I have a relationship between these record types. I'm trying to put the value of the record type's data field into a value and saveInto parameters. It just doesn't work on the integer fields, only successfully on the text fields. I'd appreciate any feedback regarding this.  The field is correctly an integer, as is the data type in the record field.  recordType!ASK Request Item.relationships.dsSNR.fields.serialNumberQuantity a!columnsLayout( columns: { a!columnLayout( contents: { a!dateField( label: cons!ASK_TEXT_LABEL_NEED_BY, labelPosition: "JUSTIFIED", value: ri!request.needByDate, saveInto: ri!request.needByDate, required: true, validations: { if( today() > ri!request.needByDate, cons!ASK_TEXT_VAL_INVALID_DATE, ""

I'm using a record type in my grid column and need to keep a few columns as sort fields. I was curious as to whether the sortField columns impact the performance of the record type?

Hello readers, We have a previous record view, when accessing these records we want to show the records corresponding to that id in the read only grid, but instead all the records in the table are being shown For example, the airline Iberia, has a related contact But when I enter the summary, in the read-only table, it shows me all the airlines and the contacts of each one in the DATA attribute of the record type I am using the airline record  

I have a related sync record One to Many - Request and Watchers. I am trying to query data from Request record but filter the data so only those requests for which the watcher is the one provided in filter is there as well as isActive should be true. But the response i am getting back is weird. Please have a look at the attached screen for rule as well as the data. It's returning data which doesn't seem to satisfy filter criteria. Am i missing something? please suggest. a!queryRecordType( recordType: 'recordType!{5c74086c-d578-4cb3-bcc9-462eac05e87d}CLM Request', filters: { a!queryFilter( field: 'recordType!{5c74086c-d578-4cb3-bcc9-462eac05e87d}CLM Request.relationships.{456939a6-4ebb-43c0-9f2a-89523af6a1f1}clmRequestWatcher.fields.{72eced9d-9111-4afa-9a19-ec3dbb59e196}isActive', operator: "=", value: false() ), a!queryFilter( field: 'recordType!{5c74086c-d578-4cb3-bcc9-462eac05e87d}CLM Request.relationships.{456939a6-4ebb-43c0-9f2a-8952

I have a usecase where I need to export grid data to Excel but here we need to export not only data but also the same format of each column value that we see on grid. For example we have one of the column Revenue in which we have data as $ 123,233,000 this needs to be  exported to Excel in the same way and also apart from that data in Excel should show in number format with the formatting of above example so users can do some manipulations on that data like summing up the  revenues. Data on that grid  is coming for a stored proc.

This query is simple enoughtselect noteId , miscMattersMainId , createdOn, createdBy , note from PLSM_note Those are the only fields in the table and only two records in PLSM_note,  This is being executed against the pre-defined data source that comes with Appian with almost no load on the server.For reference, when I run this same query in the loud Database/MyPHPAdmin I get Showing rows 0 - 2 (3 total, Query took 0.0003 seconds.)So what's going on as it's taking more than five minutes to complete the execution?

hi Community, i have a use case for creating 4 dynamic user filters whose data source is record type itself .now the challenge is that all the filters should be configured in such a way that if one filter has a selected value the other three filters should display data based on the first selected filter value please suggest a possible way to do it

Hi, I am trying to make use of record type in my application since we have a requirement to display the data in a list and take action for each row or view each row in a dialog box. My Business case is like i would receive a json file as input to my process model and i am using a CDT to map the fields of the input json. It consists of various segments and each segment is a list of values which is supposed to be displayed in appian interface to the clerk and take action on each segment rows. Kindly suggest an approach so that i can start building my application. As i read through the record type and its example implementation i predict it will meet my requirement. The only hurdle i am facing is when configuring recordtype source if i use process model all the active instances of the process model are getting mapped as list rather i want to have only the particular instance in current context's PV which is having list of records to be formed as list and as data source.Kindly sugges

Hi, I am facing one challenge w.r.t CDT data. I am passing a CDT from process model to interface and mapping CDT data to interface and displaying to the user. User updates the data in interface and CDT gets updated in interface. When we do hard browser refresh the saved values of CDT are getting cleared. Suggest a way apart from save draft option available in task form to save values of the CDT in interface or process model.

Hi, I am creating an application in Spanish and when creating a User Filter for a Record Type of type Date Range I have the problem that the date selection calendars are in English and I want them in Spanish, is there any way to change it?

How to  conditionally show or hide a column on a record list based on a selection of a user filter value. Here in this scenario we are using record type object directly on site. Is there a way where we can capture the selected user filter value from a record list.

Hi All, Here is my query. I have DB TABLE with column A, column B, column C.  Please help me to convert below SQL query in to Appian Query Entity. Select * from TABLE where column A = column B; DSE Constant : cons!TEST_DSE_TABLE CDT fields are : columnsA,columnB,columnsC Thanks in Advance.

Is there a way to get the list of fields on a record using an expression? See example below on potential usage. a!forEach( items: 'recordType!{SYSTEM_RECORD_TYPE_USER}User'.fields, expression: fv!item ) If this is not currently supported it would be a great addition that would open up many interesting use cases.

Hi i found this error after i created expression based filter in records and i gave security permissions for Administrators group : administrator , and All users : Viewer  but not able to access the record list link.

Where/ How do I view the record Identifier?  What is the identifier? Attempting to setup a a!syncRecord and unsure the value to put in for the identifier.

Hi  I want to add two user filters in record the data to those two filters is two columns data from DB when i tried was getting error like below  And the data have duplicate values but need unique values only kindly suggest for this also a!recordFilterList( name:rule!ATRFA_translateLabel(field:"wbs"), options:a!forEach( items:cons!ATRFA_ENTITY_SETTLE_REQUEST, expression:a!recordFilterListOption( id:fv!item.wbs, name:fv!item.wbs&" ["&fv!item.wbs&"]", filter:a!queryFilter( operator:"=", field:"wbs", value:fv!item.wbs ) ) ) ) Error: The Requested Record Type Is Not Available The WBS user filter expression for record type ATRFA_Settle_Request failed to evaluate. Details: [Expression evaluation error at function a!forEach [line 3]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!recordFilterListOption [line 7]: Invalid index: Cannot index property 'wbs' of type Text into type

The way I understand it is that the idea of Record Sync is to replace the functionality of database views by creating relationships between tables which work like joins in views. That being said, a big part of database views is joining transactional tables which store ref IDs with ref tables to get the display values. Would it be considered an anti-pattern to create a record type for a ref table and join that to the transactional record to display a ref id's display value, or is that under the intended functionality of Record Sync

Hi, There is a stored procedure that updates the database and soon after we trying to sync records in a subprocess.Sync of all records and related records based on identifier is done.It has been observed that certain processes are being paused while others are completed fine. This is random behavior and no error on process model. Please let me know if any solution regarding this. Thanks, Bhavika

Currently building out a Usage Metrics dashboard which uses a plugin to read the Records Usage log. In the "Filters" field returned from said log, it records searches which are typed into picker fields but NOT searches typed into the search box on the grid.  For example, when I'm searching a gridField populated by a!recordData sourcing from a synced Record Type, using the OOTB gridField search box, nothing is recorded in the Records Usage log. Nor does it record any application of user filters.  When I am using a pickerFieldRecords sourcing from the same synced Record Type, only then are my search or filter values recorded in the log.  Effectively, nothing is recorded in Filters when applied to the Record Type-backed grid; this seems like an error -- that only searches/filters applied via picker field would be saved. Everything I read in Appian documentation led me to believe that the above data points would be saved under Action = "Reco

Hi, my problem is that I can export correctly the entity and download as Excel file but when I open the file only appear the data of father CDT but not the rest of the nested CDT. This is the code of my grid: a!localVariables( local!autoridad:null, /*local!selectedAudiencia: ri!audiencia,*/ local!startIndex: a!refreshVariable( value: 1, refreshOnVarChange: {ri!selection,ri!autoridad, ri!motivo, ri!empleo, ri!ejercito, ri!situacion, ri!audiencia} ), local!pageSize: 10, local!sort: { a!sortInfo( field: "id", ascending: false() ) }, local!pagingInfo: a!pagingInfo( startIndex: local!startIndex, batchSize: local!pageSize, sort: local!sort ), local!selection: ri!selection, local!data: a!refreshVariable( value: rule!AU_ER_getAudienciasByFilter( autoridad: ri!autoridad, motivo: ri!motivo, empleo: ri!empleo, ejercito: ri!ejercito, situacion: ri!situacion, nombre: ri!nombre, pagingInfo:

Hi All, I am facing an error when opening a summary view of a record. I am attaching a screenshot please help me out. Thanks in advanced.