Skip to Content
0
Former Member
Feb 15, 2011 at 12:22 AM

building expressions in MDM

42 Views

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