0
Filtering select statements with “choice" fields
This select statement doesn’t work;
select inventory[category = "Oil"].item
when category is choice field but it does when it’s text...
is it possible to do this with choice fields? I tried category.value and category.value but those don’t work.
2 replies
-
You can do it using the text() function...
(select inventory where text(category) = "Oil").itemor(select inventory)[text(category) = "Oil"].item -
ahh. so you have to cast "category" to text for choice fields? Worked perfectly. Thank you.
Content aside
- 5 yrs agoLast active
- 2Replies
- 2283Views