Links from reports do not support dynamic variables

[mpotter@…]

Using the following SQL report, the links generated are not correct. I realize that this specific report may serve no purpose once I upgrade to 0.12; it is given as a simple example to demonstrate the issue.

SELECT DISTINCT
    value AS customer,
    '15?CUSTOMER=' || value AS report,
    'report' AS _realm,
    '15?CUSTOMER=' || value AS id
FROM ticket_custom
WHERE
    name = 'customer'
ORDER BY
    customer

This report tries to use both the 'report' as a column name (a feature that does not appear to be documented) and the 'report' realm feature of the SQL report system. Both give the same results.

Example: If the resulting report link was for {15?CUSTOMER=Acme} the resulting link points to http://trac-host-base/report/15%3FCUSTOMER%3DAcme instead of http://trac-host-base/report/15?CUSTOMER=Acme

[mpotter@…]

Another report example, one that is usable without the 'customer' custom field:

SELECT DISTINCT
  owner,
  '7?USER=' || owner AS report,
  'report' AS _realm,
  '7?USER=' || owner AS id
FROM ticket
ORDER BY
  owner

[mpotter@…]

0.11.7 was not available with filed.

[Christian Boos]

Sounds more like a hack not fully working than an actual defect. You should come up with a patch if you expect this to get fixed one day.

[anonymous]

Similarly for the wiki realm:

-- Wiki pages modified by the current user.  
-- Version is the highest version that the user modified.
SELECT 
   "wiki" AS _realm, 
   name || "?version=" || max(version) AS id, 
   max(version) AS Version,
   time AS date, time, 
   comment
FROM wiki
WHERE author='$USER'
GROUP BY name