Date Filter issue


#1

Hello All,

I need help in adding a date filter.

.

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


#2

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.


#3

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


#4

the first category is working perfect date is giving error


#5

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


#6

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