0

I am working with quicktable queries and everything seems to be fine.

Now I want to perform queries using like operators. For instance in PHP I can do something like:

$data ='content to search';

$stmt = $db->prepare('SELECT * FROM members where name like :name OR email like :email limit 20');
$stmt->execute(array(
':name' => '%'.$data.'%',
':email' => '%'.$data.'%',
));

Now in quick table, I have tried using CT, EX or HAS parameter etc with OR Operators. Only CT gives nearby result but not exact as per code below.

//Email = 7
//name =8

{
    "from": "tableId",
    "where": "{7.CT.'nancy@gmail.com'}OR{8.CT.'nancy'}"
}

Is there any way I can obtain a better search with like operators with Quickbase. The documentation here does not cover that.

halfer
  • 19,824
  • 17
  • 99
  • 186
Nancy Moore
  • 2,322
  • 2
  • 21
  • 38

1 Answers1

2

CT is the closest string comparison operator in Quick Base to LIKE in SQL, but since you can't use wildcards in Quick Base queries you might need to group multiple query strings to achieve the same result. The is also a SW operator that can sometimes come in helpful for comparing parts of a strings.

Erich Wehrmann
  • 464
  • 2
  • 11
  • 1
    SW is also okay but CT seems to be the best option. I brings out my result out of loop and is working great. Thank you. Am also upvoting it as the best answer so far – Nancy Moore Oct 27 '20 at 12:10