Date Filter issue

Hello All,

I need help in adding a date filter.

.

But getting a ora exception, the columntype is “timestamp”

Hi @Sidhant
Can you show the query?
Or check the browser console’s Network-tab to see the request/response data and verify the query - or activate logging on your database server to see the actual query.

Hi Flamber,

Below is a very specific query:
SELECT
a.apn_name,
a.apn_ip,
c.plan_name,
c.plan_code,
d.display_value AS bill_frequency,
c.list_price,
a.ingested_on AS onboarded_date,
om.ORDER_COMPLETE_DATE as change_plan_date

FROM
m2mdb.order_master om
INNER JOIN m2mdb.sim_master a on om.msisdn=a.msisdn
INNER JOIN m2mdb.customer_master b ON a.customer_id = b.customer_id
INNER JOIN m2mdb.promotional_plan c ON a.plan_id = c.id_key
INNER JOIN bill_frequency_mstr d ON c.bill_frequency_type_id = d.id_key
INNER JOIN m2mdb.circle_master e ON a.circle_id_key = e.id_key

WHERE
om.ORDER_TYPE=‘CHANGE_PLAN’ and om.ORDER_STATUS=‘SUCCESS’ and b.customer_account_number like {{category}} and {{date}}
ORDER BY
customer_name,
a.activation_date

the first category is working perfect date is giving error

Found that because of table alais, its not working any fix or alternative for same?

Correct, currently aliases are not supported.
Go and upvote by clicking :+1: on the first post: