Active Query Builder support area

NewExpression IN condition and escaping outer quotes

Avatar
Andrew Kennard
  • updated
  • Completed

No rush for this, just logging

When setting NewExpression I can't successfully set an In array that INCLUDES START and END single quotes

Yes I appreciate 34 High Street should be enclosed in single quotes after the comma but i'm just using it to emphasize the 'Rose Cottage' part

ie If I set NewExpression to

In (Rose Cottage,34 High Street)

I get

In ('Rose Cottage','34 High Street') Correct


In ('Rose Cottage',34 High Street)

I get

In ('Rose Cottage','34 High Street') Not Correct


In (''Rose Cottage'',34 High Street)

I get

In ('''''Rose Cottage''''','34 High Street') Correct but not what I want


I want to give it this (or what should I give it)

In ('Rose Cottage',34 High Street)

and get this

In ('''Rose Cottage''',34 High Street)


Replies 13
Avatar
0
Andrew Kennard

Thinking about it, in the future were the developer to offer a free type textbox in their custom criteria dialog a method to check the expression the user types in is valid would be useful

I guess the same would apply to the Expression column too

Avatar
0
Andrey Zavyalov, PM

Hello,

We are moving to this, but not very fast. We have already made calculation of SOME types of expressions for Oracle, but still there are a lot of cases that cannot be calculated for this server. Doing reliable type calculation for each database server will take plenty of time.

Avatar
0
Andrew Kennard

No problem. It sounded like you were offering to expose something that already existed. If it were me I probably wouldn't invest too much time in second guessing what someone means. After all aqb is a technical tool and some level of technical ability is needed to use it so it's up to the user to enter valid expressions if they are given the opportunity. As I say I think the developer will need a flag they can set to say something is a 'custom expression' so when they get it back in their own dialog they simply load it into a text box and not try and process it in to combo froms and check boxes etc etc