Search

Site Menu

Newletters

Subscribe to our newletters

Login Form

Macrotone Forums
History:
4h
8h
12h
24h

Issue Tracker

Issue 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
Last post
Ilhom

Ilhom
1 post
---
Location:
n.a.
20.09.2012 19:03

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



 
geoffc

geoffc
238 posts
---
Location:
United Kingdom
21.09.2012 10:15

Re: Error while trying to create a Single Issue menu item.

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.]

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.

Regards
Geoff
www.macrotoneconsulting.co.uk

 

Additional information

The Macrotone Consulting Web site would like to use cookies to store information on your computer, to improve our website. Cookies used for the essential operation of the site have already been set. To find out more about the cookies we use and how to delete them, see our privacy policy.

I accept cookies from this site.