Query for a duplicate field
Hi all,
I need to pull out rows from my shopifyProductVariant table where a column (myField) contains duplicates.
e.g
id | myField | sku
2 | 42 | xyz
3 | 43 | foo
4 | 44 | bar
5 | 42 | abc
..would pull out...
id | myField | sku
2 | 42 | xyz
5 | 42 | abc
I can see Gelly is a thing, but can that only be used on computed fields? I can't see any examples of just pulling this type of query out in code? Thanks.
I need to pull out rows from my shopifyProductVariant table where a column (myField) contains duplicates.
e.g
id | myField | sku
2 | 42 | xyz
3 | 43 | foo
4 | 44 | bar
5 | 42 | abc
..would pull out...
id | myField | sku
2 | 42 | xyz
5 | 42 | abc
I can see Gelly is a thing, but can that only be used on computed fields? I can't see any examples of just pulling this type of query out in code? Thanks.
