Search

Sorry, I have a question. I'm trying to use the EntryManager to grab a filtered list of Entries related by a Selectbox-link field (field 29). I'm not extremely experienced with SQL syntax.

$tasks = EntryManager::fetch($estimateid,1,null,null,"WHERE `relation_id`=$estimateid", "INNER JOIN `e` ON `e`.id=`sym_entries_data_29`.entry_id");

Currently I'm getting an error with that code. Just trying to connect the dots, am I on the right track?

EDIT: I realize this is the kind of stuff datasources are made for. Essentially this code is in the middle of an event and going to duplicate a bunch of entries.

Use SymQL. It's far easier then using the plain EntryManager.

Hmm, I suppose. I'll admit that I was a bit worried since Nick isn't really supporting that extension anymore.

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details