questbahlin Red Ribbon

B

I love this trick - thank you for sharing! Great way to get around using a table join just for the sake of getting the descriptive value.

False

B

B

True

C

A

True

Certainly - here you go @Michelle Jabanes-Oracle :)

C

D

B

C

B

B

B & D

Thanks for the feedback @Shiela Marie Villaluz-Oracle :) I'm going to proceed with this method and will report back with any feedback once we have a final solution in place. Not opposed to other ideas if anyone out there in the community has found a better way to do this - please share, I'm all ears!

Great writeup @Richard James Uri-Oracle ! I would add this tool that is super useful to me when using SuiteQL: Tables Reference (this is a button in the top-right in SuiteQL) - gives you a great documentation source of all tables and their fields, and also gives join suggestions. Even includes custom fields you've created.…

C

B

B

C

A

False

A

True

B

C

True