Report doesn't filter for an 'Item link' tracker field
- Status
- Closed
- Subject
- Report doesn't filter for an 'Item link' tracker field
- Version
- 9.x
- Category
- Error
- Feature
- Report
Trackers - Resolution status
- Won't Fix
- Submitted by
- Xavier de Pedro
- Lastmod by
- Xavier de Pedro
- Rating
- Description
The Report feature doesn't seem to filter data if the filter applid refers to a "Item link" type of tracker field.
Scenario:
- Tracker 1 refers to a user tracker, and one of the fields is for province.
- Tracker 2 contains all the provicen names in a drop down field, and cities in a text field. (this is the common setup of a "dynamic items list" featur).
If you use report to list all items from tracker 1 which contain "province name" = "foo", you get nothing in the list. foo province exists in tracker 2. However, mysql table for tracker data seems to store the value for the province with a numeric id, instead of the string "foo" that the user knows. Therefore, there no way for the user to filter for that field.- Importance
- 4
- Easy to solve?
- 5
- Priority
- 20
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 4330
- Created
- Thursday 01 November, 2012 10:50:11 UTC
by Xavier de Pedro - LastModif
- Sunday 10 October, 2021 03:07:32 UTC