[horde] Whups overdue tickets
Jan Schneider
jan at horde.org
Thu Jan 11 17:18:16 UTC 2018
Unfortunately not. There is a simple sql tool in the admin section
though that renders results in a table. You could steal some code from
there and build a portal widget from it.
Zitat von Jamie Allen <jamie at jsdckr.nz>:
> Kia ora Jan
>
> Thanks so much for your response - very much appreciated.
>
> It would be simple enough to knock up a mysql query directly to pick
> out those tickets. Question : Is there any way to show the results
> of your own mysql query in the Portal screen (I guess I could use
> 'view an external webpage' and construct something, but that seems a
> little like overkill, if there's a neater way of doing it....)
>
> Yours very gratefully
>
> Jamie
>
> Quoting Jan Schneider <jan at horde.org>:
>
>> Zitat von Jamie Allen <jamie at jsdckr.nz>:
>>
>>> Kia ora
>>>
>>> Thank you to the creators of Whups. It is an incredible resource
>>> and is making our work so, so much easier since we discovered it.
>>> I have read the documentation, for Horde 5.2.22 but have not been
>>> able to find a way of alerting the user responsible when a ticket
>>> has passed its due date. I was wondering if this might
>>> automatically be picked up by Horde Alarms - but if so, I have
>>> missed something - for which I apologise.
>>
>> No, this hasnt been implemented with HordeAlarm yet, though its
>> definitely a good idea.
>>
>> There is whups-reminder though, which can be used in a cron job for
>> regular reminders.
>>
>>> Also, can anyone please advise if there's a way to build a query
>>> to show only overdue tickets (in all queues)?
>>
>> That would require the query builder to allow relative dates. There
>> is a enhancement request for it IIRC, but this hasnt been
>> implemented yet.
>>
>> --
>> Jan Schneider
>> The Horde Project
>> https://www.horde.org/
>>
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/To unsubscribe,
>> mail: horde-unsubscribe at lists.horde.org
--
Jan Schneider
The Horde Project
https://www.horde.org/
More information about the horde
mailing list