Thread

Hello, I need to query 2 weblogs and I’m confused about the best way to do it. The first one of my weblogs has some entries. The second one has relationship custom field that allows to select a weblog1 entry.

Weblog 1
Books
Magazines
Records

Weblog2
Frank Zappa, Records (relationship field)
Capote, Books (relationship field)

I’d like my page shows this information:

Books > Capote
Magazines >
Records > Frank Zappa

So, it should query weblog1 alphabetically and then extract related information from weblog2.
I will appreciate any help with this.
Thank you.

[Mod Edit: Moved to how-to forum as its more appropriate]

dolmance, if I’m understanding your setup, here’s a simplified example:

{exp:weblog:entries weblog="weblog1" orderby="title" sort="asc"}

<h2>{title}</h2>

<p>{reverse_related_entries}<br />
    {title}</p>

<p>{/reverse_related_entries}</p>

<p>{/exp:weblog:entries}

Querying related weblogs is pretty complicated IMO, I’ve struggled with it a lot recently. 
Here’s a thread with some info that helped me:
http://ellislab.com/forums/viewthread/48695/
but I found about half of the things I needed to do required PHP and not just the query module

Thanks ruraldreams, though it looks like Dolmance’s weblogs are setup with relationships already in a standard way that the regular EE tags can handle, which I’d certainly recommend.

yeah, me too!  I saw query and related entries in the same post and jumped to conclusions

Thanks Derek but your code doesn’t work as it gives this result:

Books
Magazines
Records

there are no related entries :(

Is the relationship field in weblog1 or weblog2?  It would seem best served in weblog2, but again, I do not know your data structure.

The relationship is on weblog2

It should work as I have described, then.  Other things to look for are custom statuses, expired / future dated entries, etc.  If you want to email (not PM) Super Admin access to me, I can take a quick look at the data structure so I can give more targeted advice.

OK, finally it worked on firefox. Safari was giving me an stupid error. I did it on a EE Pro. Does it work also on a EE Core?

What error?  There’s nothing browser specific about the code sample I gave you above.  The browser doesn’t affect what content ExpressionEngine outputs.  And yes, the Core version supports relationships identically to the licensed versions.

This is the safari error:

Safari can’t open the page “http://www.web.com/blog/news/”. The error was: “bad server response” (NSURLErrorDomain:-1011) Please choose Report Bug to Apple from the Safari menu, note the error number, and describe what you did before you saw this message.
 
But don’t worry because I think it’s an htaccess problem.

I’m trying that code on Core and it dosen’t work. It shows just the weblog1 entries. Any idea?

That error can occur if the script crashes, which can happen for instance if the memory usage exceeds the allotted amount on servers where PHP is being run as a CGI process.  It can also happen if .htaccess causes a loop, though, so yes, I would try eliminating that first.

I cannot guess as to why it’s not working for you on Core.  The difference would have to be in your data, not the files.  How did the information get into your Core database?

Both sites (Pro and Core) are very similar. I’ve checked the weblogs and custom field preferences and they are the same. I don’t know why it’s not working on Core :(
Any other idea?

How did the information get into your Core database?  Are these imported?  Expired entries?  Future entries?  I cannot guess, dolmance, as you aren’t giving enough information or answering all of my questions.  My offer to log in and look stands, but the answer lies in your data itself, not in any preferences or things looking “very similar”.