Easy Profile - Joomla Extension

Support

Support is currently Offline

Support Offday

Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!

Official support hours:

Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Sunday 11:57 am

Add a reply View Replies (4)

Resolved I need help with custom sql where

Ediamond25
General
Wednesday, May 11 2016, 12:52 AM

I need help with custom sql where. Im trying to use the user list module to show specific users with a specific field in their profile and its not working. I tried putting in the codes shown and nothing. {user field_alias} But that doesn't work when I put in the field alias for what Im looking for. Some one please help me. Its been driving me crazy.

Responses (4)

admin Accepted Answer

Admin

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 "_%"

gender IS NOT NULL AND gender <>""

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

more than a month ago
General
# 1

Ediamond25 Accepted Answer

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

more than a month ago
General
# 2

admin Accepted Answer

Admin

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.

more than a month ago
General
# 3

Ediamond25 Accepted Answer

Content Protected

more than a month ago
General
# 4

Page :
1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

Request Support

Ask a Question

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.