[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: |
|
|||||||||||||||
| Sub-Tasks: |
|
|||||||||||||||
| Template: |
|
|||||||||||||||
| Acceptance criteria: |
Empty
|
|||||||||||||||
| Task DoR: |
Empty
|
|||||||||||||||
| Epic Link: | GraphQL Phase 2 | |||||||||||||||
| Sprint: | DevX 47 | |||||||||||||||
| Story Points: | 1 | |||||||||||||||
| Team: | ||||||||||||||||
| Work Started: | ||||||||||||||||
| Approved: |
Yes
|
| Description |
|
As a followup of
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
}
}
|