How to find a value in all column of an object?

Question

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.

Answer 1

Instead of making dynamic soql why don't you use SOSL.

try this query

List<Sobject> Results = [FIND 'ABC123' IN ALL FIELDS RETURNING customobject(Id, Name)];

or if you have dynamic value then

string searchQuery = 'FIND \'' +searchtext+'*\' IN ALL FIELDS RETURNING customobject(Id, Name)';
Search.query(searchQuery)

and you don't need to write all fields.

You can also find a good example Here. It also handle 2000 records limit in SOSL.