Re: Display a tracker item inside a wiki page
Just curious as to if anyone had a point in the right direction for this.
I'm on the verge of attempting a Trackerbox plugin for this that would:
1)Get the trackerId and itemId that has a Page Selector as the main field:
Copy to clipboard
SELECT tiki_tracker_fields.trackerId, tiki_tracker_item_fields.itemId FROM tiki_tracker_fields INNER JOIN tiki_tracker_item_fields ON tiki_tracker_fields.fieldId = tiki_tracker_item_fields.fieldId WHERE tiki_tracker_item_fields.value=".$page.'" AND tiki_tracker_fields.type='k' AND tiki_tracker_fields.isMain=True
2) Retrieve the fields for that trackerId and itemId that are Public:
Copy to clipboard
SELECT tiki_tracker_fields.name, tiki_tracker_item_fields.value FROM tiki_tracker_fields INNER JOIN tiki_tracker_item_fields ON tiki_tracker_fields.fieldId = tiki_tracker_item_fields.fieldId WHERE tiki_tracker_fields.trackerId='.$trackId.' AND tiki_tracker_item_fields.itemId='.$itemId.' AND tiki_tracker_fields.isPublic=True
3) Build atable (or "trackerbox") to display it on the page
However, everytime I do some more researchI get the impression this is already being done with the Page Selector and tracker plugins.
Does this in fact exist? Is there a specific page I should be looking at for how to do this?