AutoCAD Electrical

[#1]

Whenever I place a component (all components are the same) and I come to do a part number lookup, I find there is always some kind of filtering.  

There always appears to be some text of filtering in the column textboxes as per the attached.  

This is the same for every component....I always find myself having to clear this filtering every single time and to be honest it's starting to really annoy me now.

Does anyone have any idea what causes this?

Thanks

[#2]

There is a table in the database called _LISTBOX_DEF. This where the default filtering for each family is stored. You can edit it to have whichever items you want each family to be filtered by.

[#3]

Sorry, I forgot to mention in the original post, the _LISTBOX_DEF table is completely empty so I'm guessing the filtering is not from there...

[#4]

As an experiment, I thought I'd do the opposite with the _LISTBOX_DEF table in that instead of leaving ot blank, I'd add * into the columns so that all columns are filtered by that wildcard.

The attached image shows the results, which are interesting.  Although the _LISTBOX_DEF table says nothing should be filtered, something somewhere is overwriting this in the lookup table!!

Anyone know whats causing this?

[#5]

But Bob is absolutely right. Please look closely, it should look like this:

[#6]

Is this database a default database for this project?

[#7]

Ok, I think I see?  It looks as if you cannot filter on certain fields, if you do then you get the results I have. 

Now, if I have a * filter on manufacturer only, I get everything!!

Thanks for your assistance guys 

[#8]

This is a bit frustrating...I thought I had this but I haven't after all 

The first thing I did was to pull the default settings for the _LISTBOX_DEF table from the default installation which looked quite similar to the image nata_ly supplied. 

The problem with this is that I don't always want to search for 30.5mm buttons, sometimes I want 22mm.  Ideally I want to be presented with ALL options 30.5mm AND 22mm so I can decide which I want to use.

The second problem with filtering in this way is when it comes to two and three pole devices. For example a circuit breaker CB1.  The TABLENAME is CB1 and the TYPE becomes "1-pole*" which filters all the single pole devices.  When it comes to a two or three pole circuit breaker, the entry is still CB1 as it is just a duplicate for the 2nd and 3rd pole of the device.  I therefore cannot set TYPE to "2-pole*" or "3-pole*" respectively.

The third issue is when it comes to my power supplies.  In _LISTBOX_DEF, I enter PW but when I do a lookup, the RATING column is filtered however there is no RATING column in the _LISTBOX_DEF table.  I can enter any other column but I am still getting filtering on the RATING column and I don't know where that is coming from - I simply don't want it.

[#9]

I can answer  only the first question now. Just leave TYPE field empty and you'll see all types. But AFAIK make it show 30.5mm AND 22mm is imposible. 

[#10]

RATING in PW = TYPE in _LISTBOX_DEF.