Permanent URI for this community on Dspace 7.6

[adrianoca...@gmail.com]

Hello, can anyone tell me how to change the url of a community after migration?
For example:
http://my.dspace.ui:4000/handle/123456789/XXX
to
https://my.dspace.ui/handle/123456789/XXX

we were able to update the items via the database with the commands in this discussion:
https://groups.google.com/g/dspace-tech/c/o_sTXCJon24/m/1Dr4_gCUAQAJ
But in communities and subcommunities it didn't work, we also couldn't change it via the graphical interface.
TKS

[adrianoca...@gmail.com]

UPDATE metadatavalue
SET text_value = regexp_replace(text_value, 'http://my.dspace.ui:4000', 'https://my.dspace.ui', 'g')
WHERE metadata_field_id IN (
    SELECT metadata_field_id
    FROM metadatafieldregistry
    WHERE element = 'identifier'
    AND qualifier = 'uri'
)
AND text_value LIKE '%http://my.dspace.ui:4000 %';