Simplifier Developer Home Forums Simplifier Forum sql statements in sql connectors

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #23280
    AvatarKlaus79
    Participant
    • Topics: 30
    • Replies: 35
    • Jedi Master

    Hello,

    does anybody know if it is possible to get an overview/list of sql statements used in sql connector calls.

     

     

    Best regards

    Klaus

    #23283
    ChristianChristian
    Keymaster
      Has successfully completed the online course No-Code.
      Has successfully completed the online course Low-Code.
      Has successfully completed the online course Pro-Code.
    • Topics: 1
    • Replies: 31
    • Jedi Knight
    Up
    0
    Down

    Hello Klaus,

     

    the SQL Statement is visible in the Logs & Monitoring Component see screenhot attachted.

    SQL Log

    #23284
    AvatarKlaus79
    Participant
    • Topics: 30
    • Replies: 35
    • Jedi Master
    Up
    0
    Down

    Hello Christian,

    yeah, that’s true but I do not mean that.

    I’ve about 15 sql connectors and maybe more than 100 connector calls.

    I need an overview which attributes are used in a result or in where-clause in which connector call in which connector because unfortunately I’ve to split connectors for secure reasons (e.g. for attribute encryption).

    Therefore I’ve to analyze all connector calls…

     

    Best regards

    Klaus

    #23294
    ChristianChristian
    Keymaster
      Has successfully completed the online course No-Code.
      Has successfully completed the online course Low-Code.
      Has successfully completed the online course Pro-Code.
    • Topics: 1
    • Replies: 31
    • Jedi Knight
    Up
    0
    Down

    Hello Claus,

    in this case it is a lot easier to monitor all incoming sql queries directly in the database (for e.g. via mysql query log etc) instead within simplifier.

    #23296
    AvatarKlaus79
    Participant
    • Topics: 30
    • Replies: 35
    • Jedi Master
    Up
    0
    Down

    Hello Chris,

    but that means I’ve to execute all scenarios which costs a lot of time.

    Is there no option within Simmplifier to get that overview?

    Maybe Simplifier staff could do it once a time directly at database level?

     

    Best regards

    Klaus

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.