Geek Answers Handbook

ExpressionEngine: Help w / Order Backlinks

I'm having trouble sorting some of the records related to reverse connection. There are only some restrictions with EE, and I am looking for a quick solution. Any help you can provide will be appreciated.

I have two channels: registration and students. Students have a relationship field that links each entry to an entry on the enrollment channel. (I need to continue to use the EE relationship field.)

The student channel has two groups of categories assigned to it: classes (group No. 1) and instrument (group No. 2). Category identifiers No. 1-6 are categorized.

The following code reaches half what I need:

{exp:channel:entries channel="registrations" entry_id="{segment_4}" dynamic="no"} <table> {reverse_related_entries channel="students"} {categories show="1|2"} <tr> <td><?php print $count; ?>.</td> <td>{title}</td> {embed="_includes/student_print" student_id="{entry_id}"} </tr> {/categories} {/reverse_related_entries} </table> <table> {reverse_related_entries channel="students"} {categories show="3|4"} <tr> <td><?php print $count; ?>.</td> <td>{title}</td> {embed="_includes/student_print" student_id="{entry_id}"} </tr> {/categories} {/reverse_related_entries} </table> <table> {reverse_related_entries channel="students"} {categories show="5|6"} <tr> <td><?php print $count; ?>.</td> <td>{title}</td> {embed="_includes/student_print" student_id="{entry_id}"} </tr> {/categories} {/reverse_related_entries} </table> {/exp:channel:entries}

Here embed_print embed:

 {exp:channel:entries channel="students" entry_id="{embed:student_id}" dynamic="no"} <td><font size="2">{categories show_group="2"}{category_name}{/categories}</font></td> <td><font size="2">{categories show_group="1"}{category_name}{/categories}</font></td> {/exp:channel:entries}

Now, what I need is to organize the reverse records of the CUSTOM ORDER categories in the tool category group (group No. 2). I simply did not know how to do what I am doing now (displaying three tables - each of which displays entries from certain categories in group No. 1) and places them in the user-defined order of categories in group No. 2.

Again - the categories in group # 2 are individually arranged, and I need to display the corresponding entries in this custom order. It is important.

Any ideas? Can this be done with a custom query? I would really appreciate a code example - if possible. This stretches my EE and SQL chops as is.

Thank you for your time.

+7
source share
2 answers

I really don't use kinship anymore, too buggy for me. so playing would be better. however, I found this error that may be related to your problem: http://expressionengine.com/bug_tracker/bug/16373

+2
source

Honestly, my first impression is that this is the wrong way to structure this. Too complicated. But what is always easy to say based on foreign law? :)

Secondly, I’m not sure why you need this registration channel, because it seems that you are not using any data from it (if you have not cut out some code fragments for clarity)?

But independently, here is some unverified code. The bottom line is that you can only order by category using the channel:categories tag, and then passing {category_id} to the new channel:entries tag. If we pass a list of all entry_ids to each tag inside, it should filter out all that do not belong to the specific {category_id} that you pass.

 {exp:channel:entries channel="registrations" entry_id="{segment_4}" dynamic="no"} {embed="_includes/student_print" entry_ids="{reverse_related_entries channel="students" backspace="1"}{entry_id}|{/reverse_related_entries}"} {/exp:channel:entries}

Then your attachment is as follows:

 {exp:channel:categories channel="students" style="linear" show="1|2"} {if count == "1"}<table>{/if} {exp:channel:entries channel="students" entry_id="{embed:entry_ids}" category="{category_id}" dynamic="no"} <tr> <td><?php print $count; ?>.</td> <td>{title}</td> <td><font size="2">{categories show_group="2"}{category_name}{/categories}</font></td> <td><font size="2">{categories show_group="1"}{category_name}{/categories}</font></td> </tr> {/exp:channel:entries} {if count == total_results}</table>{/if} {/exp:channel:categories} {exp:channel:categories channel="students" style="linear" show="3|4"} {if count == "1"}<table>{/if} {exp:channel:entries channel="students" entry_id="{embed:entry_ids}" category="{category_id}" dynamic="no"} <tr> <td><?php print $count; ?>.</td> <td>{title}</td> <td><font size="2">{categories show_group="2"}{category_name}{/categories}</font></td> <td><font size="2">{categories show_group="1"}{category_name}{/categories}</font></td> </tr> {/exp:channel:entries} {if count == total_results}</table>{/if} {/exp:channel:categories} {exp:channel:categories channel="students" style="linear" show="5|6"} {if count == "1"}<table>{/if} {exp:channel:entries channel="students" entry_id="{embed:entry_ids}" category="{category_id}" dynamic="no"} <tr> <td><?php print $count; ?>.</td> <td>{title}</td> <td><font size="2">{categories show_group="2"}{category_name}{/categories}</font></td> <td><font size="2">{categories show_group="1"}{category_name}{/categories}</font></td> </tr> {/exp:channel:entries} {if count == total_results}</table>{/if} {/exp:channel:categories}

I don’t know what kind of variable $count PHP you have, but modification may be required, since it is now inside the embed.

Let me know if this bears fruit?

+1
source

More articles:


All Articles