Dear All,
I have a little odd requirement: My rt (3.4.1 postgres debian) users
want to search / match tickets by last digits.
Example:
Search for last digits 13 should match
13
113
213
…
12413
54813
…
I have tried to build an appropriate query string using something like:
$m->comp("/Search/Results.html", Query => “Id LIKE $query AND ($status)”);
or matching regex
$m->comp("/Search/Results.html", Query => ‘Id ~ ‘’.$query.’$’ AND
($status)");
but this does not work. Is this due to the constraints of TicketSQL or
am I missing something else?
Is there someone who could point me in the right direction?
Best regards and many thanks for any help in advance
Tobias Heinz