Logo

    Home

    Documentation

    Use Cases

    Training

    Applications

    Release Notes

    How to view the database queries in the PASOE log files

    How to view the database queries in the PASOE log files

    icon
    This guide provides information on how to view the database queries in the PASOE log
    • 1. Summary
    • 2. Result
    • 3. Step by Step Guide
    • 3.1 Step 1
    • 3.2 Step 2
    • 3.3 Step 3

    1. Summary

    There are cases where you want to check the query that is sent to the database, from OpenEdge (ex. checking which indexes are being used)

    2. Result

    Once enabled, the PASOE log file will be populated with the following data fetch entries:

    3. Step by Step Guide

    3.1 Step 1

    Open src/backend/startup.json file (or create it, if it doesn’t exist); it should have the following content:

    3.2 Step 2

    Change the following settings inside the file:

    Inside staticProperties change the Consultingwerk.OERA.DataAccess:LogFetchDataDetails to true

    And add a new entry to customLogEntries: DataAccess

    The content of the file should now be:

    3.3 Step 3

    Trim the PASOE so that the changes are registered.

    Back to Use CasesUse Cases

    Back to Build.One Help-CenterBuild.One Help-Center Home

    Logo
    DataAccess     Client-Query: FOR EACH eSmartObjectType WHERE  BY eSmartObjectType.ObjectTypeGuid
DataAccess     Default-Query: FOR EACH SmartObjectType INDEXED-REPOSITION
DataAccess     Prepare-Query: FOR EACH SmartObjectType BY SmartObjectType.ObjectTypeGuid INDEXED-REPOSITION
DataAccess     Index Information on Buffer SmartObjectType: WHOLE-INDEX,ObjectTypeGuid
DataAccess     Restart-Rowid for Table eSmartObjectType: ?
DataAccess     Next-Rowid for Table eSmartObjectType: ?
DataAccess     Last-Batch for Table eSmartObjectType: yes
    {
  "basedOn": "Akioma/Swat/Server/startup_swat_appserver.json",
  "inheritStaticProperties": true,
  "staticProperties": {
    "Consultingwerk.OERA.DataAccess:LogFetchDataDetails": false,
    "Consultingwerk.SmartFramework.Menu.MenuBusinessEntity:CacheMenuAtStartup": false,
    "Consultingwerk.SmartFramework.System.MessageBusinessEntity:CacheMessagesAtStartup": false
  },
  "applicationSettings": ".restapplicationsettings",
  "inheritLoadServices": true,
  "loadServices": ["services.xml"],
  "inheritManagers": true,
  "managers": {},
  "inheritCustomLogEntries": false,
  "customLogEntries": [],
  "inheritAliases": true,
  "aliases": {},
  "sessionExport":  null,
  "environment": {
    "ensureAbsolutePropath": true,
    "applicationPropath": []
  }
}
    {
  "basedOn": "Akioma/Swat/Server/startup_swat_appserver.json",
  "inheritStaticProperties": true,
  "staticProperties": {
    "Consultingwerk.OERA.DataAccess:LogFetchDataDetails": true,
    "Consultingwerk.SmartFramework.Menu.MenuBusinessEntity:CacheMenuAtStartup": false,
    "Consultingwerk.SmartFramework.System.MessageBusinessEntity:CacheMessagesAtStartup": false
  },
  "applicationSettings": ".restapplicationsettings",
  "inheritLoadServices": true,
  "loadServices": ["services.xml"],
  "inheritManagers": true,
  "managers": {},
  "inheritCustomLogEntries": false,
  "customLogEntries": ["DataAccess"],
  "inheritAliases": true,
  "aliases": {},
  "sessionExport":  null,
  "environment": {
    "ensureAbsolutePropath": true,
    "applicationPropath": []
  }
}