Sunday, November 1st, 2009 (updated 16 Oct ’14)

Tied Entries v2.1.5 (Free)

 

Not yet compatible with EE2.6+!

From the start, one of the big attractions of ExpressionEngine has been the ability to add unlimited custom fields to an unlimited variety of channels (formerly known as weblogs). It’s vital to be able to relate these various channels to each other, and this is done with relationship fields — and extended by such 3rd-party add-ons as the beloved Playa.

But even the grace and power of Playa is stymied by the limited way its relationships can be displayed on EE templates; while a channel’s related entries can be displayed, those related in turn to its related entries cannot; that is, Playa’s children, parents and siblings tags cannot be nested — nor can the native EE related_entries and reverse_related_entries tags.

Tied Entries overcomes this limitation, enabling unlimited traversal across a site’s various channels via their relationship and Playa fields. It’s like having a fully relational database for your channels.

While there are other ways for the undeterred EE developer to achieve this here and there in templates, either with direct MySQL queries or with a series of embedded templates (as Pixel & Tonic suggests), the Tied Entries plugin is more powerful than the former and more flexible and less resource-consuming than the latter. Plus it’s much easier — increasingly so as the number of relationships grows.

The plugin can also be used as a substitute for the standard related_entries and reverse_related tags when displaying entries just one relationship away because, unlike those tags, results can be filtered by categories and custom fields.

Tied Entries is compatible with both EEv1.x and EEv2.x. The EE2 version is fully compatible with Playa 4; the EE1 version works with Playa 3 and older but only passively, that is, in reverse relationships.

Documentation

Tue 3 Nov ’09
10:27pm

Mark Bowen

Have only played with this plugin for a very short amount of time so haven’t totally gotten my head around it yet but from the example given this looks to be an exceptionally powerful plugin.

Thanks for sharing this one. Nice to be number one for a change too!! :-)

Best wishes,

Mark

Wed 4 Nov ’09
10:41am

Adam Khan

Cheers, Mark—if it helps you does that mean I get a helicopter ride?

Wed 4 Nov ’09
10:47am

Mark Bowen

Erm I think I’ll have to pass on that one I’m afraid. The cost of a ride is quite a bit I’m afraid. :-)

Wed 4 Nov ’09
10:52am

Adam Khan

Fair enough. I’m not sure what you’re doing fiddling around with computers when you could be flying a helicopter. Or maybe you’re fiddling around with a computer while you’re flying a helicopter…

Wed 4 Nov ’09
11:14am

Mark Bowen

Fiddling with a computer whilst flying would be something rather amazing. You can’t let go of anything whilst flying helicopters. With planes you can but not helicopters or you’ll come a complete cropper! ;-)

Mon 14 Dec ’09
9:06pm

Adam Khan

Hi Terry, question (1), right now it isn’t but I’ll put that on the roadmap—shouldn’t be too difficult. Re question (2), yes, it works, but put the variables in the conditionals within quotation marks and squiggly brackets. See the second example where it’s used to create the ul and /ul tags. In that example the variables used are the count and total_results, but custom fields work as well.

Mon 14 Dec ’09
10:05pm

Adam Khan

Terry, I’ve added support for searching custom fields as parameters in the tag. See the new version, 1.0.8.

Tue 15 Dec ’09
4:18pm

Adam Khan

Pleased to hear it, Terry.

When I say it’s not difficult that’s because the EE-native build_sql_query() function already does the work. That function helps hugely in letting plug-ins replicate the functionality of the weblog:entries tag (Paul Burdick had it as a slide at his EECI2009 presentation). Though it’s not very well documented so far as I have found, so it’s been a case of studying the EE code itself.

Wed 16 Dec ’09
5:21am

Nick

Does this extension work with Playa? If one has relationships set using Playa, would tied entries be able to bring these together?

Wed 16 Dec ’09
8:13am

Adam Khan

Nic, I haven’t tested it yet against Playa. That’s on the roadmap of things to do though (last section of the docs).

Sun 31 Jan ’10
12:50pm

Adam Khan

Stephen,

You can list all of an Employer’s Candidates even without the plugin using the 1st-party reverse_related_entries tag (with the weblog parameter as candidates) nested within the weblog:entries tag (with the weblog parameter as employers).

Wed 24 Feb ’10
4:39am

Michael Rubens

can the tied entries results be paginated?

Wed 24 Feb ’10
9:29am

