#100 Handling of IN during Select operation

3.1.0
closed-wont-fix
Jakub Vrána
Common (150)
5
2010-11-24
2010-11-23
Anonymous
No

When trying to use the IN operator to select items with the Select: workflow The arguments that I enter in the text box are not what are used or displayed in the query below.

In the attached screenshot I show how when I used an IN of "PK3991","PK3992" it translated this to just 3991,3992 Chopping off parts of in this case an item number, thus changing the query to something that will return an empty set in my data.

Discussion


  • Anonymous
    2010-11-23

    screenshot showing how the entered data is not used in the query

     
    Attachments
  • Jakub Vrána
    Jakub Vrána
    2010-11-24

    Use apostrophes because quotes can be configured as identifier delimiter. 'PK3991','PK3992' should work.

     
  • Jakub Vrána
    Jakub Vrána
    2010-11-24

    • status: open --> closed-wont-fix