Loading...

Search paramter for 'Between' is not working in qsiListView

Search paramter for 'Between' is not working in qsiListView

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #4590
      Anonymous
      Anonymous
      Participant

      *I am posting on behalf of a customer*

      n

      Customer is using QuickApps 6.1 in a SharePoint 2010 environment. They are getting data from SQL Server 2008R2 and populating the columns in a qsiListView.

      n

      The issue is that for their Published_date column where they try filtering by using the operator “Between” for the datetime field there is returning “No Results” (although it should).  They do use JavaScript for the Web Part as well.

      n

      Having added the web part to a new page without JS, they get the same error. The search results will only work for the filter operator when they choose equals or is not empty or is empty. When they choose between or after or before or before or at or after or at – the search filter won’t work. They picked the search filter column as date time field for their searching.

      n

      Unforuntately we have been unable to reproduce this issue as the ‘Between’ operator works fine in our OOB environments. At this point, we assume the issue with your their JavaScript code and perhaps it exists not only on the Web Part page but on their Master Page and is corrupting the data.

      n

      Would you be able to offer any advice/suggestions on resolving this issue?

      n

      Thanks!

      n

       

      n

       

    • #7467
      Anonymous
      Anonymous
      Participant

      Hi,

      n

      This issue was not due to Javascript, but due to the stored procedure the customer was using. He was not handling the filter criterias (between, before/after) properly in the stored proc.

      n

      *Question From customer*: When you are sending the values to the store proc, how can you also pass or tell which operator is being used (for e.g.: contains, equals , between or before ? )

      n

      This is actually documented in our help document under SIListView -> Search/Filter Panel -> Filter Criteria Usage.

      n

      Also, if a user is passing the filter criteria directly to the stored proc, then it is advisable to use PassToDAOProvider as Filter Criteria Usage for better performance.

      n

      n

      n

      n

      Thanks,

      n

      n

       

Viewing 1 reply thread

You must be logged in to reply to this topic.