Watch a live product demo 👀 See how Sanity powers richer commerce experiences

How to Match Only a Subset of String in a Word

15 replies
Last updated: Dec 15, 2020
Hello guys, need some help with GROQ. How do you go about matching only a subset of string in a given word?
Say I have data like:


[
  { id: 1, item: "SPTL65-UWW-13" },
  { id: 2, item: "HDTL65-WW" },
  { id: 3, item: "HDTL65-UWW" }
]
My goal is to return only the second item which has specific
WW
and NOT
UWW
.
I have come up with this query:


*[item match "-WW*"]
but this returns no match
*[item match "WW*"]
returns the 3 items though
Dec 9, 2020, 10:48 AM
Hey there! 🙂 Maybe this works for you?

*[item match "*-WW-*"]
Dec 9, 2020, 12:08 PM
Alternatively, if WW and UWW are the only options, you could also try this:
*[!(item match "*-UWW-*")]
Dec 9, 2020, 12:45 PM
Thanks. I’ll try your suggestions.
Dec 10, 2020, 12:59 AM
Thanks
user A
, your suggestion works.
Dec 10, 2020, 1:04 AM
user M
while yours also works, there are other options than those items.
Dec 10, 2020, 1:04 AM
Guys, appreciate the help. Thank you so much
Dec 10, 2020, 1:05 AM
You're welcome 😀 Great to hear that it works!
Dec 10, 2020, 6:20 AM
Hello guys
user A
and
user M
, I’m encountering some problems, unfortunately there are oddities with “match” on array values.
Dec 15, 2020, 6:03 AM
Even if equality
==
doesn’t work 😔
Dec 15, 2020, 6:04 AM
Dec 15, 2020, 6:04 AM
Upon further playing with this, I guess it works as expected. However, I guess what I’m really trying to achieve is to remove the other items in
productConfigurator
that aren’t matching the query above
Dec 15, 2020, 6:32 AM
I think I understand what you need 🙂 One way to do it could be to add the same filter when selecting which attributes you need returned. I played a bit around with the arcade you sent and I think this should do the trick.
However there might be some hidden fancy GROQ feature I don't know of which does this better.

It does remove all the non-matching items from the array though. Hope it helps!
Dec 15, 2020, 6:45 AM
Oh, I could cry right now
user A
. Thank you so much. 🙏
Dec 15, 2020, 6:47 AM
That’s it. Thank you so much. You save me today! God bless. huhu
Dec 15, 2020, 6:48 AM
You're very welcome 😁 Glad to hear it helps!
Dec 15, 2020, 6:52 AM

Sanity– build remarkable experiences at scale

The Sanity Composable Content Cloud is the modern headless CMS that treats content as data to power your digital business. Free to get started, and pay-as-you-go on all plans.

Categorized in

Related answers

Get more help in the community Slack

TopicCategoriesFeaturedRepliesLast Updated
After adding the subtitle and running this code npm run graphql-deploy It does nothingSep 15, 2020
how to limit a reference to just one entry in Studio reference input side versus the default as-many-entries-as-you-fill-in-an-array...Sep 18, 2020
Is it possible to fetch more than one "_type" using GROQ?Nov 2, 2020
I want to add a view with the Structure builder (S.view.component) where I list similar documents based on the title. What...Sep 23, 2020
Is there a structure builder example where the format of each preview for the document list is modified?Feb 3, 2021
I have an array of references to a country schema type but it always just returns NULL values for meJan 30, 2021
Hi, I need help with a query for getting the url of an image asset. Here is what I've been trying, but I only get the _ref...Dec 1, 2020
Sanity UI looks brilliant :smiley: Is something like the current date picker possible at the moment? I’m not sure if anicon...Dec 21, 2020
Hey everyone. I have been coding and may have potentially accidentally deleted something. Does anyone know how to resolve...Dec 26, 2020
Hello everyone and happy new year :raised_hands::skin-tone-2:, I have a problem with outputting Portable Text :disappointed:...Jan 1, 2021

Related contributions

Clean Next.js + Sanity app
- Template

Official(made by Sanity team)

A clean example of Next.js with embedded Sanity ready for recomposition.

Cody Olsen
Go to Clean Next.js + Sanity app

Blog with Built-in Content Editing
- Template

Official(made by Sanity team)

A Sanity-powered blog with built-in content editing and instant previews.

Go to Blog with Built-in Content Editing