PR-6.0-dev Pending

User tests: Successful: Unsuccessful:

avatar rdeutz
rdeutz
26 Sep 2025

Summary of Changes

The compare view of the versions shows for categories not the id, it shows the name. This is possible because we have a lookup table definition. This PR add the definition for tags so that we can show tag names instead of tag ids.

Testing Instructions

This is not easy to test fully:

  1. You have to make an Update from 5.4.x and MUST use the Custom-Update-URL.

XOR

  1. Grap the sql from that file, replace the prefix and let it run on your database (using the tool you like)

However you did it, after it you must create some versions of (articles, contact, something that has tags and versioning)

  • Go then to the compare view and check if the tags are listed as tag names or ids

Actual result BEFORE applying this Pull Request

5F4F9100-D618-4C7C-BFBA-928223AFDF7E

Expected result AFTER applying this Pull Request

D0B910E7-0FC5-464F-AA5F-B1B7DBF1544B

avatar rdeutz rdeutz - open - 26 Sep 2025
avatar rdeutz rdeutz - change - 26 Sep 2025
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 26 Sep 2025
Category SQL Administration com_admin Postgresql
avatar rdeutz rdeutz - change - 26 Sep 2025
The description was changed
avatar rdeutz rdeutz - edited - 26 Sep 2025
avatar richard67 richard67 - change - 26 Sep 2025
Title
[6.0] Add tag lookup table information to make it possble to shao the tag name instead the tag id
[6.0] Add tag lookup table information to make it possble to show the tag name instead the tag id
avatar richard67 richard67 - edited - 26 Sep 2025
avatar richard67 richard67 - change - 26 Sep 2025
Title
[6.0] Add tag lookup table information to make it possble to show the tag name instead the tag id
[6.0] Add tag lookup table information to make it possble to show the tag name instead of the tag id
avatar richard67 richard67 - edited - 26 Sep 2025
avatar richard67 richard67 - change - 26 Sep 2025
Labels Added: PR-6.0-dev
avatar laoneo
laoneo - comment - 27 Sep 2025

Does this also work for 3rd party extensions?

avatar richard67
richard67 - comment - 29 Sep 2025

It seems the information added here with an update SQL is also missing for new installations in files installation/sql/<db type>/supports.sql, or am I missing something?

Add a Comment

Login with GitHub to post a comment