Hi guys does anyone have any experience using odata feeds at all?
I am connecting to a large ERP data set so want to reduce the load times by filtering the data directly in the URL of the odata. I can happily select my columns and do some basic date filtering specifying given dates etc
But for this to be a sustainable model I really need to have relative date filtering applied to retrieve, as examples, data from the last three calendar years or the previous 60 days etc but cannot find anywhere how to apply relative date filters
Without this I am experiencing long load times as the ERP system has been in existence for a number of years