Help with regex search / visual filter

[n00bs]

Hi! I'm still pretty new to XYplorer and I try to use it as much as I can! I'm currently trying to set up a searchable database, for arguments sake, let's say it's for dogs that are up for adoption.

I am stuck with the following regex problem: Let's assume that I made a new custom column (numbers) in which I enter each dog's weight. I now want to show a client only midsize dogs and want to filter those out that aren't in that weight range. How would I formulate the regex query so it only shows dogs that weigh between 30 kg and 60 kg?

Thank you in advance!

[highend]

Afaik visual filters don't support regex for other columns than the name so it wouldn't work that way...

In theory the pattern would have looked like this: >ex1:^([3-5][0-9]|60)$ or in whatever extra column the data is...

[n00bs]

>ex1: would then we the name of the column?

[highend]

How you name the column isn't relevant, in the example it's the extra1 column = ex1 and the > isn't part of the name, it's to indicate that's a regex pattern