Support

    You are here:  
  1. Home
  2. Support
  3. tim-online
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. 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: Thursday 5:14 pm
Add a reply View Replies (11)

Resolved Can I use any field in the Custom SQL from Easy Profiles to filter a contact list?

  1. joenglesson
    joenglesson
  2. General
  3. Tuesday, February 18 2014, 09:59 PM
I want to be able to filter a group of contacts based on a custom field I have created in Easy Profile. Is this possible? I see how I can do it based on a user group but what about a field?

This is the Field: ML# (or Part 2 Grad) (Alias: ml-number-test)
http://www.gtgradweb.com/index.php/current-ml/contacts
Responses (11)
admin
admin Accepted Answer
Admin
Hi,
Yes, you can use any field alias to build your custom sql where.
In addition of field alias you can use group_id and user_id.
  1. more than a month ago
  2. General
  3. # 1
joenglesson
joenglesson Accepted Answer
Pro
Do I need the underscore instead of spaces if I use field alias?
  1. more than a month ago
  2. General
  3. # 2
joenglesson
joenglesson Accepted Answer
Pro
How do I use it in the statement if my field alias is "ml-number-test" and the value I want to filter is "ML2"?
  1. more than a month ago
  2. General
  3. # 3
admin
admin Accepted Answer
Admin
Have you tried this:
ml-number-test = "ML2"

If not work use this:
`ml-number-test` = "ML2"
  1. more than a month ago
  2. General
  3. # 4
joenglesson
joenglesson Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. General
  3. # 5
admin
admin Accepted Answer
Admin
ML2 is the value of option or is a text?
In the custom where you must insert a value.

Still, the quote of fields in Sql are with ` not '

If you want we do for you but I have tried your site details and not work! Can you resend me please.
  1. more than a month ago
  2. General
  3. # 6
joenglesson
joenglesson Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. General
  3. # 7
admin
admin Accepted Answer
Admin
Ok,
Now work, the problem is due to wrong configuration of option of your field, the correct is for example:
ml1|ML1
ml2|ML2
Value|text

The option field works even with your config but the data stored in D are a little unpredictable.
  1. more than a month ago
  2. General
  3. # 8
joenglesson
joenglesson Accepted Answer
Pro
Thank you so much!!!
One more question - for the Select Field, are you saying I should put the values in like this:
ml1|ML1
ml2|ML2
Value|text

What will the user see? Just the ML1?

Thank you!

Jo
  1. more than a month ago
  2. General
  3. # 9
admin
admin Accepted Answer
Admin
Yes,
The user show ML1.
You can still use a joomla constant language for text(managed from joola language override).
  1. more than a month ago
  2. General
  3. # 10
joenglesson
joenglesson Accepted Answer
Pro
I tried it and it works! Thank you!
  1. more than a month ago
  2. General
  3. # 11
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

Request Support

Support is currently Offline
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

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.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.