InfoPath Dev

Hello everyone, I am currently trying to filter my list datasource. It works great but when it comes to a people-column (author) there is a strange behaviour. First of all the author-column is a simple text-field in queryFields. When I try to filter this field with userName() there is no return (but actually the list is full of items with current author). What can I do to filter for a specific user? Next, when I look at the dataFields, I see what I also expected in queryFields: (pc:Person with DisplayName, AccountId, AccountType). When I output DisplayName it shows up like this: Surname,, GivenName. Why two commata? Hope you can help me out. Infopath 2010, Sharepoint 2010 Std.

It's me again still having the problem. Can nobody help me out? Maybe I did not explain the problem clearly enough?

 Hi - my domain account is DOMAIN\HilaryS. I created a data connection to a list with a person or group column - column named "User". I set the "User" query field to DOMAIN\HilaryS and executed the data connection - I only had returned the rows that had my account ID. So, I'm not sure what you are doing differently? Are you querying for DOMAIN\UserName?

It's odd that you were able to query the Person or Group field from a SharePoint list within InfoPath 2010/2013. Maybe I'm missing something. When I try to set a query fields value all of the fields show up except Person and Group fields.

 Is there something extra I need to do to set a fields value and it query the SharePoint list for Person and Group?

Thank you.  

Hello, I know this thread is old but I found a solution to this problem. Maybe it will help someone :) The part that Hilary Stoupa didn't mention is that you have to go in your list with the people or group column and go to it's settings and set: Show field - account. That way when you are querying form InfoPath it will match the id.