Show specific reports in a read-only grid

Question

I have two record types: 
 1. Asset 
 2. Match Report 
 The Assets have a one-to-many relation with the Match Report 
 I want to show an Asset specific grid where it shows all the Match Reports of that Asset 
 I have created a read-only-grid where I query that the assetId should match the match_report.asset.assetId 
 This only works if the Asset has a minimum of one Match Report created 
 If there are no match reports available linked to the asset, the query will fetch all match reports from all assets and show them in the grid. 
 Can someone help me to make sure the grid is empty if there are no match reports available? 
 This is my query in expression: 
 a!queryLogicalExpression(
 operator: "AND",
 filters: {
 a!queryFilter(
 field: "asset.assetId",
 operator: "=",
 value: ri!AM_Match_Report.asset.assetId
 )
 },
 ignoreFiltersWithEmptyValues: true
)

Peter Lewis · Accepted Answer

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

Show specific reports in a read-only grid

Top Replies