Tweet
Hello,
I have a custom view/button action (AllSelected with custom search).. all work fine .. but how build sql query from data send backend ?
this is the result of var_dump received on backend.
(for this moment, I try with a GET.. but if I understand, I will do a POST)
My goal is just build the sql query with this data
Regards
I have a custom view/button action (AllSelected with custom search).. all work fine .. but how build sql query from data send backend ?
this is the result of var_dump received on backend.
(for this moment, I try with a GET.. but if I understand, I will do a POST)
My goal is just build the sql query with this data
PHP Code:
]{ ["ids"]=> array(0) { }
["where"]=> array(2) {
[0]=> array(3) { ["type"]=> string(2) "in" ["attribute"]=> string(6) "status" ["value"]=> array(1) { [0]=> string(7) "Planned" } }
[1]=> array(5) { ["type"]=> string(7) "between" ["attribute"]=> string(9) "dateStart" ["value"]=> array(2) { [0]=> string(10) "2019-01-01" [1]=> string(10) "2019-02-28" }
["dateTime"]=> bool(true) ["timeZone"]=> string(15) "Europe/Brussels" } }
["selectData"]=> array(1) {
["select"]=> string(88) "name,type,location,parentId,parentType,parentName,accountId,accountName,status,dateStart" }
["byWhere"]=> bool(true) }