Chapter 7: create Search term query

yoyohu · April 15, 2018, 8:12pm

How can I create a ‘contains’ query? And add this to the group query?
so you can search for ‘my’ or ‘god’ instead of Oh+My+God

0xtim · April 15, 2018, 8:58pm

@yoyohu import FluentSQL and then you should be able to do

try or.filter(\Acronym.long ~~ searchTerm)

yoyohu · April 15, 2018, 9:12pm

Correct!
thanks!
Where do I find this in the docs?
i have missed this operator at:
https://docs.vapor.codes/2.0/fluent/query/

yoyohu · April 15, 2018, 9:14pm

0xtim · June 21, 2018, 11:11am

Yep will be coming with the release! But the source and tests are the best place

pyae · December 4, 2018, 8:46am

“~” operator not working now. How do you do now?

shogunkaramazov · December 4, 2018, 9:06am

@0xtim Can you please help with this when you get a chance? Thank you - much appreciated! :]

pyae · December 4, 2018, 9:27am

It can be solved with “~=”. Hope this can help someone someday

shogunkaramazov · December 4, 2018, 9:31am

@pyae Thank you for sharing the solution - much appreciated! :]