[Klaus79]

4 years, 11 months ago #23280

Hello,

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

 

 

Best regards

Klaus

[Christian Kleinschroth]

4 years, 11 months ago #23283

Up

0

Down

::

Hello Klaus,

 

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

[Klaus79]

4 years, 11 months ago #23284

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

[Christian Kleinschroth]

4 years, 11 months ago #23294

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.

[Klaus79]

4 years, 11 months ago #23296

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