On Assign-Worklist table, display case type property in a column ?
I have a Cosmos app build on 8.6, where I would like to include a Work class (Org-App-Work-QualityDeviationReport) "Deviationtype" property in Assign-Worklist tables, for use on the Dashboard, Home etc.
Note, I would like to use the "Optimize code" option to allow for personalization. This means I can not source the table with a Report. A data page is needed.
1) I have modified the OOTB pyUserWorkList report definition with a class join with the Work class and added the Deviationtype case type property. It works fine.
2) Running the RD from the OOTB data page D_UserWorkListByUserId works fine too.
The data page result shows that the property is located on an embedded page pxPages(Work) in the pxResults list.
3) On the OOTB section HomeWorklist, I have add a new column for the Deviationtype property
I have a Cosmos app build on 8.6, where I would like to include a Work class (Org-App-Work-QualityDeviationReport) "Deviationtype" property in Assign-Worklist tables, for use on the Dashboard, Home etc.
Note, I would like to use the "Optimize code" option to allow for personalization. This means I can not source the table with a Report. A data page is needed.
1) I have modified the OOTB pyUserWorkList report definition with a class join with the Work class and added the Deviationtype case type property. It works fine.
2) Running the RD from the OOTB data page D_UserWorkListByUserId works fine too.
The data page result shows that the property is located on an embedded page pxPages(Work) in the pxResults list.
3) On the OOTB section HomeWorklist, I have add a new column for the Deviationtype property
However: I cannot figure out how correctly reference the Deviationtype property in the table cell. I have tried the with Work.Deviationtype (where Work is the class join prefix in the report) and pxPages(Work).Deviationtype
I have added both pages to Pages & Classes
Ps. I have tried without the "Optimize code" option and with the pyUserWorkList report as source.
And this works !! with column defined as Work.Deviationtype
Also noticed I got a new page auto-created in the Page & Classes tab
However: I cannot figure out how correctly reference the Deviationtype property in the table cell. I have tried the with Work.Deviationtype (where Work is the class join prefix in the report) and pxPages(Work).Deviationtype
try including dot operator before pxPages(Work).Deviationtype
ex: .pxPages(Work).Deviationtype
@RaghavenderReddyL I have tried .pxPages(Work).Deviationtype too. I need to have a look at the data page "Pages & Classes" too. Perhaps the context is lost on the DP. Since the old-school table sourced directly with the report works.