5 users online. Create an account or sign in to join them.Users

Search

Hi,

I’m new to Symphony. I have 2 linked sections: ‘members’ and ‘publications’. I want to create page, which outputs individual information and all publications for user. Each publication have a field ‘Authors’ with type Member Link. So after I output all information about user from ‘members’ I also want to put information about his publications, I made it by Data Source Chaining, but it contains logins as ‘Authors’, so I need here to place their real names. In SQL it can be solved by INNER JOIN, but here I have no idea how to solve it.

Sincerely yours, Dmitry S. Kravtsov

It sounds like you are using the member link field from the members extension. Try the standard select box link field. You can use the id or a handle for datadource chaining.

Thanks a lot, it work! not in a way I wanted, but good enough.

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.2 or above
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.0 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details