11-07-2022 07:20 PM
Hello,
I'm trying to add a custom user to asset relation to a report I already have. the custom relation is "Validator"
when I add this, the report only returns assets that have data for this relation type. I don't want to lose the assets in the report that don't have this relation. I'd like it to show all the assets and if there is a relation of this type to include it. Please help! here is my code attached
Solved! Go to Solution.
11-08-2022 12:23 AM
figured it out! had to do a left join and put my relation type criteria in there rather than in the where clause:
Left Join tsysAssetRelationTypes On tblAssetUserRelations.Type =
tsysAssetRelationTypes.RelationTypeID And tsysAssetRelationTypes.name =
'Validator'
This fixed it for me. 🙂
11-08-2022 12:23 AM
figured it out! had to do a left join and put my relation type criteria in there rather than in the where clause:
Left Join tsysAssetRelationTypes On tblAssetUserRelations.Type =
tsysAssetRelationTypes.RelationTypeID And tsysAssetRelationTypes.name =
'Validator'
This fixed it for me. 🙂
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now