如何实现近期记录筛选
【问题】
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:
MyTable.DateTimeField > ts’2014-11-11’
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!
【回答】
用 SPL 可以很方便的实现 sql 的查询，并且方便的传递从今天起前 30 天（今天 -30）时间段的参数：
| | A |
|---|---|
| 1 | return myDB1.query(“select * from MyTable where DateTimeField>?”,now()-30) |
A1：查询并返回从今天起前 30 天的记录，MyTable 和 DateTiemField 可以根据自己的实际表信息填写。
