I have created a managed property TaskDueDate linked to ows_DueDate(Date and Time) which I would like to display in my search query results. However the query doesn't return any values for taskDueDate.
Any ideas how I can display my custom managed property? (It looks like the KeywordQuery has the SelectProperties.Add method to achieve this)
string currentUser = SPContext.Current.Web.CurrentUser.Name; string searchQuery = "select title, path, priority, assignedto, TaskDueDate" + " from scope()" + "WHERE \"scope\"=\'All Tasks\'" + " and assignedto = '" + currentUser + "'"; FullTextSqlQuery query = new FullTextSqlQuery(SPContext.Current.Site); query.ResultTypes = ResultType.RelevantResults; query.QueryText = searchQuery; ResultTableCollection results = query.Execute();