Loading...
 
Skip to main content

Add SQL/DB Link Tracker field type

  • Tracker item actions
Trackers
Items
Status
Open
Subject
Add SQL/DB Link Tracker field type
Version
12.x
Category
  • Feature request
Feature
Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc)
Database MySQL (MyISAM)
Interaction (with the outside World)
Trackers
Resolution status
New
Submitted by
Dimitrios Tanis
Lastmod by
Xavier de Pedro
Rating
(2)
Description

I think it would be very useful to add an SQL tracker field type so as to be able to "link" tracker items to external database data much like item link does for inter-tracker items aka foreign keys.

Why? Because it would massively improve interaction with external data. We could have a DB field in a tracker that pulls data from an external ERP/CRM/MRP/you-name-it database and links it to data in the tracker. eg add a tracker that users rate products, taking the product records from a live ERP database.

Currently the DBReport and SQL plugins cater for that need in wiki pages but nothing can be used in trackers.

How? In order to make it best usable and comparable to item link, it would look exactly the same as the item link with:

  • an added option for DSN selection
  • replacing tracker ID with SQL statement
  • replacing field ID with Column Number
  • removing Status Filter



Workaround

No workaround exists.

Added as a potential workaround to explore: {}
What about using PluginSQL or PluginDB in:

  1. a "Static Text Tracker Field"?
  2. a Pretty Tracker scenario, where you can define your own tpl in a file on disk or even better, in a wiki page with the appropriate permission on that page, and through PluginTrackerList with the param tplwiki=yourwikipagetemplate ?

Importance
9
Easy to solve?
7
Priority
63
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
5118
Created
Thursday 30 January, 2014 01:56:04 UTC
by Dimitrios Tanis
LastModif
Thursday 30 January, 2014 08:19:59 UTC


Show PHP error messages