[MGNLGQL-167] DOC: Add ILIKE vs LIKE example Created: 19/Sep/23  Updated: 18/Oct/23  Resolved: 27/Sep/23

Status: Closed
Project: Magnolia GraphQL
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Neutral
Reporter: Martin Drápela Assignee: Martin Drápela
Resolution: Done Votes: 0
Labels: None
Σ Remaining Estimate: Not Specified Remaining Estimate: Not Specified
Σ Time Spent: Not Specified Time Spent: Not Specified
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: PNG File Screen Shot 2023-09-20 at 08.39.52.png     PNG File Screen Shot 2023-09-20 at 08.40.13.png    
Sub-Tasks:
Key
Summary
Type
Status
Assignee
MGNLGQL-168 DOCSub: Add ILIKE vs LIKE example (dr... Sub-task Completed Martin Drápela  
MGNLGQL-169 DOCSub: Add ILIKE vs LIKE example (rv) Sub-task Closed Oanh Thai Hoang  
Template:
Acceptance criteria:
Empty
Task DoR:
Empty
Epic Link: GraphQL Phase 2
Sprint: DevX 47
Story Points: 1
Team: DeveloperX
Work Started:
Approved:
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
    }
} 

 


Generated at Mon Feb 12 05:53:14 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.