Hi guys,
I need to understand something, using new "calculated field" function I tried to write this query for calculated field "salesTax":
SELECT ((`order_details`.`UnitPrice` * `order_details`.`Quantity`) *(`order_details`.`tax`/100)) FROM `order_details`
WHERE `order_details`.`odID`='%ID%'
It didn't works because `order_details`.`tax` come from other table (if I use a number instead field works fine).
In the hooks we were use something like that:
$taxSales = sqlValue(
"SELECT taxSales FROM products where ID='{$data['taxSales']}'"
);
How can we use that "sqlValue" in the previous query?
Thanks
Queries on appgini 5.81
Re: Queries on appgini 5.81
Hi, Take a look at this topic, I think it covers what you are asking:
viewtopic.php?f=4&t=3288
viewtopic.php?f=4&t=3288
Ron - Gloucestershire, UK: AppGini Pro V 23.15 Rev 1484 - LOVING IT!
Plugins: Mass Update + Search Page Maker + Summary Reports + Calendar + Messages
Bizzworxx: AppGiniHelper + Inline Detail View
Alejandro Landini: To-Do List + MPI + TV Field Editor
Other: Udemy Course
Plugins: Mass Update + Search Page Maker + Summary Reports + Calendar + Messages
Bizzworxx: AppGiniHelper + Inline Detail View
Alejandro Landini: To-Do List + MPI + TV Field Editor
Other: Udemy Course