Hi
I have been surfacing news articles based on a custom content type to a home page using the new Content Search. My content type has a mixture of standard site columns and managed terms. Now like the old CQWP, I want to filter on items that have Yes/No Site column value.
- My Site Column is automatically added Managed Property with non editable attributes (Editable, Queryable etc) and can be viewed my SC: Search Schema
- I can display it as one of the Property Mappings in the Web Tool Part panel
- It shows a “Yes” or “No” value under my rollup image
- I then refine my query and can select the a property (site column) as I build up my query as in only return items when IsTheBestDayofWeekFridayOWSBOOL manual value equals “Yes”
path:”http://MyPORTAL” ContentTypeId:0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007048130EC3DB064584E21995537AF39* IsTheBestDayofWeekFridayOWSBOOL=”Yes”
attempt to filter on my managed property does not show any of my articles – I am assuming my syntax is wrong rather than the SIte column not in the index since it appears to be crawled.
How hard can this be!!!!!!
Actually by a a bit of divine inspiration over the weekend ( a Beamish Stout!) the answer came to me.
thinking about it booleans tend to be 1 or 0 as in
1 = true or Yes
0 = false or No
So I simply changed this
IsTheBestDayofWeekFridayOWSBOOL=”Yes”
for
AND
IsTheBestDayofWeekFridayOWSBOOL=”1″
— the query test worked and I can see that query will result in my articles being display or not depending the boolean value set in in the article page.