Adam Khan

Michael, sorry, no pagination. I’ve been doing pagination client-side lately if that helps. See http://projects.allmarkedup.com/jquery_evtpaginate/index.php

Sat 27 Feb ’10
6:35pm

Michael

Thanks Adam, I’ll give that a look. One additional question. Any reason why I’m not able to get the {exp:char_limit} or {exp:word_limit} plugins to work with tied entries?

I’ve not tested extensively but in the two situations I’ve tried to use word limiting the tags are simply ignored. They don’t interfere but the functionality they promise is not delivered.

Sat 27 Feb ’10
8:37pm

Adam Khan

Michael, this is presuming you have parse=“inward” as a parameter in the outermost plugin? Have you tried reversing the nesting, ie, placing the Tied Entries plugin within the char_limit or word_limit one? Also, try the http://expressionengine.com/downloads/details/trunchtml/ plugin as well.

Mon 8 Mar ’10
7:15pm

Michael

Adam, another question - are embed variables supported and if so, what is the syntax for them?

E.g. Say I have a template I’m embedding to which I’m passing the entry_id of the parent entry being viewed for my weblog - news.

Within the embedded template I’m using the tied entries plugin to produce a list of related entries.  The tied entries tag sits within a weblog tag pair that is triggered by a url_segment relating to the “country” and it “ties” back to my “news” weblog - you’re head hurt yet?

The goal is to produce a list of “other/more” news from the “country”. However, I need to eliminate the parent entry from the list.

With reverse related tags I’m testing for the embedded entry_id and not viewing it - {if entry_id != “{embed:entry}”} show my entries {/if}

or maybe/better yet, there is a parameter that supports eliminating an entry from the tied entries list?

I hope this makes sense…

Mon 8 Mar ’10
8:54pm

Franco

Michael,  I’ve added to the Roadmap the changing of the entry_id, url_title and weblog parameters to this_entryid, this_urltitle and this_weblog so as to free up the entry_id, url_title and weblog parameters as filters like you need. I’ve done this on other plugins, haven’t done it here yet.

In the meantime, you should be able to do it in Tied Entries within an if statement like you’re doing with reverse related tags, ie:

{if “{tied:entry_id}” != “{embed:entry}”}

Tue 9 Mar ’10
2:51am

Michael

Great.  Another quick question - I’ve tried several different possible syntax combination’s and so for none have worked, is it possible to use the {if no_results} tag? I’ve also tried evaluation for a {tied:count} less than 1 or equal to 0. No luck.

Tue 9 Mar ’10
7:23am

Adam Khan

Michael,

When doing if statements, remember you need to put the entire value within quotation marks, so it’s got to be {if “{tied:count}” < “1”) not {if tied:count < “1”). Still not working?

I’ve not tested the {if no_results} tag but I doubt that it works within the plugin.

Maybe email me the entire template(s) at .(JavaScript must be enabled to view this email address) and I’ll take a look?

Tue 9 Mar ’10
2:32pm

Michael

Thanks, I have most of my conditionals functioning but the {if ?{tied:count}? < ?1?) alternative to {if no_results} does not work.

My solution, though not always that simple to implement, has been to revert back to using the query module to pull in these results. The added benefit, beyond offering the {if no_results} tag is that it also, at least in this case, allows pagination to function.

When I have a moment later today I’ll drop my template into a txt doc and send your way to give you a look at what I’m doing.

I do appreciate you taking the time to assist.

Regards!

Wed 10 Mar ’10
5:19pm

Deron Sizemore

This is the first I’ve heard of this plugin. Wish I had heard of it sooner as I think could really help out on LogoGala where I’m doing some complete related entries stuff. Going to give it a go and hope it works as this section of the site has not worked 100% correct since launch. :)

Wed 10 Mar ’10
7:03pm

Adam Khan

Logogala, nice—post here if you have any questions or problems when trying the plugin.

Wed 5 May ’10
2:08am

Luther

Adam,

Love Tied Entries, we use it like crazy! We just upgraded a development server to EE PB 2.0.2 build 20100415 and v1.1.1 does not appear to be compatible with it. We received the error below. Because we are so dependent on your plugin we are frozen at our current version 2.0.1 and build. Have you encountered this error yet? Do you have a timeline for updating Tied Entries to work with version 2.0.2?

Thanks for all the hard work!!


————-

