Best way to run Macro on LibreOffice or OpenOffice SubForm "Fill parameters" Event

Question

I try for more than a week to fill out a SQL query parameter by running a macro on the "Fill Parameters" event in the subform by searching for a method to fill the parameter under the Parameters object with MRI without success.

Searches for guides and code samples on Google and the relevant forums also found nothing.

Have I missed something or am I looking in the wrong place? Thanks in advance!

Sql query:

SELECT * FROM "Table1" WHERE "Record-Id" = :Record-Id

Macro code to display an event object in Python:

def main (oEvent):
   ctx = XSCRIPTONTONT.getComponentContext ();
   mri (ctx, oEvent);