SimpleDesk

SimpleDesk! => SimpleDesk Support => Topic started by: Anzor on August 28, 2015, 06:16:31 AM

Title: Report of specific field
Post by: Anzor on August 28, 2015, 06:16:31 AM
Good day !
I installed the forum mod SimpleDesk.
Please tell me, is it possible to create reports for a specific field?
People from different organizations leave me tickets. I created an additional field "Organization" for leaving the application so people can fill them in.
Can I generate a report at the request of specific organization?
Thank you for your help!
Title: Re: Report of specific field
Post by: Flavio93Zena on August 29, 2015, 03:26:27 AM
...reports?
Title: Re: Report of specific field
Post by: Anzor on August 31, 2015, 09:10:49 AM
Quote from: Flavio93Zena on August 29, 2015, 03:26:27 AM
...reports?

Thank you for reply!
Yes, reports.
For example:
(https://pp.vk.me/c623820/v623820324/4178c/b0Cx3s_0vk0.jpg)

This is a standard list of user activity. (I'm sorry, just my SimpleDesk translated into Russian).
We can add here another column?
Title: Re: Report of specific field
Post by: Flavio93Zena on August 31, 2015, 02:23:34 PM
Pretty sure it's possible, even if the layout can be broken easily. What do you want to add?
Title: Re: Report of specific field
Post by: Anzor on September 02, 2015, 03:56:37 AM
Quote from: Flavio93Zena on August 31, 2015, 02:23:34 PM
Pretty sure it's possible, even if the layout can be broken easily. What do you want to add?

I added an additional field (text) "Organization" and "Phone number" (sorry for screenshots in russian language)
(https://pp.vk.me/c623820/v623820324/41f13/eWaPVwwHWoA.jpg)

Users fill it when creating a new ticket.
(https://pp.vk.me/c623820/v623820324/41f1c/_YE_88b_w8Q.jpg)


Help please add it to the list of user activity
Title: Re: Report of specific field
Post by: Flavio93Zena on September 02, 2015, 08:16:26 AM
I see, the relevant table is this smf_helpdesk_custom_fields_values, then you will need to edit function shd_main_helpdesk() in SimpleDesk.php and finally the template to show it up. arantor would easily be able to do it, but he mostly disappeared from the net :/ My php knowledge may not be enough to figure out how to do what you ask, I'm just replying to tell you, because I am about to go to lunch so I can't really take a closer look at it and eventually try to code it at the moment.
Maybe enabling the email notifications is a good idea.
Title: Re: Report of specific field
Post by: tfs on September 19, 2015, 03:52:13 PM
I wrote a SQL query a few years ago and documented it here:

https://www.simpledesk.net/community/index.php?topic=1234.0

That may get you started.