https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/105513.aspxMon, 15 Feb 2016 15:41:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105513Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105513.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=105513They weren't added for SharePoint lists until InfoPath 2010, so I think even for long time form designers they are sometimes missed. They are great for equivalence - This Thing is equal to That Value - but for anything more complex, you can use REST, like This Thing is greater than That Value. :)https://www.infopathdev.com:443/forums/thread/105507.aspxSat, 13 Feb 2016 01:25:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105507Mark Helberg0https://www.infopathdev.com:443/forums/thread/105507.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=105507That worked fantastic! I never knew what the purpose of the query fields were before, thank you.https://www.infopathdev.com:443/forums/thread/105505.aspxFri, 12 Feb 2016 22:40:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105505Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105505.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=105505In your list connection, set it to not query on load (this is a checkbox on the last dialog of the list data connection wizard). In your form, when the user selects a category, set the category query field in your list data connection (the data connection has query fields and data fields) to the selected category. Then add a rule to query the data source. This should limit the returned rows. You may still get an error because of the list threshold, in which case, add an index to the category field in the list settings. Make sense?https://www.infopathdev.com:443/forums/thread/105504.aspxFri, 12 Feb 2016 22:23:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105504Mark Helberg0https://www.infopathdev.com:443/forums/thread/105504.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=105504Yep, I was querying all 8000 rows. Probably the problem? There is a category that I could have the user select from a dropdown. What column(s) would I need to index and then how do you limit the query results based upon the category? By filtering in the query action?https://www.infopathdev.com:443/forums/thread/105503.aspxFri, 12 Feb 2016 22:13:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105503Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105503.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=105503I wasn't clear, sorry. Is there information in your form you can use to determine what rows you need from the list? Like - the user selects a department, and you know you only need rows that match that department? You aren't currently querying for all 8000 rows, are you?https://www.infopathdev.com:443/forums/thread/105502.aspxFri, 12 Feb 2016 22:07:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105502Mark Helberg0https://www.infopathdev.com:443/forums/thread/105502.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=105502Would I add an index to the ID field? I can do that, but then how do I limit the number of rows returned in the query?https://www.infopathdev.com:443/forums/thread/105501.aspxFri, 12 Feb 2016 22:01:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105501Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105501.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=105501Can you add an index to the list? I've found that on a list that exceeds the threshold, if there is an index, and if I use query fields to limit the number of rows returned, I can get past the list threshold.https://www.infopathdev.com:443/forums/thread/105500.aspxFri, 12 Feb 2016 21:57:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105500Mark Helberg0https://www.infopathdev.com:443/forums/thread/105500.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=105500I have a scenario where I have a list of about ~8000 rows. I need to query that list to return a few values based upon a user input ID number. The query was working fine when the list size was around 2000 rows, but now that it is close to 8000 I receive an error that the number of items returned has exceeded the limit. I'm thinking that I need to split the large list into multiple smaller lists and sequentially query each list until the ID is found and values are returned. For example, query list A, if not found, query list B, etc. Does anybody know of a way to do this efficiently through rules?