Hi,
sorry for late reply, it was night for us.

exactly what you put in the "SQL Custom Where" parameter?

Im trying to use the user list module to show specific users with a specific field in their profile

If you want to show users that have filled some field you can use something like this (example with alias "gender":

gender LIKE "_%"

or

gender IS NOT NULL AND gender <>""

LIKE is a SQL operator: http://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html

ok Thank You for your reply. I dont know anything about sql like that.

I have a field that has a few check boxes to make a selection and I want the person to check the box that applies to them and then I want the easy profile to pull that person to show up on the page according to the check box they have selected.

I dont know if that is possible.

But if its not I would have to make a couple of fields so they can choose from and do it that way.

What would be the exact code to make the fields work? I dont understand what gender is.

Thank You

Hi,

I dont understand what gender is.

"gender" is an example. for example I have a field like this:
Title: Gender
Alias: Gender
Type: Radio
Options:
m|Male
f|Female

to make a list of males I can put in SQL Custom Where something like gender="m"
to make a list of females I can put in SQL Custom Where something like gender="f"
to make a list of all users that have specified Gender field something like gender LIKE "_"
to make a list of all users that have not specified Gender field something like gender = "" OR gender IS NULL

More examples in our docs page at http://docs.easy-profile.com/article/sql-custom-where

I dont know if that is possible.

I think yes, SQL is very flexible.

What would be the exact code to make the fields work?

Please specify
- alias of field
- type of field
- if type is Radio, Checkbox or Select I need also Options
- Explain me what you want to do with User Lists with examples.

otherwise I can not supply the syntax.