I need to query a SharePoint list and specifically the Author column with a given login in the form "domain\username".
I read that I must switch the column's "Show Field" property to "Account", but unfortunately that would be too disruptive for our users, who are used to the friendly name.
In addition to that, I don't have the user SharePoint ID, just the login. Did I run out of options? Many thanks.