I am creating view (Active AssetRisks) in CDS:
Within PA I create collection: ClearCollect(ActiveRisks, Filter(AssetRisks, 'AssetRisks (Views)'.'Active AssetRisks'));
I set a datasource for view gallery as 'ActiveRisks'. However, I can't access 'Risk Class No Action' field: ThisItem.'Risk Class No Action'.'Risk Class'; If I change the datasource for the gallery to the entity itself (AssetRisks) then I do get 'Risk Class No Action'.
Does it has something to do with the fact that 'Risk Class No Action' is a lookup field from the over entity?
How can I bypass this limitation and still utilize view functionality of CDS?
Solved! Go to Solution.
Since as I have already mentioned the 'Risk class no action' is a lookup from another entity, we need to do lookup from within PA as well. So I created a collection containing all risk classes (AllRiskClasses) and: LookUp(AllRiskClasses, 'Probability No Action' = ThisItem.'Probability No Action' && 'Impact No Action Taken' = ThisItem.'Impact No Action Taken').'Risk Class'
Since as I have already mentioned the 'Risk class no action' is a lookup from another entity, we need to do lookup from within PA as well. So I created a collection containing all risk classes (AllRiskClasses) and: LookUp(AllRiskClasses, 'Probability No Action' = ThisItem.'Probability No Action' && 'Impact No Action Taken' = ThisItem.'Impact No Action Taken').'Risk Class'
User | Count |
---|---|
25 | |
23 | |
7 | |
6 | |
5 |
User | Count |
---|---|
29 | |
28 | |
14 | |
10 | |
5 |