A PHP Error was encountered
Severity: Notice
Message: Undefined property: EE::$DB
Filename: tied_entries/pi.tied_entries.php
Line Number: 47

Fatal error: Call to a member function escape_str() on a non-object in /mnt/target03/361603/414125/www1.fasigtipton.com/web/content/5y5t3m/expressionengine/third_party/tied_entries/pi.tied_entries.php on line 47

————

Wed 5 May ’10
3:01am

Luther

Adam,

After looking at the error I realized it was very basic and replaced all references to $this->EE->DB with lowercase “db” and that took care of the first small errror. However I think now I got to the root of the issue with version 2.0.2 compatibility. It appears they may have slightly modified the Channel class which you use.  Here is the new error that I am receiving after fixing the “DB” issue. Hopefully this helps pinpoint the issue quicker. This error is from v1.1.1 but I also checked v1.0.9 and it has the same issue (but not the capital “DB” reference since that looks like it was added in v.1.1.1).

Thanks again!!

———-

A PHP Error was encountered
Severity: Notice
Message: Undefined property: Channel::$query
Filename: tied_entries/pi.tied_entries.php
Line Number: 551

Fatal error: Call to a member function result_array() on a non-object in /mnt/target03/361603/414125/www1.fasigtipton.com/web/content/5y5t3m/expressionengine/third_party/tied_entries/pi.tied_entries.php on line 551

Wed 5 May ’10
7:13am

Adam Khan

Luther, great to hear you’re using the plugin extensively. I’ve had to make an unscheduled trip and am now back and catching up. I’ll fix this problem today.

Thu 6 May ’10
2:03pm

Luther

Adam, have you had a chance to look any further into the issue with Tied Entries and EE PB 2.02? Any timeframe for a new build that fixes the issue?

Thanks!

Luther

Thu 6 May ’10
4:15pm

Adam Khan

Luther, my apologies, I wasn’t able to get to it yesterday, nor today yet, but I will in the next couple of hours. Still catching up.

Tue 17 Aug ’10
4:50pm

Jesus

Hi, I just bought the extension but I don’t know how can I achieve the following:

I have three different channels: project_leaders, projects, and project_updates

The project_updates channel have a field that relate to project_leaders and another field with relation to projects.

I am pulling out the project_update (this usually are multiple records) that relates to the project I am in. This happens correctly with just reverse_related_entries from EE2 but how could I pull out the project_leaders relation to the project_updates entry?

Thank you

Tue 17 Aug ’10
5:06pm

Adam Khan

Hi,

> The project_updates channel have a field that relate to project_leaders and another field with relation to projects.

So the data scheme is:

project_updates > project_leaders
project_updates > projects

Is that right? If so,

>  how could I pull out the project_leaders relation to the project_updates entry?

Don’t you already have this relationship?

Wed 18 Aug ’10
9:43am

wftsl

> Don’t you already have this relationship?

That’s correct I have that relationship:

project_updates > project_leaders
project_updates > projects

Thu 19 Aug ’10
4:13pm

Jamie

Hi Adam

I’m trying to get my head around the syntax here but could do with a nudge in the right direction (i’m also new to EE). I have a site with Projects that are related to Services.  (each service has many projects).  I want the Project page to display a list of other projects in the same category, but encountered the problem of nesting relationships. Currently my code is thus:

{exp:channel:entries channel=“project” limit=“1”  status=“not closed”}
<h1>{title}</h1>
  {related_entries id=“service”}
    {title}
  {/related_entries}
  {project_summary}
  {related_entries id=“service”}
    <h3>More in {title}</h3>
    <ul>
      {reverse_related_entries status=“not closed”}
        {title}
      {/reverse_related_entries}
    </ul>
  {/related_entries}

{/exp:channel:entries}

How do I go about altering this to work with Tied Entries? My pitiful attempts so far have ended in FAIL.

Thu 19 Aug ’10
4:21pm

Adam Khan

Hi Jamie,

You could do the following: replace

<h3>More in {title}</h3>
  <ul>
    {reverse_related_entries status=“not closed”}
      {title}
    {/reverse_related_entries}
  </ul>

With:

