[DBCleaner] Incorrect SQL on eSpace Version List screen

Forge Component
(44)
Published on 2018-11-23 by Johan den Ouden
44 votes
Published on 2018-11-23 by Johan den Ouden

Hi all,


i think the advanced SQL on the eSpace Version List is not correct:

I see this statement:

SyntaxEditor Code Snippet

left join {APP_VERSION_MODULE_VERSION} on ({Espace_Version}.Id = {APP_VERSION_MODULE_VERSION}.ESPACE_VERSION_ID and {APP_VERSION_MODULE_VERSION}.EXTENSION_VERSION_ID is null)

The "APP_VERSION_MODULE_VERSION.EXTENSION_VERSION_ID = NULL" is not correct (or maybe not complete) because it is possible that the APP_VERSION_MODULE_VERSION.ESPACE_VERSION_ID and APP_VERSION_MODULE_VERSION.EXTENSION_VERSION_ID both are filled.
In that case the current eSpace in the list has no current Application mentioned, but the delete action will crash because of the protected field in APP_VERSION_MODULE_VERSION.


Best Regards,

Jeroen Vormer

Hi Jeroen,

Thanks for your feedback. I have looked at it and found out there are more problems with this screen.
I will investigate it further more and bring a new version alive.
For now I have built a new version which tells what goes wrong when you want to delete a version.

Regards,

Johan