Too many items retrieved from sharepoint list? - InfoPath Dev
in

InfoPath Dev

Too many items retrieved from sharepoint list?

Last post 05-31-2011 10:59 AM by ErnestoM. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 05-31-2011 08:29 AM

    Too many items retrieved from sharepoint list?

    Reply Contact
    Hi -

    I have an Infopath form that retrieves data from a sharepoint list that has approx 2300 items. There is a filter in the form to only display items that belong to a particular user (as defined by a user ID entered in a text box).

    The problem occurs when they clear the text box, removing the filter, and ALL items are retrieved from the sharepoint liost to display in my repeating table - the form locks and crashes.

    Any ways around this? To clear the data in that particular data connection when a field is blank to FORCE at least 3 characters to be in there or something?

    other than this I love my form :(

    Please help? :)

  • 05-31-2011 10:59 AM In reply to

    Re: Too many items retrieved from sharepoint list?

    Mark as Answer
    Reply Contact

    Out of the box there's nothing in InfoPath to allow that server-side filtering. We have a technique using qRules, documented here, but you could search online for other techniques. Good luck!

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.