Calc element - value from database join

[ignacyw]

Hello,
i'm trying to use calc element to sum filtered data from the table.

I created a form where i use some elements to determine the filters and the calculation itself
- start_date [jdate]
- end_date [jdate]
- category [field]
- type [databasejoin]
- sum [calc]

[jdate] and [field] elements are working fine.
But when I add [databasejoin] seems that [calc] takes the label from the [databesejoin] instead of value - and so the result of [calc] is empty.

Here is the example of my [calc] field:

$db =& JFactory::getDBO();
$db->setQuery("SELECT SUM(`price_net`)
FROM (`price_table`) WHERE ((`date`)
BETWEEN '{report___start_date}' AND '{report___end_date}')
AND
((`category`)=1)
AND
((`type`)='{report_type}')
");
return number_format((float)$db->loadResult(), 2, ',', '');

 

[Trembowiecki]

Try with '{report___type_raw}' instead of '{report_type}'.

 

[troester]

$db =& JFactory::getDBO();

This is deprecated (you are in F4/J!4 forum).
Use
\Joomla\CMS\Factory::getContainer()->get('DatabaseDriver');

https://github.com/joomlahenk/fabrik/wiki/Upgrading-from-fabrik3.10-to-fabrik4

 

[ignacyw]

Try with '{report___type_raw}' instead of '{report_type}'.

Thanks a lot! Thats excatly what i needed.
Is there any documentation regarding this "_raw" addition to the name of the element? Just to understand what it does and where I can use it.

 

[wezetel]

There's a small explanation for raw-values -> http://fabrikar.com/forums/index.php?wiki/placeholders/