likehopper / redmine_sla

Manage SLAs in Redmine!
GNU General Public License v2.0
7 stars 2 forks source link

missing column SLA_RESPECT_1 #6

Closed trogloraspa closed 1 year ago

trogloraspa commented 1 year ago

Hi, I get this error:

ERROR -- : Query::StatementInvalid: PG::UndefinedColumn: ERROR: column issues.sla_respect_1 does no LINE 1: ... FROM issue_statuses WHERE is_closed=FALSE)) AND (issues.sla...

any clue?

thanks

likehopper commented 1 year ago

When do you get this error ?

trogloraspa commented 1 year ago

when I try to apply a filter for the issues that have a sla.

likehopper commented 1 year ago

I didn't specify it in the documentation, but for now, after defining "sla_type", you have to "restart" Redmine to create the necessary virtual functions. Maybe it comes from that. Can you restart Redmine?

trogloraspa commented 1 year ago

After a restart I dont see the error anymore. but I dont see any sla behave too. I think u should provide a pre-set for the sla setting just to better understand how should this plugin is meant to work.

likehopper commented 1 year ago

On a test environment, it's possible to use fixture datas : "https://github.com/likehopper/redmine_sla/blob/main/doc/TESTING.md". But, I will indeed provide a pre-set and improve the documentation on SLAs' definition.

likehopper commented 1 year ago

I just added two first simple examples:

Thanks for your feedback!

likehopper commented 1 year ago

I completed it with a third, more complex example. I developed a bash' script to generate each example. Don't hesitate to open an issue if there are any problem.