Support

    You are here:  
  1. Home
  2. Support
  3. Tab Titles Show with Bullets
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
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 7:58 am
Add a reply View Replies (5)

Resolved Select field with DB table lookup

  1. dr.sus
    dr.sus
  2. Support
  3. Wednesday, October 14 2015, 06:21 PM
Hi,

I asked this question in the past, but I have to clear something up.
I have a select field in my EP that looks for values in a DB table.
The table contains roughly 20,000 rows.
Problem is that this multiple select field loads the whole table, needless to say it slows things down when editing profile.
My question: is there a way to not preload the table?

Thanks.
Accepted Answer
admin
admin Accepted Answer
Admin
I'm sorry but as we said is a very complex thing, this requires a lot of JavaScript and PHP knowledge.

You need:
- write PHP code to retrieve options from DB in JSON format
- call jQuery UI framework from Joomla API, docs at https://docs.joomla.org/J3.x:Javascript_Frameworks
- include Jquery Autocomple Javascript library (I don't know if already included in UI Joomla framework)
- load javascript code with your customization

Our tip is only point of start.
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (5)
admin
admin Accepted Answer
Admin
Hi,
Sorry this is not possible. Select field is provided directly by Joomla API.

Select field is a simple HTML select input, all features like search and UI are provided by JQuery choosen javascript library (built-in Joomla), so you have 2 problems that make delays:
- Download webpage with 20000 occurrences
- Browser need to parse all options via javascript
  1. more than a month ago
  2. Support
  3. # 1
dr.sus
dr.sus Accepted Answer
I figured that much.
Is there any workaround? Can I introduce a search box in EP that would look for a table values and act as if it was a multiple input field?
Many thanks.
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
Is there any workaround?
Yes but is complex, you can use a simple text field and add some javascript code to make the autocomplete with options taken from ajax requests.

Some docs tip:
- https://jqueryui.com/autocomplete/#multiple-remote
  1. more than a month ago
  2. Support
  3. # 3
dr.sus
dr.sus Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 4
dr.sus
dr.sus Accepted Answer
btw, I sent you a PM re this issue a couple of hours ago and would greatly appreciate a reply. Thanks.
  1. more than a month ago
  2. Support
  3. # 5
  • 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.