#100 Handling of IN during Select operation

Common (150)

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.


  • Comment has been marked as spam. 

    You can see all pending comments posted by this user  here

    Anonymous - 2010-11-23

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

  • 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

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks