[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