[ComboBox] Have 2 queries one simple one advanced

[ComboBox] Have 2 queries one simple one advanced

  
Hi ,

Is It possible to have one combo box with 2 diferent queries? i wanted my combo box to be filled, if input parameter is null will all of the table records, otherwise fill with an advanced querie.

Best Regards
Hi,

That parameter can be an input to the query and this way you will make only one query.

It already have it as input in the query, the issue is that there are no "if" in SQL so i can't check if it's null or not.
you can make in the where clause:
(@param is null and {entity}.[attr] = 'x' or @param is not null and {entity}.[attr] = 'y' )
Nuno Rolo wrote:
you can make in the where clause:
(@param is null and {entity}.[attr] = 'x' or @param is not null and {entity}.[attr] = 'y' )
 I ll try that way, thank you very much Nuno

Cheers