Skip Navigation

[Resolved] Column sorting, filters and pagination not working

This support ticket is created 8 years, 7 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 8:00 – 17:00 8:00 – 17:00 8:00 – 17:00 8:00 – 17:00 8:00 – 17:00 -
- - - - - - -

Supporter timezone: America/Sao_Paulo (GMT-03:00)

This topic contains 13 replies, has 2 voices.

Last updated by nathanW-4 8 years, 5 months ago.

Assigned support staff: Adriano.

Author
Posts
#283987
Screen Shot 2015-02-18 at 5.05.52 pm.png

Hi,

I need to build a view with the functionality pictured.

Currently I have it displaying specific post types - filtered to a specific taxonomy set by shortcode attribute, pagination works (although it's annoying that I can't change the style, where can I update the style or create my own style for pagination?), I also have the items displaying in filterable tables/columns.

The problem is, sorting the columns does nothing - it's meant to re-sort asc or desc but it just reloads the page. It also seems to just drop the taxonomy filter whenever it feels like it, if there are several items in the query the taxonomy one often gets ignored.

Lastly I need to create a filter by post date range - I can't see a way to do this for non custom fields.

I'm sure it's pretty simple I just don't know the best way to go, if you could help me to achieve this layout that would be much appreciated.

Thanks

#284368

Hi Nathan,

The style of the pagination elements could be styled through the CSS editor section when you are editing your View.

I need to request temporary access (wp-admin and FTP) to your site in order to be offering better help. You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it.

#287057

Hi,

I've been able to style the pagination how i'd like to - my only issue now is the text filter, I want to have a text filter also available to be able to filter by title by Ajax just like the pagination. When I put this in, the search doesn't work, or when it does after a search the pagination is replaced with a search box.

Pagination needs to go down the bottom, search needs to go up the top. What is the best way to achieve this?

The sort by table column also doesn't work.

Thanks

#287199

Any updates on this?

#287679

I need to request temporary access (wp-admin and FTP) to your site in order to be offering better help. You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it.

#293194

Hi Nathan,

My apologies the long delay. This will need some PHP code in order to extend Views functionality, I'm working on it. Is that date a post date of custom field date?

#293815

Hi,

Design has changed slightly, because the sorting was so buggy we've removed it and replaced it with a select menu.

The posts use post-date, but I was in middle of using a filter to duplicate that into a custom date field on save so we could use either, this is a bit annoying and seems pointless so if there's a way to use post date that would be ideal.

The site will need to be completed in the next few days so we may have to continue and finish without your updates, if you can send through your concepts maybe I can build them?

Thanks

#294054
Captura de Tela 2015-04-07 às 14.30.03.png

Hi Nathan,

I understand. I've just found that functionality in Views, you could select the option "BETWEEN". It will show two fields for date. Is that enough for you?

Please let me know if you are satisfied with my reply and any other questions you may have.

Regards,

Adriano Ferreira

#294138

Hi Adriano,

I did see that, I couldn't see any ability to filter by post date only custom fields - which is a huge let down, now I have to go through all this unnecessary work of creating a custom field and a filter to duplicate the data into it.

Is there any way to extend views to make it filter by post date using the already available features?

Thanks

#294372

Hi Nathan,

I bring good news, Views 1.8 will contains that functionality! This has been a recurring feature request for Views. Until now, any query filter related to dates could only be done over Types date custom fields. WordPress added a nice API for filtering by native date information on posts, both published date and last modified date, but Views had not a GUI for that. Now it gonna has.

We are planning to release that next week, but I can prepare a development patch for you, if you wish to test it.

#294462

Hi Adriano,

Excellent! Keep up adding new features and listening to your customers needs and Views & Types will continue to be widely used, we've just moved to WordPress and types and views has been a dream.

If you could send me through a development patch to add this functionality that would be much appreciated!!!

Thanks

#294466

Hi Adriano,

Will filter by post type be available in this update as well? Need it for the advanced search.

Cheers

#294573

Hi Nathan,

Glad to hear that feedback. Unfortunately a filter by post type is still pending. But we can extend it through Views PHP filter.

This thread has been marked as resolved. Please open a new one if you still need some assistance.

#294597

Hi Adriano,

Please email me the beta version of views that lets me use the post-date - nathan@grindstone.com.au

I marked the thread as resolved by accident, not resolved until I get that beta 😉

Thanks