You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
How it is possible to generate a group by statement related to a JSON field?
For an order by we get the sqljson package and we can do something like Order(sqljson.OrderValue(article.FieldMetadata, sqljson.Path("tag"))), considering metadata is a JSON object with a tagkey.
For the GroupBy I don't see how to do that easily, the only thing easy to do is to provide the whole field like that GroupBy(article.FieldMetadata).
The text was updated successfully, but these errors were encountered:
Question
How it is possible to generate a group by statement related to a JSON field?
For an order by we get the
sqljson
package and we can do something likeOrder(sqljson.OrderValue(article.FieldMetadata, sqljson.Path("tag")))
, consideringmetadata
is a JSON object with atag
key.For the
GroupBy
I don't see how to do that easily, the only thing easy to do is to provide the whole field like thatGroupBy(article.FieldMetadata)
.The text was updated successfully, but these errors were encountered: