Compatibility:
SharePoint 2010 Foundation (SPF) and Server (SPS) Windows SharePoint Services (WSS) 3.0 Microsoft Office SharePoint Server (MOSS) 2007
SPF/SPS 2010 • WSS 3.0 • MOSS 2007
User Voices
(Loading...)

FilterZen: Feedback Forum > (Advanced) Post-processing: OR

Hello Support,

We havea column with values sepeated by ";"
We used the post processing feature* to seperat the values.
Works fine but the values are presented in the dropdown choice box as: Tag 1 OR Tag 1|Tag 1.1 OR Tag 2|Tag 2.1
where the ";" is replaced with "OR"

Is it possible to get the seperated values as seperate choices in the dropdown menu? So we can select only "Tag 1"

* (Advanced) Post-processing: send multiple values for the specified filter name taken from the resulting filter name-value pair(s), separating the value(s) with:

Kind regards,
Mario

September 1, 2010 at 2:40 | Unregistered CommenterMario

Hi Mario, this is now supported in build 3.8.0.9 --- the requested behavior is activated automatically when for this List Lookup Filter (I assume it is one?), you also set the operator to Contains ( in addition to setting the separator to ";" ) and when CAML Direct filtering mode is enabled.

September 1, 2010 at 4:26 | Registered CommenterROXORITY

Hello Support,

The link build 3.8.0.9 is connected to "roxority_PeopleZen.zip"
Can you check this?

Kind regards,
Mario

September 1, 2010 at 5:19 | Unregistered CommenterMario

Fixed. Unfortunate mistake. But since you're already used to our naming scheme I'm sure you already got the right file by now =)

September 1, 2010 at 5:35 | Registered CommenterROXORITY

Hello Support,

OK. works fine. But I have a request.
We want to filter on a tagging field where the text items are seperated with commas "," and "|" (don't now the name)
Is it possible to enter multiple seperators in the "post processing feature" field??

Kind regards,
Mario

September 1, 2010 at 6:42 | Unregistered CommenterMario

That "|" is the so-called "pipe". Multiple separators are not really supported in this scenario and context. Just out of curiosity, what kind of tagging logic is this? I can't quite grasp your scenario right now...

September 1, 2010 at 6:56 | Registered CommenterROXORITY

Hello Support,

We use the kwizcom tagging solution which is very flexibel and efficient and we can use it in the foundation environment.
The solution separates tags with a DOTCOMMA and parent/childs with a PIPE. Again very usefull but I cannot get the tags seperated with only 1 separator.
Your solution provides actually 2 seperator replacement options. 1 fixed (ID prefixes) and 1 customizable.
Maybe you can think of a way to tweak it a little bit and make it suitable?
It would save my day (and also other filterzen/kwizcom tagging users for which I am sure they will grow fast ;-)

Kind regards,
Mario

September 1, 2010 at 15:02 | Unregistered CommenterMario

" and also other filterzen/kwizcom tagging users for which I am sure they will grow fast "
— That's quite optimistic, congratulations =)

I don't quite understand yet how this works. What is parent/childs in terms of tagging? And more importantly how would you need the List Lookup Filter to reflect this? We didn't really want to get into tree-view-like indenting just yet... :D

So how is this represented, for example the tagging column for an item contains this?
Cars | VW | Audi ; Animals | Dog | Cat
or this?
Cars ; VW ; Audi | Animals ; Dog ; Cat
— or how?

September 2, 2010 at 0:41 | Registered CommenterROXORITY

Hello Support,

It is like: Cars | VW | Audi ; Animals | Dog | Cat

Kind regards,
Mario

September 2, 2010 at 3:49 | Unregistered CommenterMario

Hello Support,

Or actually it is: It is like: Cars | VW | Passat; Animals | Dog | Fox terrier

Kind regards,
ario

September 2, 2010 at 3:51 | Unregistered CommenterMario

What happens with 2 VWs and 2 dogs?

Cars | VW | Passat; Cars | VW | Beetle; Animals | Dog | Fox terrier ; Animals | Dog | Poodle

...or:

Cars | VW | Passat , Beetle; Animals | Dog | Fox terrier , Poodle

...or?

September 3, 2010 at 1:11 | Registered CommenterROXORITY

Hello Support,

The following happens: Cars | VW | Passat; Cars | VW | Beetle; Animals | Dog | Fox terrier ; Animals | Dog | Poodle

Kind regards,
Mario

September 4, 2010 at 17:51 | Unregistered CommenterMario

Now available in release 3.8.0.12. You'd keep the ; semicolon as a web part-based delimiter and use the | pipe as the value for the new Delimiter for indenting nested pickable List Lookup filter choices configuration setting (via Site Settings / FilterZen Studio / Configuration Settings).

This should give you a hierarchically nested and indented List Lookup drop-down filter selection control as illustrated on this screenshot.

September 13, 2010 at 4:40 | Registered CommenterROXORITY

Hello Support,

Looks promising. We will check it out.

Kind regards,
Mario

September 17, 2010 at 17:45 | Unregistered CommenterMario

Hello Support,

It works good.

Thanks,
Kind regards,
Mario

September 18, 2010 at 23:07 | Unregistered CommenterMario

Hello Support,

It looks like from revision 51? it does not work anymore as intended.
It seems we can use:

OR the web part-based delimiter
OR the value for the new Delimiter for indenting nested pickable List Lookup

But not in combination

Can you fix this asap please?

Kind regards,
Mario

April 27, 2011 at 2:26 | Unregistered CommenterMario

Sample scenario from above works perfectly fine here using 3.8.0.56.

Double-check your List Lookup Filter has:

- contains operator
- ; separator for the filter
- | separator on the configuration page
- of course CAML Direct filtering mode enabled

May 2, 2011 at 19:00 | Registered CommenterROXORITY