You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I need to use a custom query to fetch data from two tables join them and display in a table in
front end and use date pickers to filter the records which i get from the query
how I did
I created a table component and used this query as my data source
I created a filter so that i can select the date column and check for date <= mydate(from datepicker)
the issue i am facing is I dont get the options of Less than or equal to or more than or equal to to
use in my filter
the only options i see are Equals, Not Equals, Start with, like, is empty, is not empty, is in
howeever i found that if i use a mysql table directly as my data source or use a dataprovider which
in turn uses mysql table as the data source for my table component, i get the <= or >= option
However I cant use a table directly as I have to combine the two tables and use a custom query
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
My requriement
I need to use a custom query to fetch data from two tables join them and display in a table in
front end and use date pickers to filter the records which i get from the query
how I did
I created a table component and used this query as my data source
I created a filter so that i can select the date column and check for date <= mydate(from datepicker)
the issue i am facing is I dont get the options of Less than or equal to or more than or equal to to
use in my filter
the only options i see are Equals, Not Equals, Start with, like, is empty, is not empty, is in
howeever i found that if i use a mysql table directly as my data source or use a dataprovider which
in turn uses mysql table as the data source for my table component, i get the <= or >= option
However I cant use a table directly as I have to combine the two tables and use a custom query
Can anyone suggest how to solve this
Beta Was this translation helpful? Give feedback.
All reactions