Filters in Report Manager Query

[bwilson-2]

Hi all,

I have a question about something that I think should be pretty easy. I have a report that selects EPM document by number. When I run the report I get the .prt .asm and .drw files. What I need to do is not have the .drw files returned. i just want the Parts and Assemblies. I have added a select by "Type" which shows the type but I can't figure out how to filter out the drawings. Any ideas?

Thanks,

Brian

[AL_ANDERSON]

If it is querybuilder, then just add a selection criteria where NUMBER is
LIKE %.drw or LIKE %.DRW. It is worth noting that the criteria is case
sensative.

If you have a saved search, then use Number with the wildcard *.DRW in the
Number field.

If you have a custom reports, like a jsp, then add a query spec where the
NUMBER ends with DRW or drw.

Al Anderson




Brian Wilson <->
01/07/2011 06:00 AM
Please respond to
Brian Wilson <->


To
-
cc

Subject
[solutions] - Filters in Report Manager Query




Caterpillar: Confidential Green Retain Until: 02/06/2011



Hi all,
I have a question about something that I think should be pretty easy. I
have a report that selects EPM document by number. When I run the report I
get the .prt .asm and .drw files. What I need to do is not have the .drw
files returned. i just want the Parts and Assemblies. I have added a
select by "Type" which shows the type but I can't figure out how to filter
out the drawings. Any ideas?
Thanks,
Brian

Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription
Use of this email content is governed by the terms of service at: