Open prabhanjali11 opened 11 months ago
Summary I am trying to query some data in postgraphile but the column that I have specified has the value as a dictionary. I need to query the field based on the key inside that.
My Query: query{ table(filter:{ col1: {in : ["basdskd","fdhasj"]} col2: {like: "14%"}}){ nodes{ col1 col2 col3 } } }
Present Output:
{ col1: basdskd col2 : 14.2 col3 : { "a:key1" : val1 "b:key2" : val2 "c:key3" : val3 } }
from here if I need to add a condition/filter to select the rows where "c:key3" value is "val3", How would I proceed with that?
Summary I am trying to query some data in postgraphile but the column that I have specified has the value as a dictionary. I need to query the field based on the key inside that.
My Query: query{ table(filter:{ col1: {in : ["basdskd","fdhasj"]} col2: {like: "14%"}}){ nodes{ col1 col2 col3 } } }
Present Output:
{ col1: basdskd col2 : 14.2 col3 : { "a:key1" : val1 "b:key2" : val2 "c:key3" : val3 } }
from here if I need to add a condition/filter to select the rows where "c:key3" value is "val3", How would I proceed with that?