Redmine

Hello.

My aims are:

1). To make some field on issue creating page to be dependent on some other field in real time. More specific - I need "due date" to be modified automatically when "priority" changes. Of course, I can write my own plugin or just to modify the code in a barbaric way, but I'm looking for the most simple and generic solution.

2). To filter my issues in more flexible way. Specifically, I need to make a query like "WHERE due_date < closed_date".

I tried to search for plugins or another solution on the forum, but didn't find nothing. It also don't seem to be any simple and generic way to do such things in Redmine admin panel. At least, I spent quite a lot hours trying to find something there.

Any suggestions?