I need to control the FieldSets in WHERE clause. For instance in Account Fieldset added name and type field, I need to control this on WHERE clause in SOQL dynamically like "SELECT id from ACCOUNT where name=(Account Fieldset Name Value) and type=(Account Fieldset Type Value)".
Thank you in Advance!

Hi Everyone,

 

I want to create a Dynamic SOQL using Field set. What i have is, i have two fieldsets Search_Criteria and Search_Results.

First fieldset is for searching purpose and other one is associated with a PageBlockTable to display result.

I am confused how to create a SOQL command which can filter the result using fieldset values.

 

Thanks in advance,

Nitin