How to remove JIRA tags.

[Aamir Farooqui]

We are storing JIRA data into SQL and when data is coming it is having JIRA tags like Panel, Color etc.

So when i am using this in my report it is giving me the same thing which we have got after migration.

i want to remove these tags so that my text is readable to end user properly.

Any help will be appreciated. TIA.

[Nic Brough -Adaptavist-]

What do you mean by "when data is coming"?  How are you getting the data and what are you getting?

[Aamir Farooqui]

We are connecting JIRA db via Business Object reports and then transferring the data which we get from BO to SQL DB.

[Nic Brough -Adaptavist-]

Ah, I thought so.  You're reading raw Jira data directly from the database, and run into one of the hundreds of reasons that this is the worst thing you can do.

Your choices are

• Write a translator for Business Objects so that it can read the raw data via SQL and understand it properly
• Move to using a proper sane way to access Jira data - do the reports in the UI or use the REST interface for example