u/Key-Shoe5808

Query Item Options?

Anyone ever find a way to query the Item Options that are available for a given item? If you look at the item record, there is a field called itemoptions, but I can't query it using SuiteQL, N/search, Saved Search...

There's also a record type called itemoptioncustomfield...but that's not queriable in SuiteQL or N/Search or Saved Search either. I can export the XML definition via SDF CLI...but that doesn't include the list if item records it's enabled on.

This is maddening. I can see everything in the UI, in multiple places, but the only way I can find to access the values programmatically is using record.load and currentRec.getText({fieldId: 'itemoptions'}). That doesn't make it available in searches, but it at least opens up possibilities. I'm just looking for an alternative to running something on each item record to copy these to a queriable field.

reddit.com
u/Key-Shoe5808 — 1 day ago