Migrate fields from Elements Connect (nfeed) to Insight (Assets)

We are planning to migrate multiple (nfeed) fields to Insight.

The new field will have the same name, the object in Insight will have the same name, but the Insight id and Nfeed Id are different.

For example:

Nfeedfield1 = value(123456)

will be migrated to Insight and results in:

Insightfield1 = value(ins-001)

We have 10 fields to migrate.

One of the fields has been used in + 380 000 issues.

and in multiple filters.

Question 1: What's the best solution to update all 380 000 issues with the new value

Question 2: What's the best solution to update all filters where the 'old' field has been used

How would you approach this?

We are using an Oracle Database.

We have Scriptrunner.

Thx for your Insights ;-)

Alex

0 answers

Community moderators have prevented the ability to post new answers.

SERVER