Currently have two separate but very similar Query Builder Reports that I would like to combine into one.
Both reports are for change notices, and we create change notices for both EPM Documents (CAD) as well as WTDocuments (PDF). So we have three scenarios for the change notice :
The two existing reports work fine separately, but when combined deliver incorrect results. I suspect that I don't have the joins done correctly.
Combined report likely working ok for changes that involve both EPM and WT, but not for those with just one type - because it's looking for an AND condition. Need to arrange essentially as an OR condition.
I asked the same question and nobody could help.
I've created a couple reports with both AND and OR in them but for only one type of objects. Never could get it for more than one type.
Okay, made some progress, but not completely there yet. Doing the outer joins gets me everything listed, but when I add any Criteria against either the WTDocument or the EPM Document, it falls on it's face.
Added an Outer Join Against: Change Task on the From Tab.
Made some more progress and am getting very close, I think.
Found that if you use OR statements in the Criteria, you can filter out the extra information for the most part. Will attach the latest QML file for review.
What version of PDMLink are you working in?
I don't have some of the same listings as you do. I am in 10.1 still but working on upgrading to 11.0.