I'm pulling a list of employees from SharePoint into a web part. I did the following:
- mapped the Hire Date user profile property to the createTimeStamp AD property
- created a managed property in the Search Service Application and mapped it to the People:SPS-HireDate(Date and Time) crawled property
- used PowerShell to set FullTextQueriable to true for Hire Date
- ran a full profile sync and a full crawl
Then in my web part, I used FullTextSqlQuery with the following query text:
SELECT PreferredName, Department, WorkEmail, HireDate FROM SCOPE() WHERE \"scope\" = 'People'
PreferredName, Department, and WorkEmail all return data, but HireDate does not. Why am I not getting any data for HireDate?
Update: There is data in the createTimeStamp attribute in AD that is supposed to be imported into Hire Date. For some reason, the Hire Date property is not used in any user profiles, even though I've marked it required. I tried querying the user profile via PowerShell, and it returns values for other attributes, but not HireDate. It seems like the createTimeStamp data is not getting imported into SharePoint during the user profile sync, for some reason.