if I have an item select field, can I get the text...
# suiteqld
David B
10/20/2021, 3:29 AMif I have an item select field, can I get the text value of that field without joining to the item?
Can't find it in the docs, but my intuition would be something like:
Copy code
SELECT
customrecord_example.id,
customrecord_example.custrecord_itemfield.text
FROM
customrecord_examplequestion answered 1
m
michoel
10/20/2021, 3:50 AMBUILTIN.DF(customrecord_example.custrecord_itemfield)d
David B
10/20/2021, 3:51 AMAHA! thanks, I'd seen that around but didn't know what it was for
m
michoel
10/20/2021, 3:51 AMmichoel
10/20/2021, 3:52 AM4 Views