https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/122407.aspxWed, 12 Feb 2020 17:02:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122407Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122407.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122407Sorry I missed your other post - glad you found a work around. It could be that indexing on that field doesn&#39;t index the display name? Because I think the field we query on must be indexed once over the list threshold.https://www.infopathdev.com:443/forums/thread/122401.aspxWed, 12 Feb 2020 04:31:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122401zosburn0https://www.infopathdev.com:443/forums/thread/122401.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122401I was able to resolve my issue with a workaround using a workflow to set a single line of text column in the Secondary Data Connection list to the login ID of the people picker column value. Then, I was able to successfully set the query value to the AccountID of the people picker value in my form. Not the cleanest, but it works!https://www.infopathdev.com:443/forums/thread/122387.aspxMon, 10 Feb 2020 21:41:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122387zosburn0https://www.infopathdev.com:443/forums/thread/122387.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122387<p>Welp, I was able to produce a successful query using people picker fields on a list with under 5000 items, however the same query fails on my list with more than 5000 items. I double checked to ensure the column settings were the same across all lists used, but still no luck.</p> <p>Very strange. I&#39;m stumped as to why this would affect the query. Any thoughts? Thanks for your response!</p>https://www.infopathdev.com:443/forums/thread/122381.aspxMon, 10 Feb 2020 15:59:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122381Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122381.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122381Mine isn&#39;t a list form - but it works in the browser.https://www.infopathdev.com:443/forums/thread/122371.aspxSun, 09 Feb 2020 20:16:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122371zosburn0https://www.infopathdev.com:443/forums/thread/122371.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122371Very strange. I ran the same test after confirming both lists used identical people picker column settings with no luck. Could you attach a copy of your form? I&#39;ve attached mine. Thanks very much for your response, Hillary!https://www.infopathdev.com:443/forums/thread/122363.aspxFri, 07 Feb 2020 23:32:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122363Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122363.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122363I did a quick experiment, and with a single select person picker in a list connection, the Display Name worked for me in a query. Give that a try. :)https://www.infopathdev.com:443/forums/thread/122358.aspxFri, 07 Feb 2020 19:08:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122358zosburn0https://www.infopathdev.com:443/forums/thread/122358.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122358Hello. I am trying to query a Secondary List (8000+ items) using a people picker value from the Main Data Connection, however I am unable to figure out the correct syntax which results in the listview threshold error. I&#39;ve noticed the Query field (text) for a people picker control is not the same as the Data field (Group) - screenshot attached. I&#39;ve tried setting the secondary data connection query field to the AccountId of the main data connection people picker field, with no luck. <p>The end goal is to query for and return items from the secondary data connection related to the person in the people picker field. Any suggestions? Thanks in advance!</p>