Easy way of updating Filter Columns?

[Eric Blair]

I have about 20 Filters and they each should have the same columns showing. Currently, because of how they were created they have different column configs. As it stands now I will have to go into each filter and manually edit the column configuration. This is a very slow process. IS there some tool or perhaps some API that will allow me to perform this quicker?

Perhaps what I really mena is what are the JIRA SOAP API's for:

Issue Navigator Columns

Add New Column:

Move Column

Delete Column

Thanks!

[justindowning]

I'm not sure if it's possible via the API, but you can do it via SQL.

select * from columnlayoutitem
where columnlayout = (select id from columnlayout searchrequest = '<insert_filter_id>');

  id   | columnlayout |  fieldidentifier  | horizontalposition 
-------+--------------+-------------------+--------------------
 14884 |        10142 | customfield_10104 |                  0
 14885 |        10142 | issuekey          |                  1
 14886 |        10142 | summary           |                  2
 14887 |        10142 | assignee          |                  3
 14888 |        10142 | status            |                  4
 14889 |        10142 | created           |                  5
 14890 |        10142 | customfield_10354 |                  6
 14891 |        10142 | customfield_10353 |                  7
 14892 |        10142 | customfield_10355 |                  8
 14893 |        10142 | updated           |                  9

From there you can update/add fields (fieldidentifier) and the order (horizontalpostiion). This example would move the Summary to the first position in the filter. You would want to update another field to take it's position after running this.

update columnlayoutitem set horizontalposition = '0' where columnlayout = '10142' and fieldidentifier = 'summary';