Uploaded image for project: 'Magnolia GraphQL'
  1. Magnolia GraphQL
  2. MGNLGQL-167

DOC: Add ILIKE vs LIKE example

    XMLWordPrintable

Details

    • Task
    • Resolution: Done
    • Neutral
    • None
    • None
    • None
    • DevX 47
    • 1
    • Yes

    Description

      As a followup of MGNLGQL-147.

       

       

      Sample

       

      LIKE

       

      {
          tours(filter: "@name LIKE '%vietnam%' OR @name LIKE '%hawaii%'") {
              name
          }
      }

       

      show nothing 

       

      LIKE will show data when input sensitive text. Example

       

      {
          tours(filter: "@name LIKE '%Vietnam%' OR @name LIKE '%Hawaii%'") {
              name
          }
      }

       

      ILIKE will show 2 records 

       

      {
          tours(filter: "@name ILIKE '%vietnam%' OR @name ILIKE '%hawaii%'") {
              name
          }
      } 
      

       

      Checklists

        Acceptance criteria

        Attachments

          Activity

            People

              mdrapela Martin Drápela
              mdrapela Martin Drápela
              DeveloperX
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                Work Started:

                Checklists

                  Task DoR