Qgis Work-around geometry-loss-mix-up-of-a-spatialite-view-joining-two-tables

Hi i use SpatiaLite views in QGIS (Version 3.16) with joined layers and it works well but it has a little flaw.

It seems the same problem appears as mentioned in: Geometry loss/mix up of a spatialite view joining two tables
so when i want to jump to the chosen Object(Strg+P) it gives me an error.
(Kann Karte nicht zu gewählten Objekten bewegen: Ausdehnung konnten nicht bestimmt werden.)

On the map the Object is there and i can right click on it for using the actions etc.
Is it possible to make a work-around, like getting some point or making a centroid and moving to it in the actions?