Bookmark wildcard selection, not specific values

[#1]

I have an IPAddress field and would like to bookmark the ranges;

10.144.* and 10.244.*

If I bookmark the current selection, it remembers the exact IPAddress values selected and not the ranges.

How can I get round this?

[sundarakumar]

u could use the same format in a list box like 10.144.* and press enter this will select all the values that are in this range, then u can add bookmark which will ahve all the selected value.

-sundar

[#3]

Thanks. But how would that work with two ranges at the same time?

[sundarakumar]

I dont think it is straight away possible

in search box type 10.144.* and press enter it will select all the associated 10.144 and again search for 10.244* but this time hold control and press enter.. this will select both..

-Sundar

[tresesco]

You can simply type in both with AND like:

[#6]

10.144* AND 10.244*

that doesn't seem to work

[#7]

My recommendation here is to think about this in a slightly different way.  Store (or convert) the IP address as a long Integer and search using a function encapsulation of an IP address Range...

We store all our IP addresses in the underlying database as integers using a single function.  Then you can do all the usual filtering, sorting etc using the integer value.

Here is our SQL function

[jonathandienst]

Hi

I think its an OR selection rather than an AND. You can type this in the list box:

     (10.144.*|10.244.*)

HTH

Jonathan

[tresesco · Accepted solution]

try without wild card

[jonathandienst]

If you bookmark after entering this filter, the bookmark will contain the filter as entered and will dynamically filter based on the wildcards: