John

Hi and many thanks for the follow-up! Sorry, I’m a bit confused, the link you sent above (https://ww.wp.xz.cn/plugins/learnpress/) after clicking on Support resolves to:
https://ww.wp.xz.cn/support/plugin/learnpress/,
which is the same forum:
https://snipboard.io/HYk0CQ.jpg
I have included the listing of my post in the screenshot above with URL.

I’d be happy to post this in the correct forum if you could send me the appropriate link.
Thanks again,

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!

Ah, then that is the answer – populate the excerpt manually. Problem solved. Thanks!

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 1 year, 4 months ago by John.

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!

Hi and yes – my video courses correspond to specific pages in a companion book. I have tagged each course with that page number. It would be therefore nice to be able to sort the courses based on the page number so students can easily find a corresponding video while referencing the book. I hope that makes sense…

I found where I can add an option to the dropdown, but haven’t been able to discover the code where the query to the database is taking place when someone clicks on the sort option.

Thanks again for your time,
John

Dear Brianvu-tp,

Thanks for the response. We are using Astra (not Pro)…

Best,
John

Thanks for the follow-up, yes I have accomplished this with the CSS given. The screenshot above is what is required. The actual course header then looks like this:

Just out of the box the filter looks like this with hierarchies:

And the course header then becomes this:

Normally I wouldn’t repeat the key in the child but in the course header it wouldn’t make sense to just see C or D and searching for example. I hope this clears it up for you.

Like I say this is fixed with a few simple CSS tricks but if you look at say the Filter Everything plugin they have this worked out nicely…

Thanks for your support.
John