Have your say in Community Polls: What was/is your greatest motivation to start your own business?
Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

Re: query with more than one param doesnt work

query with more than one param doesnt work

nikhilyayloh
Shopify Partner
4 0 0

Hi, 

 

I am trying to fetch products which have positive inventory quantity among the list of product ids. 

But my query below does not return any results. 

{
        productVariants(first: 10, query: "(inventory_quantity:>0) AND (product_ids:7483474804973,7483550007533)") {
            edges {
                node {
                    id
                    image {
                        url
                    }
                    product{
                        id
                    }
                    availableForSale
                    inventoryQuantity
                    price
                    selectedOptions {
                        name
                        value
                    }
                }
            }
        }
        }

 

But if i would run the above query with either inventory condition or product_ids only, then i get results. 

What am i doing wrong here?

 

Big thanks for help.

Replies 6 (6)

Liam
Community Manager
3108 344 895

Hi Nikhilyayloh

 

Can you try:

query: "(inventoryQuantity:>'0') AND (product_ids:xxxx,xxxx)")

The above worked when I tested in the graphiql app.

Liam | Developer Advocate @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit Shopify.dev or the Shopify Web Design and Development Blog

nikhilyayloh
Shopify Partner
4 0 0

Hi Liam, 

It might execute and give results but if you increase the inventory value from 0 to say 100K, you will see that it doesnt filter out data. So that condition itself is not used. Plus inventory_quantity is the query field mentioned in the documentation.

 

Liam
Community Manager
3108 344 895

I see what you mean - other filters like vendor appear to work as expected alongside product_ids but inventory_quantity is not - I'll dig into this a bit more.

Liam | Developer Advocate @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit Shopify.dev or the Shopify Web Design and Development Blog

Liam
Community Manager
3108 344 895

Hi Nikhilyayloh,

 

We've identified this is a bug on our side and will be shipping a fix asap.

Liam | Developer Advocate @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit Shopify.dev or the Shopify Web Design and Development Blog

nikhilyayloh
Shopify Partner
4 0 0

Hi, 

Is there a timeline for this fix? 

ShopifyDevSup
Shopify Staff
1453 238 525

Hey @nikhilyayloh

 

Thanks for checking in. The issue hasn't been resolved as of yet. Currently we don't have firm deadline or timeline for a fix but it is still on the radar with our development teams. 

 

Kind Regards,

- Kyle G.
 

Developer Support @ Shopify
- Was this reply helpful? Click Like to let us know!
- Was your question answered? Mark it as an Accepted Solution
- To learn more visit Shopify.dev or the Shopify Web Design and Development Blog