Selector for similar titles

[Matzn]

I have some page titles, eg.:

• green tree 1,5 m
• brown tree 1,5 m
• green tree 11,5 m
• brown tree 11,5 m
• yellow banana 0,5 m

To find all 1,5 m trees is my selector ('title%=tree, title%="1,5 m"') , but results are also 11,5 m trees.

My first idea was to exclude "11,5 m"  ('title%=tree, title%="1,5 m", title!%="11,5 m"')

But exclude 1,5 m for 11,5 m searching i get not results ('title%=tree, title%="11,5 m", title!%="1,5 m"')

Yes, i have tested *=, ~=.

What am i missing?

 

[MoritzLost]

This is tricky because for the database "1,5m" is neither a word nor a number, so the comma is treated as a word boundary. This is why can't use selectors that make use of fulltext indexes (*=, ~=). The only option in this case is a slower LIKE comparison (%=), but that isn't aware of word boundaries, resulting in your problem with matching "11,5m" as well as "1,5m".

A quick and dirty solution would be to include the space in your selector, but I'm not even sure if ProcessWire won't filter out any leading/trailing spaces in selector values:
'title%=" 1,5 m"

The best solution is to turn the height of the tree into its own field which can be searched and compared properly. For the height, a simple integer field containing the height in centimeters would be appropriate. Then you can easily search for trees of a certain height, or even within a certain range of heights:

// all trees that are exactly 1,5m high
$trees = $pages->find('template=tree, height_cm=150');

// all trees that are between 1 and 2 meters high
$trees => $pages->find('template=tree, height_cm>100, height_cm<200');

 

[adrian]

And if you want the height to appear after the title in the page tree, you can use the "List of fields to display in the admin Page List" setting on the Advanced tab of the template's settings. And if you want to go even further and convert cms to decimal meters, you can use a hook something like this:

$this->wire()->addHookAfter('ProcessPageListRender::getPageLabel', function($event) {
    $p = $event->arguments[0];
    if($p->template == 'tree') {
        $event->return = $p->title . ' ' . ($p->height_cm / 100) . " m";
    }
});

 

[Robin S]

A dedicated field for height is definitely the way to go, but just wanted to add that for the example titles you gave, the height follows the noun and if that applied consistently then potentially you could include the noun in the search text:

 

[Matzn]

Thanks all for yous ideas. I must had a tittle more explain my project. The page listing all trees und i use the height for a ajax filter function. I wan´t add a new field. It was more about the basic to the selectors.

Hope external links ok. A example: https://gutschein-für.de/preisvergleich/layher-uni-komfort-fahrgeruest-universalgeruest-mit-treppenaufstieg/

@MoritzLost

It would be good, but you dirt solution don´t work 'title%=" 1,5 m". All Whitspaces lost.

@Robin S

Yes, if add a additional word befor it works, but need only "1,5m"/"11,5 m"

[Matzn]

Hui, the solution is very easy:

$matches = $pages->find("selector")->not("selector");

Example for trees:

//all 1,5m no 11,5m
$matches = $pages->find('title%=tree, title%="1,5 m")->not(title%="11,5 m"');

//all 11,5m no 1,5m
$matches = $pages->find('title%=tree, title%="11,5 m")->not(title%="1,5 m"');