Forum

Jennifer Häfner
      Has successfully completed the online course Intermediate (200)
      Has successfully completed the online course Advanced (300)
      Has successfully completed the online course Basics (100)
      Has successfully completed the online course Advanced (310)
      Has successfully completed the online course Advanced (320)
      Has successfully completed the Intermediate Certification
      Has successfully completed the Advanced Certification
    3 years ago #27304
    Up
    1
    Down
    ::

    I know that this is an old post, but since Simplifier version 6.0.138-LTS.141, SQL statements with a dynamic WHERE clause are possible.
    The WHERE clause needs to be added as a parameter in the Connector call. Inside the WHERE clause, statements like ‘id IN (1,2,3)’ or ‘name LIKE “John”‘ can be specified.
    Connector calls with a dynamic WHERE clause can only be executed inside a Server Side Business Object for security reasons. Also, words like ALTER, CREATE, DELETE, DROP, EXEC(UTE), INSERT (INTO), MERGE, SELECT, UPDATE, UNION (ALL) are not allowed inside a dynamic WHERE clause.

    Attachments:
    You must be logged in to view attached files.