{exp:tied_entries entry_id=”{entry_id}” tie=”<project” status=“not closed”}
{if "{tied:count}” == “1”}
<h3>More in {title}</h3>
<ul>
{/if}
<li>{tied:title}</li>
{if “{tied:count}” == “{tied:total_results}”}
</ul>
{/if}
{/exp:tied_entries}

Thu 19 Aug ’10
4:32pm

Jamie

Wow, that worked first time - thanks for your quick response Adam! So making the {tied:title} into a URL would be…

< li > <a href = ” {tied:title_permalink='project'}”>{tied:title}</a>< /li >

?

Thu 19 Aug ’10
4:37pm

Jamie

Ah no, its

< li ><a href= ” {tied:url_title}”> {tied:title} </a> </li>

Thanks again!

Sun 10 Oct ’10
5:23pm

Hybrid Design

I’m having an issue with nested categories - are they currently supported? 
ex. This works - {exp:tied_entries entry_id=”{entry_id}” tie=”<media” orderby=“title” sort=“asc” category=“13”}
But this doesn’t - {exp:tied_entries entry_id="{entry_id}” tie=”<media” orderby=“title” sort=“asc” category=“11”}
Category 11 is a parent category of Cat 1-9.

The error is this:
The query you submitted is not valid.

Thanks!

Sun 10 Oct ’10
6:53pm

Adam Khan

Hybrid, it really shouldn’t make any difference. If you switch on the plugin’s debugging with debug=“y”, do you get anything helpful back?

Sun 10 Oct ’10
7:10pm

Hybrid Design

Thanks for the quick reply - I tried setting debug to “y” and “yes” with no luck:

{exp:tied_entries entry_id=”{entry_id}” tie=”<media” debug=“yes”}
{if "{tied:count}”==“1”}<div class=“bar”></div><h4>Free Study Guides</h4>{/if}
{tied:title}
{/exp:tied_entries}

The page still gives results - not debug info.

Sun 10 Oct ’10
7:26pm

Adam Khan

I’ll try to replicate your setup. What EE are you running?

Sun 10 Oct ’10
7:36pm

Hybrid Design

EE 2.1 Build:  20100810
Pixel & Tonic Matrix & Field Pack Installed
Pages Module Installed
Low Reorder Module Installed

Sun 10 Oct ’10
10:56pm

Adam Khan

I see there’s a problem with the plugin in EE2 using categories, which I’m working on fixing, but only when there’s no relevant category. In your case, where there is one, it’s working for me. Apologies for asking, but are you sure you have “Auto-Assign Category Parents” to Yes in Global Channel Preferences?

Sun 10 Oct ’10
11:10pm

Hybrid Design

I do have that set to yes.  If it helps - I also tried moving all the sub-categories to a new category group to take nested categories out of the equation.  For whatever reason, I can only get one category to work in the category=“13” parameter. All other numbers for any of the other categories throw an error.  I’m trying a work-around now with embedded templates - seems to be working, definitely not as efficient.

Thanks for you help!

Sun 10 Oct ’10
11:15pm

Adam Khan

I’ll keep looking at it. For me the problem only happens if the category specified is not assigned to any entry results from the tie.

In the plugin the categories are handled by a call to the channel module itself, so it may take me a bit of delving to fix this.

Thu 14 Oct ’10
2:34pm

Adam Khan

Hybrid, I’ve split the plugin back up into two versions, one each for EE1 and EE2 in order to fix a different issue. This new version, v1.3.4, might solve yours as well. [crosses fingers]

Fri 14 Jan ’11
8:46pm

neonarcade

Adam,

I’m having an issue doing a reverse into a normal relation.. here’s my code:

{exp:channel:entries channel=“cities”}
  <h3>{title}</h3>
  {exp:tied_entries entry_id=”{entry_id}” tie=”<ads>ad_content”}
      {tied:title}
      {/exp:tied_entries}
{/exp:channel:entries}

when I do just “<ads” it works fine.. and i get the title from the ads record.. but it never goes deeper into ad_content (which is a relation field on ads)

Fri 14 Jan ’11
8:53pm

Adam Khan

Neonarcade, does turning on the plugin’s debug mode shed any [shimmering neon] light here?

Tue 25 Jan ’11
7:57am

James Thomas

Hi Adam,

I’m having an issue with the plugin in my evaluation. I have an embedded template (showcase) which is calling a related entries item (student)... I’m trying to access the student_school related entry without luck. Perhaps you can give this a quick once-over. I’d really appreciate it. If this goes well I’m definitely buying the plugin.

Thanks,

Jimmy
—-

{exp:channel:entries entry_id=”{embed:entry_id}”}

  ...

  {related_entries id=“showcase_student”}
  <ul>
      <li>Student Name: {first_name}</li>
      <li>Age: {student_age}</li>

      {exp:tied_entries entry_id=”{entry_id}” tie=”<student_school”}
        <li>School: {tied:title}</li>
      {/exp:tied_entries}

      <li>Grade: {student_grade}</li>
  </ul>
  {/related_entries}

  ...

{/exp:channel:entries}

Wed 26 Jan ’11
11:59am

Adam Khan

James, it looks like student_school is a field in students, in which case the value in the “tie” parameter should be “>student_school”—it’s a regular related entry, not a reverse one.

Wed 26 Jan ’11
5:43pm

xenocom

That worked. Thank you so much. And now I purchase. :)

Tue 8 Feb ’11
12:38am

Marshel Barbash

EE v2.1.0 - Tied Entries 1.3.4

I keep getting this error relating to reverse tied entries when all related entries have been expired: The query you submitted is not valid.

if I set show_expired=‘yes’ debug=‘yes’

I get these PHP errors:

A PHP Error was encountered
Severity: Warning
Message: Invalid argument supplied for foreach()
Filename: tied_entries/pi.tied_entries.php
Line Number: 652

A PHP Error was encountered
Severity: Notice
Message: Undefined variable: filters_display
Filename: tied_entries/pi.tied_entries.php
Line Number: 667

Although the query debug displays “no errors”:

Prelim query: SELECT r.rel_parent_id AS result_id FROM exp_channel_data AS d, exp_relationships AS r WHERE d.channel_id = 16 AND r.rel_parent_id = d.entry_id AND r.rel_child_id = 145 ORDER BY d.entry_id ;

Prelim results: 117,118,146

Full channel/weblog query: SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id, w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio, md.*, wd.* FROM exp_channel_titles AS t LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (146,118,117) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc

Full results: 146,118,117,
Search filters:
Tied Entries errors:
No Tied Entries errors detected.

Fri 11 Feb ’11
11:55pm

Lee

Any idea when the roadmap item for adding full support for Playa may be completed.

We are having an issue with needing additional playa info and we cant really move forward till this happens. Would some extra beer $ help grease the wheels.

Thanks,
-Lee

Sat 12 Feb ’11
12:37am

Adam Khan

Lee,

Adding this functionality isn’t first thing on my list (and Playa 4 uses new db architecture), so I instead I’d recommend using the query tag to build some SQL directly into the template.

Mon 7 Mar ’11
11:16pm

dean

Hi, I purchased Tied Entries but ran into an error message right off the bat. I must have done something really dump because the error message refers to a table that doesn’t exist:

Error Number: 1146
Table ‘bsr-ee.exp_ff_fieldtypes’ doesn’t exist
SELECT fieldtype_id FROM exp_ff_fieldtypes WHERE class=“playa”
Filename: third_party/tied_entries/pi.tied_entries.php
Line Number: 336

exp_fieldtypes exists but not exp_ff_fieldtypes

Running EE 2.1.3 and MSM 2.0. And FWIW, I have Playa (v3.0.9) installed. too.

Can you shed any insight as to what I’ve done wrong?

Thanks!

Tue 8 Mar ’11
9:21pm

Adam Khan

Dean, Nothing done wrong by you. Looks like the table name has changed since this was written and you’re the first to point it out. I’ve changed it in v1.3.5—can you download this newer version of the plugin and check if the problem’s fixed?

Thu 7 Apr ’11
2:19am

chris c

This plugin sounds great.  How does the category parameter work.  I assume it is the same as with a channel entry tag.  What I really would love is using category as a parameter to the reverse related entry look up.  I have an exhibit that is related to an artist that has a reverse relationship with artwork that is categorized as either a portfolio or an collection piece.  Given an exhibit I would like to display either a set of portfolio or collection pieces.

Thu 7 Apr ’11
5:26am

Adam Khan

Chris C, I think that should be fine; the category parameter limits the results. You’d need to invoke the plugin twice, once for each of the two categories, portfolio piece and collection piece.

Fri 8 Apr ’11
1:11am

chris c

How would the plugin know which entry to apply the category to?  I want it to be checked on the artwork only, not the exhibit or the artist. 

  {exp:tied_entries entry_id=”{entry_id}” category=“portfolio” tie=”>artist<artwork”}

  Would it apply the category check to the artist entry as well as the artwork entry.  Would I have to brteak this into two tags like ...
{exp:tied_entries entry_id=”{entry_id}” category=“portfolio” tie=”>artist<artwork”}
  {exp:tied_entries entry_id=”{entry_id}” category=“portfolio” tie=”<artwork”}

  {tied:aw_name}

  {/exp:tied_entries}
{/exp:tied_entries}

Fri 8 Apr ’11
4:14am

Adam Khan

Chris C, it’ll only apply the category filter to the artwork.

Fri 8 Apr ’11
11:55pm

chris c

I am sold!  Thanks!

Tue 31 May ’11
7:48am

John

I spent some time tonight working through the category bug here… If any of the entries from the channel:entries tag don’t have related entries in a specific category when category=”” is used, the plugin fails. I was able to work around this by manually excluding every entry_id that didn’t have a related entry in the particular category.

Wed 27 Jul ’11
2:39pm

Thierry Fortier

Since I updated to EE 2.2.1 and Playa 4.0.5 I get this message :

Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘54) ORDER BY d.entry_id’ at line 1
SELECT r.parent_entry_id AS result_id FROM exp_channel_data AS d, exp_playa_relationships AS r WHERE d.channel_id = 3 AND r.parent_entry_id = d.entry_id AND r.child_entry_id IN 54) ORDER BY d.entry_id ;
Filename: third_party/tied_entries/pi.tied_entries.php
Line Number: 555

