I need some help formulating a query to work with the module. I've got the query to pull a list of names (Team Leads and their direct reports) by using the DNN UserID to determine if the person is a team lead or not. That part works well - but, when I select the 'All' option, I don't get anything as the filter is passing a 0 into the portion that looks up the user information.

Is is possible to wrap the query in an if else so that when the userID field is equal to 0 that it bypassed the check for the userID? If so, how could I check for the value - is it still [PARM:fieldname] - ie. if [PARM:fieldname] or ??

Thanks in advance.