[SOLVED] Filter of the 'calc' plug-in element

[vladimir84]

I have an element "calc" in a table_names that runs a PHP query and displays text information based on a value from table_items, only the last item for the name you click.
How can I make fabrik display these calculated values in a dropdown filter above the table_names, so I can filter the table_names by the value from calc element?

Thanks.

 

[vladimir84]

Never mind, I found a patch-solution to the issue:
I inserted into the calc element an UPDATE query, so ever time I click on a single record, it's updated in the database with the value I see.
Since I have about 150 records for that database, it's not a problem, but I would like to know if I can issue a command to MySQL that would update all the records based on the calc element query

Here's a code if anyone needs it:

//update database
$db1 = FabrikWorker::getDbo(false, 2);
$query4=$db1->getQuery(true);
$query4=
"UPDATE
  dip_datipersonali
SET
sel_nome = ".$db1->quote($naziv)."
WHERE id =".$db1->quote($id);
$db1->setQuery($query4);
$db1->execute();