Boy do I feel dumb, I had been working on a DB that was full text indexed, switched DB and the new one was not.

The code:

"FIELD ACCurrentApprovers CONTAINS " + session.getCommonUserName()

does not throw an error and seems to do the selection correctly except the names in ACCurrentApprovers are in the format CN=SomeName/O=SomeOrg. I substituted getUserName() and I get the error that the query is not understandable. Tried @UserName() with the same result. From the documentation that I have seen both should just return a String value in the form CN=SomeName/O=SomeOrg. Am I missing something?

I changed the code to:

var us:String = session.getUserName()
"FIELD ACCurrentApprovers CONTAINS " + session.getCommonUserName()

this does not throw an error but gives the wrong results, then I changed it to

var us:String = session.getUserName()
"FIELD ACCurrentApprovers CONTAINS " + us

 

and I get the error query is not understandable.  

I put the code session.getUserName() in a computed field in the pagerTop and it displays the full users name correctly so it does not appear to be an issue with session.getUserName in a Data View. This process is really getting "not understandable"

Thanks for the help.