Hello d.haeni,
You might need to use run sql car select + column + from car:tbl_billing_data where + column + (like,in,between,etc).
Example:
run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from car:tbl_billing_data where callingpartynumber in ("7140","5750")
This will provide the calls where the calling party number was 7140 and 5750 for example.
Result:
call_type callingpartynumber originalcalledpartynumber datetimestamporigination
========= ================== ========================= ========================
S 5750 1208743XXXX 2018-02-05 15:23:10
S 5750 1209401XXXX 2018-02-05 11:47:56
You can also use a Date Range by adding the "and" and "Between" statement as the example below:
run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from car:tbl_billing_data where callingpartynumber in ("7140","5750") and datetimestamporigination between "2018-03-01 00:00:00" and "2018-03-29 23:00:00"
I hope this helps!!
Thanks,
Gerson Fabian Morales Marin