I have defined a domain that joins a few tables, and I'd like to limit the result set by applying a pre-filter that will only return recent (last 30 days) of records. I am using SQL server, so the SQL syntax would be:
where MyTable.DateTimeField > getdate() - 30
If I add a pre-filter using an absolute date, I see the following in the exported domain XML:
And this works fine. How can I change the absolute day to TODAY - 30? I have tried many combinations. I have looked at the semanticlayer.xml, but nothing seems to work. Any help would be grately appreciated!
Using relative dates in a domain pre-filter
in Products
Posted
I have defined a domain that joins a few tables, and I'd like to limit the result set by applying a pre-filter that will only return recent (last 30 days) of records. I am using SQL server, so the SQL syntax would be:
where MyTable.DateTimeField > getdate() - 30
If I add a pre-filter using an absolute date, I see the following in the exported domain XML: