How to find field_name/api_name
name for any object
that contains a value?
I'm working on a object that has dozens of fields but I'm after finding out particular value belongs to which field name.
for an example:
I have a value ABC123
in MyCustomObject
one possible way I can do is something like this:
SELECT field_name FROM MyCustomObject WHERE field_name = 'ABC123' || field_name2 = 'ABC123' etc... but this is very tedious.