Forum Discussion

mkowalkowski94's avatar
mkowalkowski94
Frequent Visitor
8 years ago

URL filter greater than numeric

Hi,

 

I am trying to use url filtering feature, and I have a problem.
I try to filter report on numeric field (great than X), and a time field (not older than X hours/days) and I tried URL?filter=Table/DateTimeColumn ge '2017-10-30T00:00' (or some other value) but it's not working.
Can I filter by date time field?
What other quantifiers are supported? Only 'eq'?

Thanks,
Michał

Need Help

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi mkowalkowski94,

    As mentioned in the official blog, it's a limitation for "Filter a report using query string parameters in the URL". URL query string can filter only string value.  It doesn't apply to date or numeric fields. Please review this feature request and vote it.


    • Field type has to be string.

    • Table and field names cannot have any spaces.





    Best Regards,
    Angelia