Page 1 of 1

Help with regex search / visual filter

Posted: 03 May 2024 17:08
by 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!

Re: Help with regex search / visual filter

Posted: 03 May 2024 17:57
by 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...

Re: Help with regex search / visual filter

Posted: 03 May 2024 19:11
by n00bs
>ex1: would then we the name of the column?

Re: Help with regex search / visual filter

Posted: 03 May 2024 19:16
by 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