Build the Archive

Unlock your potential with a Pro Membership

Here is where you propel your career forward. Come join us today. Learn more.

Let’s build our archive template now. We are going to need to fetch the records from the database that are already grouped by their topics.

To do this, let’s reuse the code from the Advanced SQL lab. You can get the code here on GitLab and load it into the archive file.

Here is the lab to refresh yourself on how this code works, as I’m not going to re-explain in this episode.

12 Episodes
02:46:48 Runtime

Get Posts Grouped by Terms | Know the Code

Advanced SQL - Get Posts Grouped by Terms

This hands-on lab teaches you more advanced SQL including table relationship types, how to join multiple tables together, and how to write SQL queries that are faster and more scalable for your WordPress projects. You will use a practical example plugin to test two different approaches to solving the problem of fetching posts that are grouped by each term. You'll test these approaches, explore the actual SQL queries, and learn about the impact of processing speed, performance, and scalability.

Learn more

We’ll see what we get back and then adapt the code for our needs.

Not using a Genesis-powered theme?

I’m using the Genesis framework. If you’re not, that’s okay. You’ll simply need to adapt the template for your theme.

Break. Go rest your noodle for a couple of minutes.

Episodes

Total Lab Runtime: 05:11:56

1 Lab Introductionfree 07:51
2 Planning it Outfree 11:05
3 Module Architecturepro 17:12
4 Build the Basic FAQ Custom Post Typepro 06:04
5 Configuring the Custom Post Type Labelspro 18:33
6 Configuring the Custom Post Type Feature Supportspro 07:23
7 Configuring the Custom Post Type Optionspro 11:27
8 Flushing the Rewritespro 09:44
9 Planning the Taxonomypro 04:54
10 Build the Taxonomypro 05:33
11 Taxonomy Label Generatorpro 14:23
12 Flush Rewrite Rules - Taxonomypro 05:36
13 Architecting the Archive Pagepro 11:14
14 Serve Archive Template from the Pluginpro 10:41
15 Let Theme Override Our Archive Templatepro 21:29
16 Build the Archivepro 11:09
17 Build the Archive Viewspro 13:23
18 Set the Order Within the Topicpro 03:44
19 Review and Commit Changespro 02:34
20 Architect the Shortcodepro 15:23
21 Build the Shortcode - Single FAQpro 21:19
22 Fixing the Architecturepro 08:00
23 Define a WP_Query for Topicpro 16:10
24 Continue Building the Shortcodepro 11:39
25 Finish by Topic Shortcodepro 08:51
26 Planning the Refactorpro 08:01
27 Refactor FAQ Modulepro 19:58
28 Test, Fix, Commit, and Wrappro 08:36

Back to the lab's opening page.

Unlock your potential with a Pro Membership

Lab: Add a FAQ Feature to the Collapsible Content Plugin – Part 2

Advanced SQL - Get Posts Grouped by Terms

Not using a Genesis-powered theme?

Episodes

Learn

Help

General