Filter data on the query

[system]

We are trying to use the webi tool as a temporary data extract. I need to limit the query to pull only yesterdays records based on an universe object PostDate. The query results will be exported as a csv file. I cannot find a way to filter the query dynamically. Can someone tell me how to use functions or some other method within the query filter.

---

gtarpley (BOB member since 2013-10-02)

[system]

Welcome to B:bob:B!

What database do you use?

---

Marek Chladny (BOB member since 2003-11-27)

[system]

We are using an oracle backend. I do not seem to have the ability to modify the sql generated by the query builder. is that a configutration element or rights issue.

---

gtarpley (BOB member since 2013-10-02)

[system]

@gtarpley

We are using an oracle backend.

Then this sticky topic can help you:

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server. Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8. Yesterday cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime) Today cast(convert(char(10),getdate(),23) as datetime) The following also works for today: dateadd(dd, datediff(dd,0,getdate()), 0) Start of Current Month cast(convert(char(7),getdate(),23)+'-01' as datetime) End of Current Month dateadd(d,-1…

@gtarpley

is that a configutration element or rights issue.

Probably a right issues. However, it’s better to create in the universe a pre-defined condition using the relative dates from the linked topic and then to use the condition in a report query.

---

Marek Chladny (BOB member since 2003-11-27)