Error with Record Facets

Question

I'm receiving this error when I try to filter a record with some record facets. The record still loads correctly, the error only pops up when you attempt to use an option in one of the facets. 
 Expression evaluation error at function a!recordListSafeExceptions: An error occurred while executing a save: Expression evaluation error at function fn!getrecorditems_appian_internal [line 43]: An error occurred while retrieving the data for &ldquo;Groups&rdquo;. 
 I assume that this is trying to tell me that it cannot find the field I am trying to query, however since getrecorditems_appian_internal (as well as recordListSafeExceptions) seems to be something of a black box I can't look at it to actually read it. 
 Can someone explain the likely causes of this error so that I can fix it?

jonathan.guillen · Answer

Hello!

I could not be able to replicate this error, although you can use the following as an example:

DATABASE- TABLE <TEST>
COLUMNS
- ID
- DESCRIPTION

test expression rule.

with(
  local!description_Counts: a!queryEntity(
    entity: <ENTITY_NAME>,
    query: a!query(
      aggregation: a!queryAggregation(
        aggregationColumns: {
          a!queryAggregationColumn(
            field: "<TEST_DESCRIPTION>",
            isGrouping: true
          ),
          a!queryAggregationColumn(
            field: "<TEST_ID>",
            aggregationFunction: "COUNT"
          )
        }
      ),
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: - 1
      )
    )
  ),
  local!description_Ordered: if(
    local!description_Counts.totalCount = 0,
    {},
    a!forEach(
      items: local!description_Counts.data,
      expression: rule!AT_RecordFilterCount(
        ids: property(
          local!description_Counts.data,
          "<TEST_ID>",
          ""
        ),
        values: property(
          local!description_Counts.data,
          "<TEST_DESCRIPTION>",
          ""
        ),
        value: fv!item
      )
    )
  ),
  a!facet(
    name: "<FACET_NAME>",
    options: a!forEach(
      items: local!description_Counts.data,
      expression: rule!APPLICATION_PREFIX_HERE_CreateInflightFacetOptions(
        option: fv!item,
        name: "<TEST_DESCRIPTION>",
        count: property(
          local!description_Ordered,
          fv!index,
          null
        )
      )
    )
  )
)

Create a filter count function:

cast(
  'type!{http://www.appian.com/ae/types/2009}Integer',
  index(
    ri!ids,
    wherecontains(ri!value, cast('type!{http://www.appian.com/ae/types/2009}Text?list', ri!values)),
    null
  )
)

3 rule inputs:
ids - number(integer)
values - text (array)
value - text

create facet option inflight function for each value within your records:

with(
  local!value: index(ri!option,"<TEST_DESCRIPTION>",null),
  a!facetOption(
    id: property(ri!option,"TEST_ID", ""),
    name: local!value,
    filter: a!queryFilter(
      field: ri!name,
      operator: "=",
      value: local!value
    ),
    dataCount: ri!count
  )
)

Hope it helps.

Regards.