XF 2.0 finder with REGEXP inxenforo 2

[Paul R]

i try

$Finder->where('myfield', 'REGEXP', $n);

but this show error
[B]InvalidArgumentException:[/B] Operator REGEXP is not valid

switch ($operator)
        {
            case '=':
            case '<>':
            case '!=':
            case '>':
            case '>=':
            case '<':
            case '<=':
            case 'LIKE':
            case 'NOT LIKE':
            case 'BETWEEN':
                break;

            default:
                throw new \InvalidArgumentException("Operator $operator is not valid");
        }

how to use REGEXP with xenforo 2 finder system

 

[DragonByte Tech]

how to use REGEXP with xenforo 2 finder system

Look in src/XF/Finder/ - you’ll find a few files there, they demo how to use expressions.


Fillip

 

[Paul R]

Look in src/XF/Finder/ - you’ll find a few files there, they demo how to use expressions.


Fillip

AT My first post. but it is not support REGEXP

 

[Lukas W.]

You can always use whereSql() if you need something more abstract.

 

[Paul R]

You can always use whereSql() if you need something more abstract.

$threadFinder = $threadFinder->where('user_id', intval($filters['starter_id']));
$thread = $threadFinder->whereSql('myfield REGEXP'.$n);

is this right? @katsulynx

 

[Lukas W.]

You'll probably run into an error because you're missing a space between 'REGEXP' and the actual regexpression, but other than that, it should be fine. If you use double quotes, you can always write variables inside the string instead of concatenating, so you could write "myfield REGEXP $n" or if you want to make use of more complex stuff like properties, wrap it in curly brackets like "myfield REGEXP {$n->someProp}"

 

[DragonByte Tech]

AT My first post. but it is not support REGEXP

$Finder->where('myfield', $Finder->expression("REGEXP '%s' ", $n));


Fillip

 

[Paul R]

$Finder->where('myfield', $Finder->expression("REGEXP '%s' ", $n));


Fillip

thanks my bro