Hi,
I recently discovered and purchased Easy Profile and am truly amazed at all the things it can do, thank-you!
I love the Custom SQL WHERE feature but unfortunately the module restricts you to ordering by one field only.
Could we have a module without the ordering restriction where I can include an "ORDER BY" parameter in the Custom SQL WHERE field to specify a custom order (e.g. order by multiple fields)?
Thanks and keep up the good work.
Neil
Support
-
webilicious
- Features Request
- Wednesday, February 17 2016, 04:05 AM
Hi,
"where" and "order" should be separated parameters. the complete query is build by Joomla JDatabase class and this require 2 different parameters, JDatabase allow you to use a text query but this way is not possibile because complete "where" is build by different files and classes.
Now to fit your requirement you can create a field called user list order, this field should be hidden in profile,edit profile and registration pages. With this configuration you will have this field available only on backend.
Anyway in order to improve our features we will consider your suggestion for future
, but this is not a priority.
"where" and "order" should be separated parameters. the complete query is build by Joomla JDatabase class and this require 2 different parameters, JDatabase allow you to use a text query but this way is not possibile because complete "where" is build by different files and classes.
Multiple sort fields would be an improvement but an option to disable the Order option so that SQL syntax can be used in the WHERE statement would be even better (see attachment as an example).I agree, but this is not user friendly. Solution with 3 levels of order fit 99,9% of cases. Keep in mind that Easy Profile is a profiler component (not directory component).
Now to fit your requirement you can create a field called user list order, this field should be hidden in profile,edit profile and registration pages. With this configuration you will have this field available only on backend.
Anyway in order to improve our features we will consider your suggestion for future
, but this is not a priority. 
[email protected]
Accepted Answer
Hi,
this is not possible with a simple way, so we will add this in our next release
Thanks for your suggestion.
this is not possible with a simple way, so we will add this in our next release
Thanks for your suggestion.
[email protected]
Accepted Answer
webilicious
Accepted Answer
webilicious
Accepted Answer
- Page :
- 1
There are no replies made for this post yet.
However, you are not allowed to reply to this post.
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.