{"id":3637,"date":"2018-06-05T12:15:29","date_gmt":"2018-06-05T11:15:29","guid":{"rendered":"https:\/\/www.threesl.com\/blog\/?p=3637"},"modified":"2022-10-07T16:49:15","modified_gmt":"2022-10-07T15:49:15","slug":"regexes-regular-expressions-in-queries","status":"publish","type":"post","link":"https:\/\/www.threesl.com\/blog\/regexes-regular-expressions-in-queries\/","title":{"rendered":"Regexes (Regular Expressions) in Queries"},"content":{"rendered":"

Reg<\/strong>ular Ex<\/strong>pressions (Regexes)<\/h2>\n

A Regex<\/em> is simply sequence of characters that define a search pattern. <\/i> This pattern is then compared with the target test string and will produce a match if the pattern allows.<\/p>\n

Cradle Queries<\/h3>\n

When retrieving information from the database, Cradle uses a query to filter the data returned. It looks for many matches against different aspects\u00a0 of the item.<\/p>\n

Ending Wildcards and Contains<\/h4>\n

Wildcard<\/em> matches are available on the Identity<\/em> and the Key<\/em> fields The ones most likely to be identifying a hierarchy.<\/p>\n

In the example below a query has been run with three values in the identity field.<\/p>\n

    \n
  1. REQ-1<\/li>\n
  2. REQ-1.<\/strong><\/li>\n
  3. REQ-1*<\/strong><\/li>\n<\/ol>\n

    The results show<\/p>\n

      \n
    1. Only REQ-1 returned\u00a0 and exact match<\/li>\n
    2. REQ-10, REQ-11, REQ-12 …. onwards a text match bringing back the matches greater than the stem. This is really useful for hierarchical numbers, bringing back the children of 1.1 (using 1.1.<\/strong>) say.<\/li>\n
    3. REQ-1, REQ-10, REQ-11 a text match where the stem is followed by zero or more characters. This brings back the stem value too.<\/li>\n<\/ol>\n
      \"Wildcard
      Wildcard Query<\/figcaption><\/figure>\n

      Contains <\/em>matches are available on Name<\/em> and Comment<\/em> fields. They are case insensitive and look for the string of characters anywhere in the component.<\/p>\n

      In the example below<\/p>\n

        \n
      1. regulation<\/li>\n<\/ol>\n

        Results in<\/p>\n