Help needed: The characters ( ) and [ ] don´t query from DB as text

The strangething is that the forward slashes / / work but NOT ( ) [ ] , see in the end of this thread

\\Tom

Tom,

I was able to replicate the described behavior for business property values containing bracket [] characters. I was unable to duplicate the behavior for parenthesis () issue. I discussed this issue internally and it appears a past fix to handle null values in the Property Based Expression evaluation system has contributed to the [] issue. I've filed a trouble report to have that further investigated in a future Bentley Map release.

For your immediate project needs, working with my colleague Chris Dalesandro we discussed potential workarounds. At the end of that process Chris determined that an XSLT PBA expression could be used as a workaround. An XSLT stylesheet similar to the following could be used:

I've attached a sample schema which makes use of an XSLT stylesheet as a Property Based Annotation expression type. If you require further assistance, please let me know.

Thanks Jeff and Chris but...

Is this going to be fixed to the december release...It must be fixed..I do know that workarounds work but I am so frustated to always have to have an workaround in Bentley enviroment. In this case , if set to varchar then it should come out as stored.. it doesn´t matter what type or characters it includes... when query it should be the same as in DB...

...I test your solution tomorrow so until that....

...//thanks  a million Jeff and Chris

Tom

Tom,

Unfortunately any change to support Property Based Annotation expressions for business property values with embedded [] bracket characters will not be included in the pending Bentley Map V8i (SELECTseries 3) 08.11.09 maintenance release. The suggested solution is not as much a workaround but rather the use of a different Property Based Annotation expression type. Please keep in mind that [] bracket characters are used as delimiters in the XFM expression parsing system so we cannot simply ignore them and pass them through as text.

Please contact me directly via e-mail if you would like to further discuss your short term project needs.

Hi all

Forgotten to post the solution in this thread, thank you again Jeff for all help:

The solution was very easy to solve when it came out what the issue with the brackets was, the brackets are used as scripting characters in BM therefor the quering the text with brackets from DB didn´t recognize the brackets as text. One example of a  solution to solve quering these kind of "forbidden" character problem stored in DB is shown in the image: (I use the Ascii code \091 Before the criteria [Text] for left bracket  \093 after the criteria [Text] to get the right bracket)

The criteria problems that I also had in this thread was a type error in script file, not easy to see but with help from Jeff:s professional Eyes we found them :)

Hope this is some help to some of you.

Best regards

Tom Lillhannus