This guide provides information on how to view the database queries in the PASOE log
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:
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: yes3. 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:
{
"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": []
}
}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:
{
"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": []
}
}3.3 Step 3
Trim the PASOE so that the changes are registered.
Back to 
Use Cases
Back to 