- This topic is empty.
- 02/19/2013 at 3:28 am #5364
Since you're using qSIListView you need to filter that data at the stored procedure/query level (recommended way).
There is another option and that is Complex Filter. Please check our documentation for more details.
- 02/19/2013 at 3:33 am #6078
already using complex filter – I see where we can Add to a date – I'm looking for an easy way to subtract from the date. If we have to do it with a SP/Method sobeit – just thought there might be someone smarter than me that figured this out. I can show everything for the current day – just want to include prior day activity as well.
- 02/20/2013 at 8:55 am #4421
We have SP2010 and Quest web parts 5.7. Using the qsilistview we are trying to set a complex filter to limit the return values to those happening on the current day and the day prior. may we try something like this:
- 02/20/2013 at 8:55 am #6077
From the performance point of view filtering the data at the server (SQL, Oracle, etc) level is recommended.
Also is easier to build your filter condition at the server level instead of using the Complex Filter.
- 02/20/2013 at 12:39 pm #5366
CAML filtering is pretty efficient from a SharePoint perspective. You should be able to set the CAML Filter property to something like "where datefield equals today or datefield equals today minus one".
- 02/20/2013 at 12:55 pm #6080
uses qSIListView wp and it has no CAML Filter property.
Your idea is good and it works for qListView.
- 02/20/2013 at 12:59 pm #6079
Oh, okay, sorry I misread the post. Yes, filtering at the sql query level would be the most efficient way to do this then. Thanks for the clarification.
- 02/21/2013 at 10:47 am #5368
add this to the complex filter:
datefield=[TODAY] OR datefield>=AddDays([TODAY], -1)
Documentation on the complex filter:
FieldName comparison-operator FieldExpression
Comparison operator is one of these: =, <> (not equal), <, >, <=, >=, LIKE
FieldExpression can be one of the following:
String – A string is enclosed with single quote; for example 'Accounting'. A string can contain wild-card character % or * when used in conjunction with the LIKE operator. For example: 'M%', 'M*'. A wild-card character is not allowed in the middle of a string. Therefore, this expression is illegal: 'Te*xt'
Numbers – Numbers are not enclosed. For example: 20, 20.5, 0.5. If you enclose a number with a single quote, it will be treated as string.
Dates – For example: February 5, 2005 11:50 PM is #2005-02-05T23:50:00Z#.
[ME] – This expression will be replaced with the name of the currently logged-in user.
[TODAY] – This expression will be replaced with midnight of today's date.
[NOW] – This expression will be replaced with the current date and time.
Date function – The following date functions are supported: AddSeconds, AddMinutes, AddHours, AddDays, AddMonths and AddYears. Their syntax is DateFunction(dateValue, number). For example: AddDays([TODAY], 7) adds 7 days to today's date
- 02/21/2013 at 10:56 am #6082
thanks Carl! tried this and it works!
You must be logged in to reply to this topic.