Login | Sign up | Toll-Free: 1-800-752-0455
 
 

Forum

 

2 posts by 2 authors in: Forums > CMS Builder
Last Post: October 27, 2017

Hi Guys,

I'm wondering why (by design) the leftJoin dose not return the foreign system fields? (such as createdDate, createdByUserNum etc.) (besides for num)

The foreign system fields are being filtered in 'lib/viewer_functions.php' around line 370.

Thank you

Hi Brownleather, 

The undocumented "leftJoin" option for getRecords is a bit of an experiment/hack.  We use it ourselves from time to time, but I was never super happy with it.  I didn't find it much simpler than writing join queries.  In any case, if it's working for you there's no reason to stop using it and we can see about getting it to return the fields you need.

If this the code that's filtering out the fields:

// add fieldnames to SELECT
$foreignSchemaFields = getSchemaFields($foreignTable);
$validFieldTypes = array('textfield','textbox','wysiwyg','date','list','checkbox');
foreach (array_keys($foreignSchemaFields) as $fieldname) {
  if (in_array(@$foreignSchemaFields[$fieldname]['type'], $validFieldTypes) || @$fieldname == 'num') {
    $selectFields .= ",\n                           $foreignTable.`$fieldname` as `$foreignTable.$fieldname`";
  }

Then it's because the fields you mentioned have a type of 'none' that's not listed above.  Try this patch: 

// add fieldnames to SELECT
$foreignSchemaFields = getSchemaFields($foreignTable);
$validFieldTypes = ['textfield','textbox','wysiwyg','date','list','checkbox'];
$validFieldNames = ['num','createdDate','createdByUserNum','updatedDate','updatedByUserNum'];
foreach (array_keys($foreignSchemaFields) as $fieldname) {
  if (in_array(@$foreignSchemaFields[$fieldname]['type'], $validFieldTypes) || in_array($fieldname, $validFieldNames)) {
    $selectFields .= ",\n                           $foreignTable.`$fieldname` as `$foreignTable.$fieldname`";
  }

Let me know if that works for you or any other issues and I can add it to the next release.

Dave Edis - Senior Developer
interactivetools.com