This one is fairly easy, adding the starting ( as “IN (54” solves it, but then I get another message :

The query you submitted is not valid.
Filename: third_party/tied_entries/pi.tied_entries.php
Line Number: 649

Is there a fix for that?

Wed 27 Jul ’11
2:41pm

Thierry Fortier

On a side note to my previous comment, I use Tied Entries v1.4.7

Sun 27 Nov ’11
4:15am

mithra62

I took a tester look at 1.4.7 (EE2) and found an issue.

When running the plugin with a category parameter you still get the same error that Thierry notified you about. Adding a closing parenthesis to line 517 fixed things right up.

Wed 7 Dec ’11
4:44pm

Werner

Results with Version 1.4.7:

First realtionship as a Playa field works. But the second in the chain can’t be a Playa field again.  Had to switch to standard EE relationship field and then I could reach data that were more than one table away.

Or did I miss something?

Beside this issue I am very happy with this addon.

Mon 12 Dec ’11
10:16pm

Thijs Kaspers

I purchased Tied Entries but can’t get it to work… I use EE2 and I keep getting a 500 internet-server error when trying to retrieve a list of related entries.. Even a simple related entry with just a tied:title returns a 500 error. What could be causing this?

Thu 15 Dec ’11
12:49pm

Adam Khan

Thijs and Werner, v1.5.1 solves these problem. Thierry, the “The query you submitted is not valid.” problem is still there if the category or any other parameter filters things to the point that there are no entries. I’m working to fix this.

Thu 15 Dec ’11
12:53pm

Werner

Yes I can confirm. Version 1.5.1 does what is expected and solves my problems. Thank you, Adam

Thu 15 Dec ’11
1:02pm

Adam Khan

Thanks for your patience, Werner!

Fri 16 Dec ’11
9:37pm

Jay Robinson

Any idea how to use a Structure URL instead of url_title for links? Using url_title can be problematic when someone changes the name of the page, but wants the link to stay the same.

Fri 16 Dec ’11
9:57pm

Adam Khan

Jay, good point, as yet the plugin has no understanding of Structure. I’ve added adding Structure URL as a parameter to the roadmap, but can’t really say when the functionality will be added.

Sun 26 Feb ’12
9:02pm

ChiefAlchemist

Hi Adam - Perhaps it’s just me and the bit of pressure of being under a deadline but I’m find the documentation and example a bit perplexing. I’m using Playa for a music site. My structure is:

Album—products_artists ->> Artists

Album—products_artwork-> Images

All images are kept in an Images channel and Playa’ed to as needed). There are other channels that I’m not mentioning here for the sake of brevity.

So…I’m in the Artists channel. I parent up to get the albums for that artist. That’s fine :) However, while I’m there at the parent (i.e., Album) I want to traverse (?) over to the Images and also get the artwork for that album. This is where I’m stumped. A couple examples with Playa would help. I’m not even sure if I have the syntax right.

