nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Add a variable to ended process instance ?

christophe_carv

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.

Find more posts tagged with

Comments

trademak

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,

christophe_carv

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.

martin_grofcik

Hi,

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

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

Regards
Martin

christophe_carv

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.

martin_grofcik

Hi Christophe,

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

Regards
Martin