Issue TrackerIssue Tracker is a Joomla 2.5 component for 'tracking' raised issues or concerns either internally to the company or externally by users.
|Public write access is disabled. Please login or register|
Error while trying to create a Single Issue menu item.
1) I've got an error "Unknown column 'published' in 'where clause' SQL=SELECT id AS id, issue_summary AS title FROM tdw3i_it_issues WHERE published=1" when I tried to create a Single Issue menu item.
I've modified default.xml file in my \components\com_issuetracker\views\itissues\tmpl directory, line 15 query="SELECT id AS id, issue_summary AS title FROM #__it_issues WHERE published=1" to query="SELECT id AS id, issue_summary AS title FROM #__it_issues" and now it's seems to work ok.
2) You said the function 'Modify the issue on the front-end' was added, but I still can't find this functionality. So, can you explain how to use it?
P.S. sorry for my English
1) You are correct it should read state=1 in the xml file. [Unless you want any issue to be seen. It is intended so that only 'published' issues are visible in the front end.]
Re: Error while trying to create a Single Issue menu item.
2) The documentation describes how to change the settings to enable registered (and issue administrators) to edit their issues, and there is also something in the FAQ.
If you haven't found the documentation try this link. It might also assist in understanding some of the following.
However to summarise you need to do the following:
a) Ensure that the ACL settings for registered users is set to 'Edit Own'.
b) If the issues are 'old' (pre release 1.2) issues then you need to edit then in the back end and save them (no need to actually make a change) so that a Joomla 'asset' record is created. All new issues are automaticaly created with the appropriate asset record.
c) To enable users to see their issues, create a 'list issues' menu link and in the menu parameters choose the option 'Show Own Issues', and you probably want to enable 'Child Links' as well. Also ensure that the 'show icons' is set, for the child links.
Now when a user logs in they will see your list issues menu item. If they click on the menu they should a list of all of their raised issues. [Note that the issue must have the user as the person who 'identifed' the issue.] Clicking on the child link (to the issue itself) they will be presented with a view of the issue details. In the top right hand corner of the issue there will be some icons. These will be (depending upon menu options chosen), a print icon, an email icon AND if the user is set up correctly an 'edit' icon. [This is the same icon as shown when you edit an article.] If they click on the edit icon they are presented with an edit screen.
Note: Registered users can 'add additional details' and change only a small set of the issue settings. [There are some component parameters to enable the provision of a full editor, otherwise it will be a simple textarea for data entry.]
If the person is an 'issue administrator' they have the ability to edit any issue. They also have a different screen display for editing with the ability to change virtually everything about the issue.
If you use and find our Joomla extensions useful please consider supporting their further development.
Most Recent Forum entries
Issue Tracker - Recently Closed Issues
AN4IGZU1PQ - Change redirection after issue crea>Project Name: Issue Tracker - Rel 1.3.1
Close date: 2013-05-21 16:21:20
A5LSHJOSS9 - Add button to issue list to 'view' >Project Name: Issue Tracker - Rel 1.3.1
Close date: 2013-05-21 14:58:14
AXSLWZW64W - Add a create button to the issue li>Project Name: Issue Tracker - Rel 1.3.1
Close date: 2013-05-20 16:56:53
A39R3RDOT5 - Correct identified by in back end o>Project Name: Issue Tracker - Rel 1.3.1
Close date: 2013-05-20 14:07:36
ARLD9BAPZ7 - Add new project filter to front end>Project Name: Issue Tracker - Rel 1.3.1
Close date: 2013-04-29 17:19:00
Quote(s) of the Day
If you love life, don't waste time, because time is what life is made of
The difference between a democracy and a dictatorship is that in a democracy you vote first and take orders later; in a dictatorship you don't have to waste your time voting.