I’d also like to suggest the examples, even the comments get updated to reflect the this_entry_id and such. I was copy and pasting trying to get things to not error and then happened to see the bit about this_.

Sun 26 Feb ’12
10:31pm

ChiefAlchemist

fwiw, I can get {tied:entry_id} and {tied:url_title} to display and they are in fact the correct values for the Image(s) that is a playa child of the Album. But when I try {tied:images_file} or {tied:images_caption} those tags don’t return any values. They don’t even parse. The page displays the actually string: “{tied:images_file}” (sans the quotes). So it’s like half working. Unfortunately, I need more than half right now :(

Mon 27 Feb ’12
2:29pm

ChiefAlchemist

One more question (for now) please…

Tours - -  tours_artists - ->> Artists
Albums - -  album_artists - ->> Artists

I’m displaying a simple Album. I child (via Playa) to the Artists for that Album (typically it’s a single artist but could be a many). From the Artists I wish to child to Tours and grabs tour dates for the artists associated with the Album I’m currently displaying.

Is this possible? Can you please assist me with syntax? I’m sure once I digest a couple Playa-centric examples I’ll be on my way. As it is I was ‘experimenting’ well at least 2-3 hours yesterday, reading and rereading the above and still {tied:my_field_name} wouldn’t parse and display. 

Thanks in advance Adam.

Mon 27 Feb ’12
5:35pm

Tylonius

Trying to work this out, but I must be missing something.

I have the following hierarchy in place:

  Education Programs
    Education Categories
      Education Courses
        Education Classes

Each Program has a number of Categories, each Category has a number of Courses, and each Course has a number of Classes. For example:

  The Dance Program has Ballet,  Jazz, Tap, etc. as Categories.
    The Ballet Category has Beginning, Intermediate, and Advanced Courses.
      The Advanced Ballet Course has M-W Classes, and T-Th Classes.

Here’s my code:

<div id=“education-category”>
                {exp:tied_entries entry_id=”{entry_id}” tie=”>ed_categories” orderby=“title” sort=“asc”}
                  <h3>{tied:ed_category_name}</h3>
                  {tied:ed_category_description}
                      {exp:tied_entries tie=”>ed_categories>ed_courses” orderby=“title” sort=“asc”}
                        <h3>{tied:ed_course_name}</h3>
                        {/exp:tied_entries}
                {/exp:tied_entries}
              </div>

In the example, you show the relationship field for tie value on the regular relationships, and the channel name for the tie value on the reverse relationships. I’ve tried it both ways, and I’m not getting anything.

What’s wrong?

Thanks,

ty

Mon 27 Feb ’12
5:38pm

Tylonius

BTW, your site’s style sheet has   font-size: 82%;
value for the tt element, and it makes the site really hard to read. Just FYI. :-)

