Work Management Project List sorting and grouping function

[sheradyn.ford]

Hi All,

I have a work management project and I have the issues grouped by category. I'm trying to sort the view, but the child records to epics aren't appearing beneath them.

Subtasks are appearing beneath standard tasks, but childs to epics aren't. When I try to manually move records (after turning off the auto sort), it lets me grab the issue row, it appears as though it's going to move, and then nothing. When I try to grab the same (or another issue) to manually move, it highlights text on the screen like you're going to copy the text. I have to then refresh the web browser before it will let me attempt to grab an issue again.

My question is - has anyone else come across this, or am I doing something wrong? I know that epics MAY not work the same in a work management project, but the manual sort thing has me really baffled.

[Daniel Yelamos [Adaptavist] · Accepted solution]

Hi Monika.

Without seeing your code, there isn't much that I can tell you. As far as I know, so long as you close the DB connections that you open, and so long as you only fetch and not write, you should be in the clear. 

Do you have a test instance that you can stress test it for?

Cheers!

Dyelamos

[Monika Danielsson]

Hi,

Thanks for the reply! Yes, I'm only reading from the external database, and I close the connections , so then it sounds reasonably safe. 

Main parts of code: 

static String getSomething(Properties props, Driver driver) {
  Connection conn = driver.connect(<db>, props)
  Sql sql = new Sql(conn)
  try {
    def <result> = sql.firstRow("SELECT ... ");
    <do something w result>
  }
  finally {
    sql.close();
    conn.close();
  }
  return <something>;
}

..and thanks to this, I got around to set up a test case which runs a bunch of parallel threads, just to check if something seems to get out of hand, which it doesn't. 

Thanks!