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 (343 Views)

Column filters

343 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 (340 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 (341 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 (340 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 (340 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 (341 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 (341 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 (343 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
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
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.