Skip to main content
1-Visitor
January 12, 2011
Question

Query Builder Criteria

  • January 12, 2011
  • 12 replies
  • 3327 views

So, my PDMLink headache du jour is;

Why is it that all of the attributes available in the 'Select' tab are not also all available in the 'Criteria' tab? Isn't it logical that I might want to filter on the very columns I'm interested in displaying?

I have a report that links together our Changeable objects with their corresponding Change Task, Change Notice, and Change Request. In the report I list the 'Number' for these various change objects along with the 'Context Name' associated with the Change Record.

On the Criteria tab I am able to add filters so that users can look for specific change object numbers, but I can't figure out how to add a filter to limit the Context. The Context attribute I'm displaying isn't available in the Criteria tab. Consequently, users can't search for all change objects within a specific Product.

Can anyone point me toward a straightforward solution to this problem?

Thanks,

Steve

12 replies

1-Visitor
January 13, 2011
That sounds pretty great. Building a Query live over a small set of data would be nice. I certainly like the idea of not having to remember all the class names and what not like I would have to using SQL though.

[cid:image001.gif@01CBB330.DAC496F0]

Steve Vinyard
Application Engineer
22-Sapphire I
January 13, 2011
Just one more on this...
Attached is the list of "types" that one can select for building query builder reports - just FYI.