I’m trying to do a search on sticky notes using SuiteQL, where the owner OR one of the allowed entities is a certain id. “Allowed Entities” is a multiselect of type Entity with id

custrecord_sn_allowed_entities

. I assume there is a mapping table somewhere for this, so I tried joining to

map_customrecord_stick_note_entity

but that doesn’t seem to exist. Anyone know how to look up the names of tables in SuiteQL if they are from a bundle and don’t appear in Records Browser?

Check the Records Catalog

hm. Still not sure what the name of the mapping table would be.

map_customrecord_stick_note_job

didn’t work

@jen You're welcome 😄