Forum Discussion

My-atix's avatar
My-atix
Copper Contributor
Sep 05, 2020

Highlighted Content WebPart and Managed Property Filter HELP

I am hoping someone might be able to assist with a little challenge I have been fighting with in a SharePoint Online Communication Site.   Scenario: I am trying to use a Highlighted Content WebPar...
Lists
SharePoint Online
pointconsulting's avatar
pointconsulting
Copper Contributor
Sep 06, 2020
Hi Susan,
First let me say how much I loved you Governances guidance and sessions you have done.

To answer your question yes I have:

It returns all Sales posts no matter the owstaxidBusinessrole and all Director posts no matter what the owstaxidBusinessFunction is.

Example results:

In other words all posts with the below metadata.

Sales Director
Sales Dept. Manager
Sales Sales Rep
Sales Employee
Marketing Director
Technical Director

Any other ideas would be gratefully appreciated. 🙂
Susan_Hanley's avatar
Susan_Hanley
MVP
Sep 06, 2020
Thanks for your kind words. If you want to ensure the AND query and that is not what you are seeing, you will probably need to use the custom query option. The syntax is more complicated but you should be able to get exactly what you want.
  • myatix's avatar
    myatix
    Copper Contributor
    Sep 07, 2020

    Ya I have also tried that but CAML queries don't appear to work at present and KQL only supports queries on the current site collection as far as I can see. 😞 The whole query/ filter functionality seems very flaky at the moment.

     

    The question is why doesn't "Doesn't contain" work as expected. 😉 This appears to be a bug as does the fact that the webpart says you can use either CAML or KQL but CAML isn't working.

     

    Or perhaps I am doing something incorrect?

    <Query>
    <Where>
    <And>
    <Contains>
    <FieldRef Name='Function' />
    <Value Type='TaxonomyFieldType'>Sales</Value>
    </Contains>
    <Contains>
    <FieldRef Name='BusinessRole' />
    <Value Type='TaxonomyFieldType'>Director</Value>
    </Contains>
    </And>
    </Where>
    </Query>

     

     

      • myatix's avatar
        myatix
        Copper Contributor
        Sep 07, 2020

        Susan_Hanley 

         

        I thought I should point out this is an issue that over 900 others are fighting with according to uservoice. I am happy I am not going mad... 😉 It would appear this is a major problem with the way that the filter functionality has been implemented in the "Highlighted Content" and "New" webparts. Please read the uservoice suggestion for further details.

         

        But to cut it short if you use multiple columns and refer to the same column twice it acts as an OR not and AND statement, making it very difficult to implement a filter that subtracts results.

         

        Please vote for this if you are also having the same issue. (See link below)

        https://office365.uservoice.com/forums/264636-general/suggestions/32071210-highlighted-content-web-part-allow-multiple-fil%C2%A0