Add to archive sorting

Hi again, so I got this code implemented starting at line 519:

	public function html_order_by( string $default_value = 'post_date' ): string {
		$html_wrapper = [
			'<div class="courses-order-by-wrapper">' => '</div>',
		];

		$values = apply_filters(
			'learn-press/courses/order-by/values',
			[
			    'tags'            => esc_html__( 'Page Number', 'learnpress' ),

and that has added the option in the dropdown – great!
Sorry to be dense, but I don’t see where a query is built other than for the html_count_students() function which has some SQL for getting the total students of a given category. Where do I hook to modify the query which is I assume being run in the render_courses function to add the new tag order by requirement?

Thanks for your support!

For anyone following along in the future, I got the new option added and the pricing ones removed (since all our courses are free) using the hook:

function oht_create_new_tag_sort_filter( $arr ) {
  $arr = array(
         //New sort option
         'tags'            => esc_html__( 'Page Number', 'learnpress' ),
         //Remaining used sort options
	 'post_date'       => esc_html__( 'Newly published', 'learnpress' ),
	 'post_title'      => esc_html__( 'Title a-z', 'learnpress' ),
	 'post_title_desc' => esc_html__( 'Title z-a', 'learnpress' ),
	 'popular'         => esc_html__( 'Popular', 'learnpress' )
   );
   return $arr;
}
add_filter( 'learn-press/courses/order-by/values', 'oht_create_new_tag_sort_filter', 10, 1 );

Let me know if this isn’t what you had in mind. I will look at the query hook when I get more time and report back.
Thanks for your support!
John

Brianvu-tp,
No worries! I am on to the query part now and need some further clues. It’s a bit hard to pull out the full query with all the joins but my intended functionality based on the tag sort option is this:

  SELECT * FROM wpp9_terms
  WHERE slug LIKE 'page-%'
  ORDER BY SUBSTR(slug,6,2)+0; 
  --note str to num coercion to get 1 before 10, etc... 

Which produces the ordered list of tags based on the prefix “page-“:

| term_id | name      | slug    | term_group |
|---------|-----------|---------|------------|
| 270     | Page: #3  | page-3  | 0          |
| 269     | Page: #4  | page-4  | 0          |
| 271     | Page: #6  | page-6  | 0          |
| 277     | Page: #7  | page-7  | 0          |
| 261     | Page: #8  | page-8  | 0          |
| 263     | Page: #9  | page-9  | 0          |
| 265     | Page: #10 | page-10 | 0          |
| 268     | Page: #12 | page-12 | 0          |
| 280     | Page: #14 | page-14 | 0          |
| 283     | Page: #15 | page-15 | 0          |
| 337     | Page: #16 | page-16 | 0          |
| 274     | Page: #17 | page-17 | 0          |
| 336     | Page: #18 | page-18 | 0          |
| 333     | Page: #19 | page-19 | 0          |
| 338     | Page: #20 | page-20 | 0          |
| 335     | Page: #21 | page-21 | 0          |
| 339     | Page: #22 | page-22 | 0          |
| 106     | Page: #23 | page-23 | 0          |
| 287     | Page: #24 | page-24 | 0          |
| 289     | Page: #26 | page-26 | 0          |
| 290     | Page: #27 | page-27 | 0          |

This is what would order the courses output when sorting on the new page number option. I think I see where to hook the order by (inc/Models/Courses.php: function get_courses) but I think there is more setup that needs to happen b/c simply adding a switch statement:

case 'tag_ids':
  $filter->order_by = $filter->tag_ids;
  $filter->order    = 'ASC';
  break;

doesn’t achieve anything but a ‘no records found’…

Thanks again for your help,
John

• This reply was modified 3 months ago by John.

Sorry, wasn’t aware bumping was a no-no, but it appears this is stalled and I think we’re very close. Any updates?

Thanks again!