AutoCAD P&ID General Discussion

AutoCAD P&ID General Discussion

Reply
Active Member
r.roxana
Posts: 6
Registered: ‎06-17-2008
Message 1 of 8 (354 Views)

Column filters

354 Views, 7 Replies
06-17-2008 09:24 AM
Hi,

I have some problems setting filters on columns in Data Manager.
I managed to set only filters of type =700 or ='something'.
When I try to use wildcard or '?' I always get invalid filter.
Does anybody know how to set filters containing '?' and '*' ?
Some examples would be very useful.

Thanks,
Roxana
Valued Contributor
bestm
Posts: 61
Registered: ‎04-25-2007
Message 2 of 8 (351 Views)

Re: Column filters

06-18-2008 03:51 PM in reply to: r.roxana
Roxana,

Can you post a drawing or picture of what you wanting to do. I'm not sure I understand.

Regards,
Mike
Active Member
r.roxana
Posts: 6
Registered: ‎06-17-2008
Message 3 of 8 (352 Views)

Re: Column filters

06-19-2008 12:05 AM in reply to: r.roxana
Hi Mike,

Thanks for reply!
I attached a print screen with what I'm trying to do: filtering the Description column for ='Centrifugal Blower' . And this works.
But I want to filter all the rows where the Description column starts with 'C' letter. In Help is mentioned that '*' and '?' can be used. So I tried: 'C'* , 'C*' and other combinations also, but I'm getting an "invalid query input" all the time.

Do you know how should I set a filter that includes some '?' or '*' ?

Thanks!
Roxana
Valued Contributor
bestm
Posts: 61
Registered: ‎04-25-2007
Message 4 of 8 (351 Views)

Re: Column filters

06-19-2008 09:30 AM in reply to: r.roxana
Sorry Roxana, I can't seem to get it work for me either.

Maybe Mangesh (Autodesk0 can tell us what we are doing wrong.

Mike
*Jorge Lopez
Message 5 of 8 (351 Views)

Re: Column filters

06-23-2008 02:56 PM in reply to: r.roxana
Instead of:

=’C*’

Try:

Like ‘C*’

Thanks to Sasha for his help.

- Jorge


"r.roxana" wrote in message news:5961006@discussion.autodesk.com...
Hi Mike,

Thanks for reply!
I attached a print screen with what I'm trying to do: filtering the
Description column for ='Centrifugal Blower' . And this works.
But I want to filter all the rows where the Description column starts with
'C' letter. In Help is mentioned that '*' and '?' can be used. So I tried:
'C'* , 'C*' and other combinations also, but I'm getting an "invalid query
input" all the time.

Do you know how should I set a filter that includes some '?' or '*' ?

Thanks!
Ro
xana
Active Member
r.roxana
Posts: 6
Registered: ‎06-17-2008
Message 6 of 8 (352 Views)

Re: Column filters

06-23-2008 11:29 PM in reply to: r.roxana
Hi Jorge,

Indeed it works that way!

Could you please provide a list of keywords that can be used in filters, along with a few examples?

Thank you!
Roxana
*Peter Quinn
Message 7 of 8 (352 Views)

Re: Column filters

06-25-2008 05:51 PM in reply to: r.roxana
Roxana,

It's using SQL syntax, similar to how the SQL WHERE clause works. I found a
web site (by googling for SQL Syntax WHERE) that has some examples of what
you can do: http://www.w3schools.com/Sql/sql_where.asp

Peter Quinn (Autodesk)

wrote in message news:5964623@discussion.autodesk.com...
Hi Jorge,

Indeed it works that way!

Could you please provide a list of keywords that can be used in filters,
along with a few examples?

Thank you!
Roxana
Active Member
r.roxana
Posts: 6
Registered: ‎06-17-2008
Message 8 of 8 (354 Views)

Re: Column filters

06-25-2008 10:27 PM in reply to: r.roxana
Hi Peter,

Thanks a lot for your help!

Best regards,
Roxana Racz
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD P&ID Category!

The AutoCAD P&ID forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.