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?
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.
Ace User since 1998
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?
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
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.