Hi There,
I'm currently building a restricted catalogue for one of our connected users to view a defined subset of the items in MDM through our web connection. the restriction is done through creating MDM users and then applying a named search to that user. We are trying to restrict the view based on our taxonomy structure and to hide certain taxonomy branches from that user's view. To do this, i'm currently trying to build an expression that's looking like the following...
Field_ID <> 1234 AND
Field_ID <> 1235 AND
Field_ID <> 2345 AND... etc for about 150 branches of the structure we wish to hide.. .
This has caused two issues for me:
1) The time it takes to run this expression is prohibitive and therefore cannot be used as a named search (my preferred method)
2) The coding of this expression is 'less than elegant'..
can someone please suggest a better way to do this? Is there a where not in (value1, value2, value3...) type expression that i can use in MDM??
Regards,
Adam Sellers