Skip Navigation

[Resolved] Sorting nested tables

This support ticket is created 5 years, 3 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
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Karachi (GMT+05:00)

This topic contains 23 replies, has 3 voices.

Last updated by SteffenM1628 5 years, 2 months ago.

Assisted by: Waqar.

Author
Posts
#1175110

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi Steffen,

Thanks for writing back.

During troubleshooting, I noticed that the parent view "Alle Bewerbungen (parent)" is set to show "Jobs" post types and the child view "Bewerbung (child)" is set to show "Bewerbungen" post types.

The custom field "Bewertung Kandidat" is being used with post types "Bewerbungen" and not the "Jobs". This is why when the parent view is filtered through that custom field for sorting, no results are shown. This is how the WordPress query works and is not something specific to the Toolset Views plugin.

A better way to include a table sorting functionality, in this case, would be to stop using Toolset View's own sorting feature and use a third-party table sorter script, which doesn't involve, database queries.

You'll first remove all the shortcodes "wpv-heading" from your parent view and add regular text headings/labels, which will give you a regular table HTML, but without the sorting feature.

After that, you can include any of the following third-party scripts, to include front-end table sorting:

hidden link
hidden link

For more personalized assistance around custom code/scripts, you can hire a professional from our list of recommended contractors: https://toolset.com/contractors/

regards & a Happy New Year,
Waqar

#1177652

Hey Waqar,

thanks for your answer.
but i need help installing the plugin and getting this to work in wordpress.
I have downloaded the plugin and put it in the js directory in the child theme.
then i put this code in my child functions:

//table-sorter plugin
function my_theme_scripts_sorting() {
    wp_enqueue_script( 'tablesorter', get_stylesheet_directory_uri() . '/js/jquery.tablesorter.js', array( 'jquery' ), 'false', true );
}
add_action( 'wp_enqueue_scripts', 'my_theme_scripts_sorting' );

then i went to the parent view and pasted this code in to test if this is working (hidden link)

 
$(function() {

  // call the tablesorter plugin
  $("table").tablesorter({
    theme : 'blue',

    // sort on the first column and in ascending order PRIOR TO the sort on the selected column
    sortForce: [[0,0]]
  });

});

this is my table html:

[wpv-layout-start]
	[wpv-items-found]
<div class='table-responsive'>
	<table width="100%" class='tablesorter'>
		<thead>
			<tr>
              	<th>Profilbild</th>
				<th>Bewerber</th>
				<th>Job</th>
				<th>Bewerbungssdatum</th>
              	<th>Status Bewerbung</th>
				<th>Bewertung Kandidat</th>
              	<th>Bearbeiten</th>
              	
              	
			</tr>
		</thead>
	<!-- wpv-loop-start -->
	<wpv-loop>
		[wpv-post-body view_template="loop-item-in-jobs-parent"]
	</wpv-loop>
	<!-- wpv-loop-end -->
    </table>
</div>
	[/wpv-items-found]
	[wpv-no-items-found]
	 Nothing found!!!!!!!!!!!!!
	[elementor-template id="1326"]
	[/wpv-no-items-found]
[wpv-layout-end]

but the plugin is not working?!

#1178908

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi Steffen,

Thanks for sharing the update.

I noticed that the "tbody" tag in your final table was repeating for each row/entry when it should be only available once.

Please remove it from your child view "Bewerbung (child)" ( screenshot: hidden link ) and add it to the parent view "Alle Bewerbungen (parent)" ( screenshot: hidden link ) and the sorting will work.

To make sure that the styles from the sorter script library are also loaded, please load the CSS file as well.
( screenshot: hidden link - ref: hidden link )

regards,
Waqar

#1180066

Hey Waqar, thanks for the hint. Everything is working fine.
One single question is still there. How can i use the script only on two pages in wordpress?
Is it possible to change the function of the embed script in my functions.php?

Something like this:
if (is_page('slug1', 'slug2')

Could you help me with that?

Cheers

#1180622

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi Steffen,

Glad that the table sorting is working.

You can use an array of multiple page slugs with "is_page" function, as shown in this example:
https://developer.wordpress.org/reference/functions/is_page/#div-comment-1031


//table-sorter plugin
function my_theme_scripts_sorting() {
	// load only on pages with included slugs
	if( is_page( array( 'slug1', 'slug2', 'slug3' ) ) {
		wp_enqueue_script( 'tablesorter', get_stylesheet_directory_uri() . '/js/jquery.tablesorter.js', array( 'jquery' ), 'false', true );
	} 
}
add_action( 'wp_enqueue_scripts', 'my_theme_scripts_sorting' );

I hope this helps and you're welcome to open a new ticket for a new/different question or concern.

regards,
Waqar

#1181645

hey waqar,

couldn´t save your code because of this error:

syntax error, unexpected ';'
#1182056

Waqar
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi Steffen,

I apologize for the typo and there is a closing bracket missing from line# 5.

Please update it from:


if( is_page( array( 'slug1', 'slug2', 'slug3' ) ) {

To:


if( is_page( array( 'slug1', 'slug2', 'slug3' ) ) ) {

regards,
Waqar

#1184521

nope waqar!

new error message for saving:

syntax error, unexpected ' if' (T_STRING)

#1184524

My issue is resolved now. Thank you!

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.