Data Fabric

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?

I have a view with 11017 records and I'm trying to export this data to csv via Export Data Store Entity to CSV smart service. The issue is that it exports only 11015 records and the file size is around 200KB

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 Team, Here I want to pass parameters dynamically from Appian to the stored procedure and get the data subset, then export that data subset to Excel. I have created a stored procedure, and when I tested passing dynamic fields and data, I am getting results. Now I wanted to export this data subset to Excel, so I tried using the "Export SQL to Excel" smart service. But I am getting the following error: "The following error was raised by the Export to Excel function: null" Is there any other smart service to export data subsets to Excel? Please advise. Thank you!

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

Im trying to set specific format for Start Time Column at the process report and data does not show when i set the format.

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.

Hi Techie, Record is getting updating/inserting in the external database however when coming to Record Type, it is failing to sync.Can anyone please look on it. Caused by: com.appiancorp.core.expr.exceptions.IssuedException: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error [evaluation ID = f7383:f3bde] at function a!recordList: An error occurred while retrieving the data for "PEG_CMP Request". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000)

I need some help to create an expression rule to check if my given time is within the range. For example, my process model will start running today at 6PM then should stop running at 5AM the next day. Now I need to create a validation where it returns true/false to check if the execution time is still within the range. Hope anyone could help me. Thank you.

I need the ability to sort an array of a Record Type similar to how for an array of dictionaries or CDTs you can use a!dataSubset() with the correct paging info.  I tried that with an array of record type and with the correct paging info using the record syntax.  It did not error out when called like todatasubset().  It just returned exactly what I passed in. Requerying the the database using a!queryRecordType() is not an option.  Until a form is submitted, I have to continue manipulating what's in local variables.  Because of the sheer size of the input fields and the quantities of fields, I can not use either a!gridField() or a!gridLayout().  I am looping through using a!forEach() in a card layout.  Removing and re-inserting back into the array is what I am doing for certain user sort functionality.  But, it's more efficient to then resort for all the remainder sub and sub-sub elements in the array. I prefer not having to cast

Is there upper limit on the number of related records fetched with dot operator on the parent record using record relationship? We see only10 records regardless of the total number of children records with one-to-many relationship.

I have a Class record type and a Student Record type with a relationship between them one-to-many.when I try to get a Class with all the students (every student contains classId) I get only 10 of them but I have much more.how can I fix it? a!queryRecordType( recordType: 'Class', fields: { 'Class.relationships.Student' }, filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'Class.Id', operator: "=", value: ri!id ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data[1]

I have created a Record Type which is bound to a Connected System and an integration which fetches data from a REST endpoint (web service) with data sync enabled. I was able to create a record list to view the fetched records in a table. I am trying to add a custom record list action which adds an item to this record type and eventually update and delete actions as well. As per my understanding we have to create sync expressions in order for these actions to work. I am new to the platform and I am not finding enough resources to help me understand how to perform CRUD operations on a service backed record type. Need help in pointing me to the right tutorials/links which can shed some light on this. Thanks.

Hi All, One of our old application was storing date time as TEXT format. Some of the values in DB for column called 'datetime TEXT" column are  5/15/2018 2:57 PM GMT-04:00 5/15/2018 2:57 PM GMT-05:00  3/12/2018 5:25 PM EDT 2/6/2018 1:48 PM EST Recently we are trying to add new column to store this value. Just say "dateTime" column with datetime type. On doing so we will be storing in datetime format for all new request after this update. But for older request the value will be in TEXT format as mentioned above. Can anyone suggest best way to convert and populate datetime for older request into the new column which i have created. dateTime(TEXT) dateTime 5/15/2018 2:57 PM GMT-04:00 ? old 5/15/2018 2:57 PM GMT-04:00 ? old 5/15/2018 2:57 PM GMT-04:00 ? old 10/18/2017 14:02 new 10/18/2017 14:02 new 10/18/2017 14:02 new