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 1:41 pm
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.