I’ve been searching forum for this answer (as I recall, it did exist, but…) What are maximum lenghts for field filters in 3.60? I have found that on Code (20) field, maximum length is 591 character in filter. On text field, it’s bigger. Does anybody has a list of values?
As far as I know, it should be 1024 characters.
3.60? I tested on Code field and it really accepts not more that 591 ch.
Its really not so simple, I’m sure there is a formula somewhere, but it is not just a simple number. If you have a code20 field, and apply a filter that consists of a lot of 20 Charachter fields, then you can go to about 820 characters (by this I mean a filter like ‘A1234567890123456789|B1234567890123456789|C1234567890123456789 …’ But if the filter consists of shorter components like ‘A12|B12|C12|D12…’ then you can apply more components, but the total string length will be much shorter, probably about 490 characters total. So I think you need to know the type and length of the field, and the length and number of filter components. Sorry this is not going to be easy. I can’t even work out what is a “safe” number to work with.
Remember also that you have 250 something filtergroups as well. So you can set filter on every group.
That’s not a bad idea. If you could add filters till you get a length error, then change groups… Ahmed, have you done this? A code snippet would be usefull.
Nope. Never needed to. I usually use Mark filter.
Mark filter seems ok as a solution sometimes and specially with this kind of problems… David, when you say “Formula” do you think that some kind of formula really exists or it’s metter of some kind of memory buffer length?
No I mean that I am sure that somewhere is a formula that will let you calculate is a filter is too long or not, but I have no idea what it is. In any case I would never use a filter this long, I would find another way to do it. If your filter needs to be this long, you may want to reconsider the structure of you database. If you are going to use marks, be very careful with keys and filters, since you can really slow things down. Also make sure you know where your temp files are being stored.
actually, it was customer request. He wanted (who knows why…) to apply filter that was 620 char long to Code (20) field… Reason why I posted this question here on Develop forum was that I wanted to know, too, is there a table or formula for values… Anyway… thx.