0

Where can I find the query text information in the Pyramid repository database?

I'm building a transaction logs dashboard and can get most details from the transactionView table, but I can't find the query text information.

Is the query text stored in the Pyramid repository database tables?

2 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 7 days ago
    • Reported - view

    Archiving as no response.

    • Lead Consultant Advanced Analytics
    • Michael_Daun
    • 5 days ago
    • Reported - view

    I do not know if this post is still open for answers...

    ...but: In the repository table SERVER_LOG_TRANSACTION_TEXTS you find in the column QOM a JSON string which may contain the SQL you are lookig for. I wrote "may contain" because the SQL is not in every data row - cf. your screenshot which has for several rows the "No Query" information.

    And, as the information comes from a LOG table it is only as long persistent as the log messages are stored accoring to your log settings.

Login to reply

Content aside

  • Status Answered
  • 5 days agoLast active
  • 2Replies
  • 27Views
  • 3 Following