Forum Discussion
Modern Experience: Highlighted Content - filter for two "and" connected managed properties
Hello,
my workaround for that issue was:
create SiteCollection calculated column that will hold all your AND statement (my issue was to see Task Status + User for example all tasks for Dave and are not completed)
after creating the column add it to ContectType
add the content type to the taks list, reindex the list
go to search schema and add your own Managed Property that looks to the new column you created
now you can filter the data you need with an AND
if you cant find the column in the Management Property you will have to wait until the next Full crawl to happend
Hope that helped you
Dave
David_Vidal Hi Dave, Thank you for your post I am having the exact same issue as you! I came across your discussion here but don't really understand your workaround can you explain it in a little more detail.
I have 2 custom columns...
BusinessFunction
(With the following values)
- Marketing
- Sales
-Technical
BusinessRole
(With the following Values)
- Director
- Dept Manager
- Sales Rep
My issue is a Technical function has a Director as does a Marketing Function.
So if I have a list as follows:
Sales Director
Technical Director
Marketing Director
Sales Sales Rep
Sales Dept Manager
I can't return Sales Director????