Element to query

[enrb]

Good morning,

I have a form with databasejoin and cascadingdropdown fields where users can choose different options.

Can I create an item that gives me the value of a query based on the choices made when filling out the form?

 

[troester]

A calc element http://fabrikar.com/forums/index.php?wiki/calculation-element/

 

[enrb]

I tried to make my query, but it doesn't return any results, also how do I insert into the query the elements to be considered for the final result of the query?

The query I made is this (following the instructions of the calc element)

$db = FabrikWorker::getDbo();
$query = $db->getQuery(true);

$query->clear()
  ->select('mytable.code')
  ->from($db->quoteName('mytable'))
  ->innerjoin($db->quoteName('mytable002') . ' ON ' . $db->quoteName('mytable.id') . ' = ' . $db->quoteName('mytable002.code2'))
  ->where(array(
    $db->quoteName('mytable.id') . ' = ' . $db->quote('{mytable002.code2}')
  ));

$db->setQuery($query);
$count = $db->loadResult();
return $count;

 

[troester]

You can use placeholders, enable ajax calculation and for php select code see also http://fabrikar.com/forums/index.php?wiki/php-common-tasks/&redirect=common-php-tasks

$db->quote('{mytable002.code2}')

This won't do, it's no placeholder.