...
This tool is useful if you're not getting the results you were expecting from a search, report, etc. Use it to run the SQL command that is being sent to Weave (and has been constructed from the content of your XML files) and check the results. To get the exact SQL that is being sent to Weave, open your Weave log file (e.g. C:\weave\logs\weave.log), search for "NativeSQL" in the file and copy the SQL command that follows this search term (remember to search from the bottom of the log file and search for the "previous" occurrence if you're looking for the last instance of the term "NativeSQL". And enter the values for parameters if they do not appear in the log file.
E.g. From weave.log:
| Code Block |
|---|
16:18:54,397 DEBUG [qtp228750133-114] com.cohga.server.search.database.internal.attribute.AttributeSearchProvider "NativeSQL: SELECT DISTINCT mann.zones.ogc_fid FROM mann.zones WHERE (mann.zones.zone_code = ?)" |
...
16:18:54,402 DEBUG [qtp228750133-114] com.cohga.server.search.database.internal.attribute.BaseSearchProvider "Result=[263, 134, 119, 247, 112, 264, 282, 118]" |