try to display the change of only one feature using the "Feature ID" text field on the plugin UI
expected: the changes are shown
actual: nothing is shown. and on the database log I can see the plugin tries to filter with id. Ex query:
2021-08-27 15:49:44.558 CEST [811474] postgres@cadastre LOG: statement: SELECT event_id, action_tstamp_clk, schema_name || '.' || table_name, action, application_name, session_user_name, row_data, changed_fields FROM audit.logged_actions l WHERE schema_name = 'public' AND table_name = 'batiments3' AND row_data->'id'='28104' AND action IN ('I','U','D') ORDER BY action_tstamp_clk DESC
(the pk is called ogc_fid in my case)
Proposed solutions
The audit table keeps track of the pk name, let's use it to filter, instead of id.
Steps
id
expected: the changes are shown
actual: nothing is shown. and on the database log I can see the plugin tries to filter with
id
. Ex query:(the pk is called
ogc_fid
in my case)Proposed solutions
The audit table keeps track of the pk name, let's use it to filter, instead of id.