Great thread What do software engineers who work at a large scale understand that other developers don’t? at /r/programming
-
Version
2.1.5 -
Type
Plugins -
More info
-
Elsewhere
EE Forums thread
Devot-ee page -
Download
The Tied Entries plugin works similarly to the exp:channel:entries tag’s related_entries and reverse_related_entries tags. The difference is that you can tie entries to those in other channels not just one relationship away but via all the relationships and reverse relationships that connect them. There is no limit to the length of this tie, ie, to the number of relationship steps.
Known Issues
- When using MSM and displaying a channel from another site, the search:field_name parameter doesn’t work.
- When using Playa, entries cannot be sorted using the Playa order.
Installation
Place the /tied_entries directory from the download package into your site’s /[system_folder]/expressionengine/third_party directory.
Required Parameters
site
Required when using the Multiple Site Manager.
this_channel
If you are using the this_url_title parameter instead of the this_entry_id parameter to set the initial entry, then the channel name must also be specified, as entries from different channels can share the same url_title.
this_entry_id
This required parameter sets the initial entry. If the plugin is within another tag, such as the channel:entries tag, then the value of this parameter can be set dynamically, eg, with the {entry_id} variable.
this_url_title
If the entry_id is not available then the entry can be set by the url_title, such as from a segment variable.
tie
This is where the magic happens. Build the tie with relationship fields and channel names. Prefix each relationship field with “>” to signify a relationship (or “child” in Playa) and each channel name with “<” to signify a reverse relationship (or “parent” in Playa). These two different prefixes address the ambiguity where a field and a channel can share the same name.
In reverse relationships you can limit the results to a specific relationship field. Do this with a colon separating the channel name from the field, eg, tie=”<my_channel:my_field_name<another_channel”. You can also limit results to a number of specific relationship fields using a pipe, eg, tie=”<my_channel:my_field_name|my_second_field_name<another_channel”.
Optional parameters
allow_php
Set to “Y”, “y”, “Yes” or “yes” to allow PHP within the tag. Default is not.
backspace
category
channel
day
debug
Set to yes and instead of results the main SQL statement and error messages are displayed, if any, regarding the value of “tie”. Messages are displayed within a div of CSS class “tied-entries-message” if you want to style that.
delimiter
When using the “entry_ids” mode, this parameter lets you present the list of entry_ids using a parameter other than the default commas.
entry_id
limit
month
orderby
mode
Current values are “full” (default), “entry_ids” and “economy”. The “economy” mode does not parse custom field names. The “entry_ids” mode limits the output to a list of entry_ids only separated by commas. You can change the delimiter with the “delimiter”¶meter.
In “entry_ids” mode, the following parameters will not work: category, day, limit, month, orderby, show_expired, show_future_entries, sort, start_on, status, sticky, stop_before, year. Also, there is no need for a closing tag.
parse
Setting parse=“inward” allows another tag to be placed within Tied Entries. This is a universal parameter for all plugins.
search:[custom field]
show_expired
show_future_entries
sort
start_on
status
sticky
stop_before
url_title
year
Variables
{tied:[single_standard_variable]}
All the channel entries single standard variables are available (though they haven’t all been tested — please add a comment if you find any that don’t work).
{tied:[custom_field]}
Text input and text area custom fields can be displayed.
Relationship fields cannot be displayed.
Date variables cannot be displayed the regular way, ie, {tied:entry_date format=”%D/%M/%Y”}. Instead, use PHP (set the plugin’s allow_php parameter to “yes” and the template’s PHP parsing stage to “output”):
<?php echo date("D/F/Y", "{tied:entry_date}"); ?>
Note that PHP’s date format codes are slightly different to EE’s own. They’re posted at PHP’s date function manual page.
Using Playa
Playa 4+ is supported only.
If you have Playa installed, you can still use both Playa and regular relationship fields in the tie parameter, but only if they are in separate steps within the tie.
In the tie, if you have a reverse/channel step lacking a filter field, ie my_channel, then if Playa is installed the plugin will only find Playa fields. You can override this behavior by setting the reverse_method to “rel” but then you can only find regular relationship fields in that step of the tie, not Playa fields.
If you filter for particular fields in your reverse/channel step, ie, my_channel:one_field|another_field then they must all be Playa fields, or regular relationship fields if you use reverse_method=“rel”.
You can mix and match Playa and regular relationship fields in separate steps of the tie, so that, eg, first_channel:rel_field_1|rel_field_2<second_channel:playa_field_1|playa_field_2 is fine.
Examples
We have a portfolio site of songs, albums and bands. Songs have an Albums relationship field songs_album while Albums have a Band relationship field albums_band. We’re listing songs and we’d like to have the band name next to each one. This is what we’d like to do:
<ul>
{exp:channel:entries channel="songs"}
<li>
{title}
{related_entries id="songs_album"}
{related_entries id="albums_band"}
(<a href="{path=bands}{tied:url_title}">{tied:title}</a>)
{/related_entries}
{/related_entries}
</li>
{/exp:channel:entries}
</ul>
In reverse, we have a list of bands and want to show 10 their songs alphabetically:
<ul>
{exp:channel:entries channel="bands"}
<li>
{title}
<ul>
{reverse_related_entries channel="albums"}
{reverse_related_entries channel="songs"}
{if "{count}"=="1"}<ul>{/if}
<li>
<a href="{path=songs}{url_title}">{title}</a>
{if "{songs_review}"}: {songs_review}{/if}
</li>
{if "{total_results}"=="{count}"}</ul>{/if}
{/reverse_related_entries}
{/reverse_related_entries}
</ul>
</li>
{/exp:channel:entries}
</ul>
But the related_entries and reverse_related_entries tags can’t be nested. So here’s how the above is done with tied entries:
<ul>
{exp:channel:entries channel="songs"}
<li>
{title}
{exp:tied_entries this_entry_id="{entry_id}" tie=">songs_album>albums_band"}
(<a href="{path=bands}{tied:url_title}">{tied:title}</a>)
{/exp:tied_entries}
</li>
{/exp:channel:entries}
</ul>
And:
<ul>
{exp:channel:entries channel="bands"}
<li>
{title}
<ul>
{exp:tied_entries this_entry_id="{entry_id}" tie="<albums<songs" limit="10" orderby="title" sort="asc"}
{if "{tied:count}"=="1"}<ul>{/if}
<li>
<a href="{path=songs}{tied:url_title}">{tied:title}</a>
{if "{tied:songs_review}"}: {tied:songs_review}{/if}
</li>
{if "{tied:total_results}"=="{tied:count}"}</ul>{/if}
{/exp:tied_entries}
</ul>
</li>
{/exp:channel:entries}
</ul>
Note that each reverse relationship can result in many entries, while each relationship can result in only one.
Thanks
Thanks to Yvonne Martinsson of fellow EE Pro Network member Studio.Freewheelin for initial testing./a¶ mode, this parameter lets you present the list of entry_ids using a parameter other than the default commas.
entry_id
limit
month
orderby
mode
Current values are
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
Adam Khan
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.
Tue 11 Nov ’14
8:11am
Anderson
The perfect information on the perfect web page..
ICC Cricket World Cup 2015 Schedule
http://www.cricketworldcup2015schedule.com/
Easy women Hairstyle 2015
http://www.easywomenhairstyles.com/
Sat 22 Nov ’14
5:41am
cmp murah
You got a very good website, Glad I found it through yahoo.
Sun 25 Jan ’15
4:08pm
Earl
Info Short Hairstyles and Haircuts for Men and Women with different Styles.
Thu 5 Feb ’15
2:26am
pregnancy miracle guide
thank you.
Sat 4 Apr ’15
4:56am
harga ace maxs
harga obat
Tue 21 Apr ’15
10:35am
mahafuz-newsSEO
Tied Entries is compatible with each EEv1.x and EEv2.x. The EE2 version is totally compatible with Play 4; the EE1 version works with Play three and older however solely, passively, that is, in reverse relationships.
Sat 9 May ’15
9:37am
Web_Developer_Australia
I have landed on a useful site and found it pretty informative. The video was really interesting.I would recommend the same to my friends too. I have book marked your page for further updates. Keep up your good work. Regards
Sat 9 May ’15
6:22pm
Web_Developer_Australia
A mind blowing article is provided here. And it is written with great skill and the words directly explain the thought of author.
http://www.biggshark.com
Tue 2 Jun ’15
3:54am
Susan
I visit your site first time. You did really good work. Thanks a lot for sharing this type of sharing this type of unique and different post… Buy online our ground reinforcement mesh from http://groundreinforcementmeshuk.co.uk
Mon 22 Jun ’15
4:36am
Ririn
Thanks for sharing nice information with us. I like your post and all you share with us is uptodate and quite informative.Once again, thanks for sharing it.
Sun 30 Aug ’15
8:00am
class rings
Technology is nothing. What’s important is that you have a faith in people, that they’re basically good and smart, and if you give them tools, they’ll do wonderful things with them.
Sun 6 Sep ’15
4:54pm
Hotel limone gardasee
We’ve demonstrated a strong track record of being very disciplined with the use of our cash. We don’t let it burn a hole in our pocket, we don’t allow it to motivate us to do stupid acquisitions. And so I think that we’d like to continue to keep our powder dry, because we do feel that there are one or more strategic opportunities in the future.
Sun 6 Sep ’15
5:00pm
bootsvermietung gardasee
We want to reinvent the phone. What’s the killer app? The killer app is making calls! It’s amazing how hard it is to make calls on most phones. We want to let you use contacts like never before - sync your iPhone with your PC or mac.
http://hotelzorzi.de/
Thu 17 Dec ’15
4:50am
dokter
I like the post format as you create user engagement in the complete article. It seems round up of all published posts. Thanks for gauging the informative posts.
Tue 1 Mar ’16
12:56pm
kamaraj
nice and quite to read
Sat 19 Mar ’16
1:07pm
ami
good As there’s an alternative of invitation buddy button in the program SHAREit for PC Download Windows 7/8/8.1/10, Mac Free It’s possible for you to see two distinct choices called “Send” and “Receive”. How to download SHAREit on PC great.
Wed 13 Apr ’16
11:29am
dogra
Very good article! This is a highly beneficial blogging site which you have.
AMC Services
Sat 16 Apr ’16
7:35am
diva
good most current variation Home windows 10 and it is certainly obtainable for both 32 tad and 64 tad. Mobdro Premium APK Mobdro For Computer is certainly most current iphone app or nice.
Tue 3 May ’16
6:54am
Tomcast
I really appreciate the good quality content you are posting here for free.All I can say that i really enjoyed reading this amazing post. Here we introduce the best Web Designing Company In Kerala,At TSS(Tomcast Service & Solutions), it means achieving real business results that allow you to transform, and not just maintain, your operations. Our IT services, industries solutions, and outsourcing bring you a level of certainty that no other competitor can match. What We Do TSS defines, designs and delivers technology-enabled business solutions that help Global companies win in a Flat World. TSS also provides a complete range of services by leveraging our domain and business expertise and strategic alliances with leading technology providers.
Tue 28 Jun ’16
6:08am
dev
good The Kodi person works on many functioning devices like : kodi tv addons the features of both merely my setting up this basic add-on. nice.
Thu 11 Aug ’16
3:30pm
Kerry Darlington
Lovely post. It gives a great insight. Well written.
Sat 13 Aug ’16
7:27am
punit
good BlueStacks App Player is easy to use and it’s free of cost Nox App Player switch that enables you to stick to Andyroid on sociable mass media. nice.
Thu 25 Aug ’16
11:03am
James Smith
good to promote you everything you want to find out about Kodi. https://www.shareitdownloadforpc.com/ Android for Glass windows permits you to enjoy Videos, kodi app latest nice.
Sat 27 Aug ’16
11:01am
Sarkari Result Wale
I visit your site first time. You did really good work. Thanks a lot for sharing this type of sharing this type of unique and different post… Buy online our ground reinforcement mesh from https://www.sarkariresultwale.com/
Thu 29 Nov ’18
9:16pm
sakari result
Security And Exchange Board Of India SEBI Are Invited For The Post Of Assistant Manager Gernal, Law, Civil, Electrical And Other Post Those Condidates Are Intrested To Apply Online Read The Full Notification Before Apply
Thu 29 Nov ’18
9:17pm
sakari result
great artical sir, its so helful to us, the information is so helpful
Sat 22 Dec ’18
6:44am
Michel Foster
Wonderful article grate presentation , which is help to gather more information.
Thank You for sharing.
Thu 3 Jan ’19
2:46am
Sara
Fantastic article. Thank you so much!!
Thu 3 Jan ’19
2:49am
Johhny
Well done!! ><a href=“http://www.birminghamconcreteremoval.com”>Birmingham Concrete Removal</a
Thu 10 Jan ’19
2:06pm
Sara
Great job!!! Thank you so much for all that you do!!
Sarah w/Birmingham walls
Thu 7 Feb ’19
1:00am
Guillermo Aquino
I hope it’s compatible soon, I can’t wait to use your product. Might even come in handy for our IT company
Sat 9 Feb ’19
8:11am
Jon Mcee
This means a lot. Great stuff for posting. Anyone like realistic fantasy ?
Mon 8 Apr ’19
2:06am
Terry
Great post it was a pleasure to read. We all enjoyed it over here at Carmel Painting Pros
Fri 10 May ’19
7:36pm
johnb61741
Thanks so much for this information. I have to let you know I concur on several of the points you make here and others may require some further review, but I can see your viewpoint.
barber salt lake city
Tue 14 May ’19
8:23pm
jamsaa
Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up.
international freight forwarding
Tue 28 May ’19
8:04am
Cassandra D. Everhart
I found this article very interesting and informative. It will definitely add to our knowledge.
Sun 9 Jun ’19
12:25pm
jamsm
You make so many great points here that I read your article a couple of times.
taroko gorge tour
Thu 8 Aug ’19
7:21am
papa
Nice post, if you need to find a a lady, try nice movies for sex now Nice post, if you need to find cutr girl, try best movies for sex now
Thu 13 Feb ’20
2:29pm
osama shk
Excellent information on your blog, thank you for taking the time to share with us. Amazing insight you have on this, it’s nice to find a website that details so much information about different artists.
taiwan coronavirus
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