Query Builder, looking for object iterations

Forum|Forum|13 years ago
February 16, 2013
2 replies
2449 views

Hey, help please.

I'm using WC 10.1. I'm trying to build a Report Query that will show me all the EPMDocuments (CAD files) that are in a specific directory. I've got the output I want. I think I've got the join I want and the criterion (the sub-directory of choice). My only problem is that I only get the LATEST of each file. I need to get my list to show every single iteration of each of the files. It adamantly refuses to do so. I thought I coud run a bunch of reports, each with an added criterion of any file's iteration being say 0, and then the next report would capture all the 1's, the next all the 2's, etc. But all those reports only bring back files whose LAST iteration is that number.

What am I doing wrong?

My From's are EPM Document and File Folder

My Join is that the CAD doc is a folder member of the File Folder

My criterion segregates the folder of choice, but what magic double-speak attribute am I supposed to use to get it to bring back ALL iterations????

This is drivin' me nuts . . .

Is it my From of EPM Document?? I also tried CAD Document. Just likes to show the last-saved iteration.

aaarrrggghhhhh!

Other

GregoryPERASSO

16-Pearl

Can you show a screenshot of your query builder ?

if you have no critera on the "latest", it should return all the iterations ....

S

SavageFrog

Author

10-Marble

See? I don't have anything in there really... I added the second condition just to shorten my results list which follows.

I admit that I DO have Last Modified in what I want to show, but that's not criteria, right? So, for this particular object, I should be showing at least 10 iterations, but I only ever get the last one.