Wed 29 Feb ’12
1:06am

Adam Khan

Tylonius, thanks for the heads-up. Some weirdness caused by tt tags not being closed properly. Fixed (though things need a makeover in general, I know…).

Wed 29 Feb ’12
1:11am

Adam Khan

Ty, try doing it without nesting the plugin (unless you’re doing something hierarchical, in which case try adding parse=“inward” on the outer tag).

If it’s a field you’re linking to, use “>”. If it’s a channel, ie a reverse relationship, use “<”.

Wed 29 Feb ’12
1:26am

Adam Khan

ChiefAlchemist, just emailed you for login details. Plugin should be able to do what you need.

Mon 19 Mar ’12
4:08am

Kruspy

My custom fields are not being displayed. The output on my page is the unparsed tag - for example, my custom field name is “model” and the displayed value on my web page is {tied:model}, exactly as it appears in my template. Standard fields are being correctly populated and displayed. Any suggestions?

Sat 31 Mar ’12
1:38pm

Adam Khan

Kruspy, apologies for the long delay in responding to your post. Somebody else has complained of the same issue, but I couldn’t reproduce it. I’ll try again. What version EE are you using?

Sat 31 Mar ’12
2:40pm

Adam Khan

Kruspy, the issue is now fixed as of v2.1.1. When I restructured the plugin’s code, looks like I missed the part that gathers the fields.

Thu 17 May ’12
2:06pm

matt

I’ve ust installed but get a syntax error for {exp:tied_entries}. Do you have any ideas why this might be? Here’s my code.
    {exp:channel:entries channel=“product_pricing” dynamic=“off” limit=“1” parse=“inward” status=“not closed”}
      {exp:tied_entries this_entry_id=”{entry_id}” tie=”>choose_product_details”}
        {tied:title}
      {/exp:tied_entries}
{/exp:channel:entries}

