The Joomla! Forum ™

Download

Demo


Board index » Joomla! Development Forums » Joomla! Development » Joomla! 2.5 Coding

Forum rules


Please use the mailing list here: http://groups.google.com/group/joomla-dev-general rather than this forum.



Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 
  Print view Previous topic | Next topic 
Author Message
ianwattb
PostPosted: Sun Apr 29, 2012 1:30 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Feb 27, 2012 12:22 pm
Posts: 7
Afternoon,

I've currently got an admin view that lists a table of results (approx 400 records) which gets paginated. I want to be able to filter this view depending on a single column.

I thought I could achieve this via creating a dropdown box with a foreach line but it appears to only return the paginated results that am viewing and not all the values in the array.

This probably could be achieved via a static filter but I cant find anything that would point me in the direction of coding this into my extension.

Could someone give me some pointers in the right direction please?
Top
 Profile  
 
drewgg
PostPosted: Mon Apr 30, 2012 4:33 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Oct 30, 2008 7:27 pm
Posts: 149
You'd need an additional query to the database to get all the distinct values of that column. Make sure that column is indexed in your db and it shouldn't hurt too much.
Top
 Profile  
 
ianwattb
PostPosted: Tue May 01, 2012 10:35 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Feb 27, 2012 12:22 pm
Posts: 7
Thank you drewgg - I will give it a shot this evening.
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 


Board index » Joomla! Development Forums » Joomla! Development » Joomla! 2.5 Coding

Who is online

Users browsing this forum: No registered users and 16 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group