AutoCAD P&ID

[#1]

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

[#2]

Roxana,

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

Regards,
Mike

[#3]

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

[#4]

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

[#5]

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

[#6]

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

[#7]

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

[#8]

Hi Peter,

Thanks a lot for your help!

Best regards,
Roxana Racz