Thanks

Fri 18 May ’12
12:39pm

Adam Khan

Matt, that looks right to me, though the parse=“inward” parameter in the channel:entries tag isn’t necessary for Tied Entries to work. What is the syntax error?

Fri 18 May ’12
1:08pm

matt

I figured it out - the ‘tied_entries’ folder is named incorrectly in your download. It’s currently named ‘tied_entires’.
Thanks

Fri 18 May ’12
5:06pm

Adam Khan

DOH! Matt, sorry about that, new version released with fix.

Sun 15 Jul ’12
6:12pm

Hix

Adam, I am trying to get file information for a tied file field and it is not working.

The problem seems to be that “{tied:file_field}” returns “{filedir_4}filename.jpg”.

Should {filedir_4} be parsed?

I am running EE v2.5.2 - Build Date: 20120606

Tue 7 Aug ’12
8:48pm

Aaron

Adam,

I’m trying to do something with TE and getting nowhere fast! Here’s the situation: I have a Critics channel, a RestaurantPicks channel, and a Restaurant channel. The RestaurauntPicks channel has TWO relationships, one to each of the other channels.

While inside a loop of Restaurants, I need to get the list of all Critics who have picked it.

What I expected to work was this:
{exp:tied_entries this_entry_id=”{entry_id}” tie=”<restaurantpicks:cf_restaurantpick_restaurant|cf_restaurantpick_critic<critics”}{tied:title}{/exp:tied_entries}

it comes up with no errors, but no data either.
Any ideas?

Tue 7 Aug ’12
11:45pm

Adam Khan

Aaron, did you try it with the debug=“y” parameter? My guess would be that it’ll tell you that “<critics” is not a field. From RestaurantPicks to Critics is a relationship not a reverse relationship, so in the tie you need “>critics”. Hope that does it.

Tue 7 Aug ’12
11:47pm

Adam Khan

Hix,

Apologies for the 3-week delay in responding. I’m not sure about the parsing order regarding {filedir_4}. Can you do a replace maybe with another plugin such as low_replace outside tied_entries?

Tue 7 Aug ’12
11:49pm

Adam Khan

Aaron, also by the looks of it, your tie could be simpler, just tie=”<restaurantpicks>critics”.

Thu 2 May ’13
4:00pm

David

Adam, have you had any luck running with Tied Entries on version 2.6.0 of EE?  We just upgraded our site and the tied entries do not appear.  Instead this notice appears once for each place we expect a tied entry:

A PHP Error was encountered
Severity: Notice
Message: Undefined property: Tied_entries::$fields_array
Filename: tied_entries/pi.tied_entries.php
Line Number: 326

Thu 2 May ’13
5:37pm

David

As a follow up, with debug=“y” set, the error message says that the field we are trying to tie with cannot be found.

Fri 3 May ’13
12:40am

Adam Khan

David,

I’ve been busy with client work and haven’t had a chance to update. But yes, EllisLab has done some major work on relationships so it could be that things are broken with Tied Entries.

Are you using it with Playa? If not, it seems to me that the new nesting abilities in EE 2.6 make the Tied Entries plugin kind of redundant. What’s your experience with the nesting, if any?

Fri 3 May ’13
1:59pm

David

Adam,

Thanks for following up.  We’re not using Playa, and I don’t have experience with nesting.  I’m doing an upgrade project on an old EE site.  We’re going to stay at 2.5.5 for now, because of other issues unrelated to tied entries.  I think the main problem with tied entries is that the names of all the columns in exp_relationships changed.  I have a patch file if you’d like it.

Fri 3 May ’13
4:31pm

Adam Khan

David,

Excellent, send her over! .(JavaScript must be enabled to view this email address)

Thanks for that.

Thu 13 Jun ’13
4:35am

fjldude

Are there major differences in parsing of white space, html brackets, double quote, single quotess etc between Tied Entries for EE1 and EE2?

I’m converting a site to EE2 and having trouble with Tied Entries.  I’ve posted my questions at
http://devot-ee.com/add-ons/support/tied-entries/viewthread/9807

Any suggestions would be most welcome!  Thanks.

Post a comment

Name:

Email:

Location:

URL:

Your comment:

Please answer the following question to assure your intentions are honorable: Tea leaves and ??? beans. (6 characters required)

Remember my personal information
Notify me of follow-up comments?