If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

contains() not working

Started by bucky, 07 Oct 2009 05:36:24 PM

Previous topic - Next topic

bucky

I have a filter expression that looks like this:

[Report Path] contains ('/content/folder[@name=''Sales Reports'']/')

It's returning 0 rows, even though I know those rows exist. I think the square bracket may be a special character or somehow messing it up, because when I do this, I get rows returned:

[Report Path] contains ('@name=''Sales Reports''')


bucky

I'm positive it's the left bracket, because when I remove the left bracket, it works:

replace([Report Path], '[', '') contains ('/content/folder@name=''Sales Reports'']/')