locked
SharePoint Search Results Limited to 50 RRS feed

  • Question

  • SharePoint Search Results Limited to 50

    Asked By Michel Bechelani
    28-Jun-07 11:31 AM
    Hello,
    
    I built a custom search for a MOSS 2007 site.  I'm using the
    FullTextSQLQuery object to search a forms library with custom columns.  The
    SQL string looks like:
    
    SELECT OrderNumber FROM SCOPE() WHERE "scope"='OrderLibraryScope' AND
    CONTAINS(OrderNumber,'"500*"') AND (VendorID='49709' OR VendorID='17778' OR
    VendorID='41521')
    
    However, if the search result is supposed to return, let's say, 300 records,
    the resulttable returned by the Execute method only contains 50 items.  I'm
    wondering if some kind of paging is being used, and how can I override it?
    Or do I need to specify something else on my query? Or is it some
    configuration setting in the MOSS 2007 server?
    
    Any help would be greatly appreciated.
    • Moved by Jesse Jiang Wednesday, January 4, 2012 7:32 AM (From:Visual Studio Smart Device Development – Visual Basic and C# Projects)
    Tuesday, January 3, 2012 5:23 AM

All replies

  • Hi Rathi,

    I am afraid you posted your question in the wrong forum. This forum is for smart device development prior to Windows Phone 7.

    For better help you better post your question in one of the sharepoint fora.

    http://social.msdn.microsoft.com/Forums/en-US/category/sharepoint2010

     

     

    • Proposed as answer by Jesse Jiang Wednesday, January 4, 2012 7:30 AM
    Tuesday, January 3, 2012 6:46 AM
  • Hi Rathi,

     

    You can create a new thread in sharepoint forum, and I will move this one to off-topic.

     

    Thanks for your understanding,

     

    Best regards,

    Jesse


    Jesse Jiang [MSFT]
    MSDN Community Support | Feedback to us
    Wednesday, January 4, 2012 7:32 AM