topic Add a variable to ended process instance ? in Alfresco Archive

Add a variable to ended process instance ?

christophe_carv — Wed, 10 Sep 2014 09:18:28 GMT

Hi,Is there a way of adding a variable to an ended process instance ? Our database is growing and we want to filter all historic process instance with more values using HistoryService…I tried with a sql query but i can't find the value for the primary key.Best regards.

Re: Add a variable to ended process instance ?

trademak — Wed, 10 Sep 2014 14:04:42 GMT

It's not supported via the Activiti API. But you can add new entries to the historic variable table for example. You can query for historic process instances to retrieve the database id (primary key).

Best regards,

Re: Add a variable to ended process instance ?

christophe_carv — Wed, 10 Sep 2014 16:24:07 GMT

Thanks.

But my query would be like this : "INSERT INTO ACT_HI_VARINST VALUES (?, ?, ?…" and the primary key seems to be calculated with a specific algorithm (IdGenerator)…

How can i find the next id to insert ?

Regards.

Re: Add a variable to ended process instance ?

martin_grofcik — Thu, 11 Sep 2014 05:26:31 GMT

Hi,

call
org.activiti.engine.impl.cfg.IdGenerator#getNextId

You obtain free id, you can use it for your HI row.

Regards
Martin

Re: Add a variable to ended process instance ?

christophe_carv — Thu, 11 Sep 2014 08:15:54 GMT

Hi,

Thanks for you support.

Just one last question : the getNextId() method of the IdGenerator class uses a property "idBlockSize", how can i find its default value ?

Best regards.

Re: Add a variable to ended process instance ?

martin_grofcik — Fri, 12 Sep 2014 04:51:07 GMT

Hi Christophe,


  public IdBlock execute(CommandContext commandContext) {
    PropertyEntity property = (PropertyEntity) commandContext
      .getPropertyEntityManager()
      .findPropertyById("next.dbid");
    long oldValue = Long.parseLong(property.getValue());
    long newValue = oldValue+idBlockSize;
    property.setValue(Long.toString(newValue));
    return new IdBlock(oldValue, newValue-1);
  }

Regards
Martin