SOQL Dynamic Query on objects ( Dynamic sobject name in soql )

Question

String str = 'Order';

List<SObject> listData = [Select Id From str ];

Can we query like this, I want to query dynamically

Yes, that is possible. Try googling for "Apex dynamic SOQL". Or is there any specific problem you run into? — user254875486
– user254875486, Commented Apr 20, 2016 at 9:58

Ratan Paul · Accepted Answer · 2016-04-20 09:59:04Z

5

Try like this

String str = 'Account';
String strQuery = 'SELECT Id, Name FROM '+str ;
system.debug(Database.query(strQuery));

In your case

String str = 'Order';
String strQuery = 'SELECT Id, Name FROM '+str ;
List<SObject> listData = Database.query(strQuery);

answered Apr 20, 2016 at 9:59

Ratan Paul

22.9k14 gold badges59 silver badges100 bronze badges

1 Answer 1