Support

  1. chen-hui-ching
  2. Support
  3. Wednesday, September 07 2016, 04:47 AM
hello

I have checkbox fields for users to choose their own industry, just like "Injection Molding Machine", "Plastic Blow Molding Machine", "Plastic Extrusion Machinery", and so on...(all industry in Chinese word), please see the screenshot1.png.

and I build a set of menu with each industry menu items to navigate to the Users List (Table) related to the industry, please see the screenshot2.png.

if I want to list the users in industry "Injection Molding Machine", I set the SQL Custom Where in menu item, please see the screenshot3.png.

but why can not select what I want ? there is no result. screenshot4.png

would you help me to solve this problem, because it is a very important requirement from my client.

thank you very much.
chen-hui-ching Accepted Answer
Pro
ok

I solve it by using value in with a global format.

thank you.
  1. more than a month ago
  2. Support
  3. # 1
admin Accepted Answer
Admin
Hi,
maybe some charset problem, SQL Custom Where is sent directly to database query. Try to launch query like this with some tools like phpmyadmin to test:

SELECT * FROM yourprefix_jsn_users WHERE industry LIKE '%"YOURTEXT"%';


Anyway we recommend to use value in with a global format, for example:
injection_moldin_machine|HERE YOUR STRING
plastic_blow_moldin_machine|HERE YOUR STRING
plastic_extrusion|HERE YOUR STRING
....
  1. more than a month ago
  2. Support
  3. # 2
  • Page :
  • 1


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

Request Support

Support is currently Offline

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.