Hello,
I created a view within data module that references two joined tables. There are quite a few columns in the view, so I decided it would be best to set property
item list = used. The problem I observe is joins are being eliminated when applying that property. Joins are only enforced when including all items (or set to automatic).
It's reminding me of the minimized SQL on in Framework Manager. So the way I figured to get around the missing join is to add a filter condition to the view that is
table1.join_key = table2.join_key. This will enforce the join while being able to use the data module version of minimized SQL.
My question is: is this a suitable practice? Or perhaps there is another best practice you could suggest?
Thanks,
Jeremy
------------------------------
Jeremy Aude
Channell Commercial Corporation
Rockwall TX
------------------------------
#CognosAnalyticswithWatson