Show specific reports in a read-only grid

You probably need to put an if() statement around the entire query. What you want to happen is that you should only query IF there is an asset ID to filter on. Otherwise, you should just return nothing. So, you could set up a query like this to define the data for your grid:

if(
  isnull(ri!AM_Match_Report.asset.assetId),
  null,
  a!queryEntity(
    entity: cons!YOUR_CONSTANT_HERE,
    query: a!query(
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: 10
      ),
      logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          a!queryFilter(
            field: "asset.assetId",
            operator: "=",
            value: ri!AM_Match_Report.asset.assetId
          )
        },
        ignoreFiltersWithEmptyValues: true
      )
    )
  )
)

I'm not sure how you are actually using this in your grid, so it's possible the null on line 3 is not correct in your scenario - however, you can replace that with other things (e.g. todatasubset({}) if you want it to return a blank datasubset for your grid).

Hi Peter, thanks for your answer. Also not working unfortunately. Since the assetId is never NULL. I can not imagine this should be very difficult to achieve.. This should be basic functionality right? Am I just overcomplicating it?

Yeah something isn't quite adding up. Did you try running the query separate (like directly in an expression rule) and trying different inputs to make sure it works? I'm also confused about the value in the filter expression you gave above. This looks like it's coming from a rule input for Match_Report. However, shouldn't this come from an Asset rule input if you're display the corresponding match reports for the given asset?

Hi Ozin,

Peter's suggestion should have worked. To better understand your use case, can you share the entire code of your interface and QE expression?

Hi, 

This is the interface expression:

{
  a!gridField(
    label: "Read-only Grid",
    labelPosition: "ABOVE",
    data: a!queryEntity(
      entity: cons!AM_POINTER_TO_MATCH_REPORT_ENTITY,
      query: a!query(
        selection: a!querySelection(
          columns: {
            a!queryColumn(
              field: "matchReportId"
            ),
            a!queryColumn(
              field: "match"
            ),
            a!queryColumn(
              field: "date"
            ),
            a!queryColumn(
              field: "link"
            ),
            a!queryColumn(
              field: "comment"
            ),
            a!queryColumn(
              field: "matchDetails"
            )
          }
        ),
        logicalExpression: a!queryLogicalExpression(
          operator: "AND",
          filters: {
            a!queryFilter(
              field: "asset.assetId",
              operator: "=",
              value: ri!AM_Match_Report.asset.assetId
            )
          },
          ignoreFiltersWithEmptyValues: true
        ),
        pagingInfo: fv!pagingInfo
      ),
      fetchTotalCount: true
    ),
    columns: {
      a!gridColumn(
        label: "Match Report Id",
        sortField: "matchReportId",
        value: fv!row.matchReportId,
        align: "END"
      ),
      a!gridColumn(
        label: "Match",
        sortField: "match",
        value: fv!row.match
      ),
      a!gridColumn(
        label: "Date",
        sortField: "date",
        value: fv!row.date,
        align: "END"
      ),
      a!gridColumn(
        label: "Link",
        sortField: "link",
        value: fv!row.link,
        align: "END"
      ),
      a!gridColumn(
        label: "Comment",
        sortField: "comment",
        value: fv!row.comment
      ),
      a!gridColumn(
        label: "Match Details",
        sortField: "matchDetails",
        value: fv!row.matchDetails
      )
    },
    validations: {}
  )
}

This is the interface rule in the record type:

rule!AM_AssetPerformance(
  rule!AM_GetReportById(
    rf!assetId
  )
)

This is the AM_GetReportById code:

a!queryEntity(
  entity: cons!AM_POINTER_TO_MATCH_REPORT_ENTITY,
  query: a!query(
    logicalExpression: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: "asset.assetId",
          operator: "=",
          value: ri!id
        )
      },
      ignoreFiltersWithEmptyValues: true
    ),
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 50
    )
  ),
  fetchTotalCount: false
)
.data

It looks like your interface input and grid field are querying the same data source.  Is that true?  Could you just pass "assetId" into the interface rule with the grid field?

It doesn't work. Little bit lost here. How do you usually do this? I just want to show the match reports of only that player in a site on a seperate view. 

Change the input to the interface to an integer "assetId" and update the queryFilter to:  a!queryFilter(
field: "asset.assetId",
operator: "=",
value: ri!assetId
)...otherwise it looks like you are querying the data twice.  This may not address your issue of the query returning a null.  

What happens if you take an assetID that you know has match reports and plug it directly into line 36 instead of ri!AM_Match_Report.asset.assetId? Does that work? If it does, then you should be able to completely ignore AM_GetReportById. Your interface rule should include a rule input for "assetId" of type Integer, and this input should replace what you originally had as the variable on line 36. Your reference in the record type should be like this:

rule!AM_AssetPerformance(
  assetId: rf!assetId
)

If this still doesn't work, then there is likely an issue with the data in the database. You may not have set up your relationship correctly or haven't inserted the correct data into the database. I'd suggest investigating the CDTs you created to make sure you have the correct relationship (it should be M:1 with asset referenced inside of matchReport).

This worked!! Thank you so much! 

The original interface input was returning a null(), when no "Match Reports" were found.  This made the input, "ri!AM_Match_Report.asset.assetId", to the query within the grid field null(), thats why when you had the "ignoreFiltersWithEmptyValues=true" it would return all Match Reports and work when it found corresponding "Match Reports".

The original interface input was returning a null(), when no "Match Reports" were found.  This made the input, "ri!AM_Match_Report.asset.assetId", to the query within the grid field null(), thats why when you had the "ignoreFiltersWithEmptyValues=true" it would return all Match Reports and work when it found corresponding "Match Reports".