Page Comparison

Most of the scripts make irreversible changes that can impact the proper functioning of the application. They should be used with caution.

Please contact our support team before using them.

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.ao.v2.projectvalue.ProjectValueMgr
 
 
def VALUES_IDS = [x,x]
def projectValueMgr = ComponentAccessor.getOSGiComponentInstanceOfType(ProjectValueMgr.class)
def value = null
def println = ""
 
VALUES_IDS.each {
     
    println += "*** *** *** <br/>"
    println += "Value ID: " + it + "<br/>"
     
    value = projectValueMgr.get(it)
     
    if(value != null){
        projectValueMgr.delete(value)
        println += "Deleted!! <br/>"
    }
    else{
        println += "Can not found this Value <br/>"
    }
     
    println += "<br/><br/>"
}
 
 
return println

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.ao.v2.projectvalue.ProjectValueMgr
 
 
def PROJECTS_IDS = [x, x]
def projectValueMgr = ComponentAccessor.getOSGiComponentInstanceOfType(ProjectValueMgr.class)
def value = null
def println = ""
 
PROJECTS_IDS.each {
 
    println += "*** *** *** <br/>"
    println += "Project Value for Project: " + it + "<br/>"
 
    value = projectValueMgr.getByProject((Long) it)
 
    if(value != null){
        projectValueMgr.delete(value)
        println += "Deleted!! <br/>"
    }
    else{
        println += "Can not found this Value <br/>"
    }
 
    println += "<br/><br/>"
}
 
 
return println

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.ao.v2.projectvalue.AOProjectValue
import com.deiser.jira.profields.ao.v2.projectvalue.ProjectValueMgr
import com.deiser.jira.profields.api.configuration.ConfigurationService
import com.deiser.jira.profields.api.field.FieldService
import com.deiser.jira.profields.api.field.FieldType
import groovy.transform.Field
import org.apache.commons.collections.CollectionUtils
 
@Field ProjectValueMgr projectValueMgr = ComponentAccessor.getOSGiComponentInstanceOfType(ProjectValueMgr.class)
 
/* ***** execution ***** */
@Field HashMap<String, List<AOProjectValue>> allValuesByHash = new HashMap<>()
@Field List println = ["<b>*** REMOVED ***</b> <br/>"]
removeAllDuplicatedValues()
return println
 
/* ***** FUNCTIONS ***** */
def removeAllDuplicatedValues(){
    projectValueMgr.get().each{addInMap(it)}
    getAllDuplicatedValues().each {list -> removeDuplicated(list)}
}
 
def getAllDuplicatedValues(){
    return allValuesByHash.entrySet().stream()
        .filter{it -> it.value.size() > 1}
        .map{it -> it.value}
        .collect()
}
 
def addInMap(AOProjectValue value){
    String hash = getHash(value)
    List currentValues = allValuesByHash.remove(hash)
    currentValues = currentValues == null ? new ArrayList() : currentValues;
    currentValues.add(value)
    allValuesByHash.put(hash, currentValues)
}
 
def getHash(AOProjectValue value){
    def fieldType = FieldType.getFieldTypeByKey(value.getField().getType())
    return fieldType.isMultiple() ? getHashForMultipleField(value) : getHashForSimpleField(value)
}
 
def getHashForMultipleField(AOProjectValue value){
    return "PROJECT("+ value.projectId +"); FIELD_ID("+ value.field.ID +"); VALUE("+ value.value +"); DISPLAY("+ value.display +"); PARENT_ID("+ value.parentId +");".toLowerCase()
}
 
def getHashForSimpleField(AOProjectValue value){
    return "PROJECT("+ value.projectId +"); FIELD_ID("+ value.field.ID +");".toLowerCase()
}
 
def getValueInString(AOProjectValue value){
    return "<br/> ID(<b>"+ value.ID +"</b>); PROJECT(<b>"+ value.projectId +"</b>); FIELD_ID(<b>"+ value.field.ID +"</b>); FIELD_TYPE(<b>"+ value.field.type +"</b>); VALUE(<b>"+ value.value +"</b>); DISPLAY(<b>"+ value.display +"</b>); PARENT-VALUE(<b>"+ value.parentValue +"</b>) PARENT-ID(<b>"+ value.parentId +"</b>); CHILDREN(<b>"+ getNumberOfChildren(value) +"</b>);"
}
 
def removeDuplicated(List<AOProjectValue> duplicated){
    List<AOProjectValue> withChildren = new ArrayList<>();
    List<AOProjectValue> withoutChildren = new ArrayList<>();
    duplicated.sort{a,b -> (a.ID <=> b.ID) }
    duplicated.each{ fillByNumberOfChildren(it, withChildren, withoutChildren)}
    def listToRemove = getListToRemove(withChildren, withoutChildren)
    listToRemove.each{
        println.add(getValueInString(it))
        projectValueMgr.delete(it)
    }
}
 
def fillByNumberOfChildren(AOProjectValue value, List withChildren, List withoutChildren){
    def numberOfChildren = getNumberOfChildren(value)
    if(numberOfChildren == 0) withoutChildren.add(value)
    else withChildren.add(value)
}
 
def getNumberOfChildren(AOProjectValue value){
    def parent = projectValueMgr.getByParentCustom(value.value)
    return parent == null ? null : parent.size();
}
 
def getListToRemove(List<AOProjectValue> withChildren, List<AOProjectValue> withoutChildren){
    if(withChildren.isEmpty()) return withoutChildren.subList(1, withoutChildren.size())
    if(withChildren.size() == 1) return withoutChildren
    List listToRemove = withChildren.size(1, withChildren.size())
    listToRemove.addAll(withoutChildren)
    return listToRemove
}

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.ao.v2.layout.LayoutMgr
import com.deiser.jira.profields.ao.v2.viewitem.AOViewItem
import com.deiser.jira.profields.ao.v2.viewitem.ViewItemMgr
import com.deiser.jira.profields.api.layout.view.SectionView
import com.deiser.jira.profields.api.layout.view.ViewItem
import com.google.common.collect.Lists
import groovy.transform.Field
import org.apache.commons.collections.ListUtils

import java.util.stream.Collectors

@Field ViewItemMgr viewItemMgr = ComponentAccessor.getOSGiComponentInstanceOfType(ViewItemMgr.class)
@Field LayoutMgr layoutMgr = ComponentAccessor.getOSGiComponentInstanceOfType(LayoutMgr.class)
@Field List println = []

execute()


//EXECUTE
def execute(){
    def layouts = layoutMgr.get()
    layouts.each {
        iterateByLayout(it)
    }
    return println
}

//LAYOUTS
def iterateByLayout(layout){
    def sourceItems = viewItemMgr.getByLayout(layout)
    checkAndFix(layout, sourceItems)
}

def checkAndFix(layout, sourceItems){
    //Get all structure
    def structure = getAllSections(sourceItems)
    addToPrint(layout, structure)

    //Remove all duplicated sections
    def duplicatedSections = removeAllDuplicatedSections(structure)
    addToPrintDeletedDuplicatedSections(duplicatedSections)

    //Remove all orphan
    def deletedOrphans = removeUntilThereAreNoOrphans()
    addToPrintDeletedOrphans(deletedOrphans)

    //Split
    addToPrintSplit()
}

//SECTIONS
def getAllSections(sourceItems){
    return sourceItems.stream()
            .filter{it -> isSection(it)}
            .map{it -> new ViewNode(item: it, children: getAllColumns(it, sourceItems), type: "Section")}
            .collect(Collectors.toList())
}

boolean isSection(viewItem){
    return viewItem.parentId == null
}

int compareSection(viewNode1, viewNode2){
    boolean comparative = viewNode1.item.name == viewNode2.item.name &&
            viewNode1.item.position == viewNode2.item.position &&
            ((viewNode1.children == null && viewNode2.children == null) ||
                    (viewNode1.children.size() == viewNode2.children.size()))
    return comparative ? 0 : 1
}

def removeAllDuplicatedSections(structure){
    def sectionsUniques = structure.toUnique{ sect1, sect2 -> compareSection(sect1, sect2) }
    def thereAreDuplicatedSections = structure.size() != sectionsUniques.size();
    if(thereAreDuplicatedSections){
        def repeatedSections = ListUtils.removeAll(structure, sectionsUniques)
        def repeatedViewItemSections = repeatedSections.stream().map { it -> it.item }.collect(Collectors.toList())

        this.viewItemMgr.delete(repeatedViewItemSections)
        return repeatedViewItemSections
    }
    return [];
}



//COLUMNS
def getAllColumns(section, sourceItems){
    return columns = sourceItems.stream()
            .filter{ it -> isColumn(section, it) }
            .map{it-> new ViewNode(item: it, children: getAllContainer(it, sourceItems), type: "Column")}
            .collect(Collectors.toList())
            .sort{ a -> a.item.position}
}

boolean isColumn(section, viewItem){
    return viewItem.parentId != null &&
            viewItem.parentId == section.ID &&
            viewItem.name == null &&
            viewItem.fieldId == null
}



//CONTAINERS
def getAllContainer(column, sourceItems){
    return sourceItems.stream()
            .filter{it -> isContainer(column, it)}
            .map{it -> new ViewNode(item: it, children: getAllFields(it, sourceItems), type: "Container")}
            .collect(Collectors.toList())
            .sort{ a -> a.item.position}
}

boolean isContainer(column, viewItem){
    return viewItem.parentId != null &&
            viewItem.parentId == column.ID &&
            viewItem.name
}

//FIELDS
def getAllFields(container, sourceItems){
    return sourceItems.stream()
            .filter{it ->  isField(container, it)}
            .map{it -> new ViewNode(item: it, children: null, type: "Field")}
            .collect(Collectors.toList())
            .sort{ a -> a.item.position}
}

def isField(container, viewItem){
    return viewItem.parentId != null &&
            viewItem.parentId == container.ID &&
            viewItem.getFieldId() != null
}


class ViewNode {
    AOViewItem item
    List<ViewNode> children;
    String type;

    def compare(ViewNode node){
        return item.name == node.item.name &&
                item.position == node.item.position &&
                item.fieldId == node.item.fieldId &&
                item.required == node.item.required &&
                item.layout.ID == node.item.layout.ID &&
                compareChildren(node.children)
    }

    def compareChildren(List<AOViewItem> nodeChildren){
        if(children == null && nodeChildren == null) return true;

        if(children.size() !=  nodeChildren.size()) return false;

        def compareResult = true
        children.eachWithIndex { ViewNode item, int index ->
            compareResult &= item.compare(nodeChildren.get(index))
            if(compareResult == false) return false
        }
        return compareResult
    }

    def printToString(){
        def itemString = item.position + " ID["+ item.ID +"] NAME["+ item.name +"] PARENT-ID["+ item.parentId +"] FIELD-ID["+ item.fieldId +"] <br/>"
        def childrenString = this.children == null
                ? ""
                : this.children.stream()
                .map{it -> it.printToString()}
                .collect(Collectors.joining(""))

        def tab  = ""
        switch(type){
            case "Section":
                break;
            case "Column":
                tab += "        "
                break;
            case "Container":
                tab += "        " + "        "
                break;
            case "Field":
                tab += "        " + "        " + "        " + "    "
                break;
        }

        return tab + type + " --> " +  itemString + childrenString
    }
}

//REMOVE ORPHAN
def removeUntilThereAreNoOrphans(){
    def hasOrphan = true
    def printlnToOrphans = []

    while(hasOrphan){
        hasOrphan = removeOrphan(printlnToOrphans)
    }

    return printlnToOrphans
}

def removeOrphan(println){
    def hasRemoved = false
    viewItemMgr.get().each {
        def parentId = it.getParentId()
        if(parentId != null && parentId >= 0){
            if(viewItemMgr.get(parentId) == null){
                println.add( "ID: "+ it.ID +", Name: "+ it.name +" / ")
                viewItemMgr.delete(it)
                hasRemoved = true
            }
        }
    }
    return hasRemoved
}


//PRINTS
def addToPrint(layout, structure){
    println.add("Layout ("+ layout.ID +")  <b>"+ layout.name +"</b><br/>Structure:<br/>")
    println.add(structure.stream().map{it -> it.printToString()}.collect(Collectors.toList()))
}

def addToPrintDeletedDuplicatedSections(duplicatedSections){
    if(duplicatedSections){
        def prefix = "<br/> <b>Deleted Sections:</b>";
        def duplicatedString = duplicatedSections.stream().map{it -> "ID: "+ it.ID +", Name: "+ it.name +" / "}.collect(Collectors.joining(" / "))
        println.add(prefix + duplicatedString + "<br/>")
    }
}

def addToPrintSplit(){
    println.add("   ------------    ------------    ------------   ------------    ------------    ------------   <br/>")
}

def addToPrintDeletedOrphans(deletedOrphans){
    if(!deletedOrphans.isEmpty()){
        println.add("<b>Orphans Deleted:</b> " + deletedOrphans + "<br/>")
    }
}

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.ao.v2.projectlayout.AOProjectLayout
import com.deiser.jira.profields.ao.v2.projectlayout.ProjectLayoutMgr


def projectLayoutMgr = ComponentAccessor.getOSGiComponentInstanceOfType(ProjectLayoutMgr.class)
def projectManager = ComponentAccessor.getProjectManager()
def println = ""

def allProjectLayout = projectLayoutMgr.get()
if(allProjectLayout != null && allProjectLayout.length > 0){
    allProjectLayout.each {
        def haveToDelete = it == null || projectManager.getProjectObj(it.getProjectId()) == null
        if(haveToDelete){

            println += "<br/>"
            println += (it == null || it.getProjectId() == null) ? "Layout-Project is empty. " : "Layout-Project for Project: " + it.getProjectId() + "  "

            projectLayoutMgr.delete(it)
            println += "Deleted!!"
        }
    }
}

return println

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.ao.v2.field.FieldMgr
import com.deiser.jira.profields.ao.v2.listitem.AOListItem
import com.deiser.jira.profields.ao.v2.listitem.ListItemMgr
import com.deiser.jira.profields.ao.v2.listitem.ListItemType
import groovy.transform.Field;

@Field ListItemMgr listItemMgr = ComponentAccessor.getOSGiComponentInstanceOfType(ListItemMgr.class)
@Field FieldMgr fieldMgr = ComponentAccessor.getOSGiComponentInstanceOfType(FieldMgr.class)




String getMessageError(AOListItem listItem){
    String error = ""
    error += getValidField(listItem)
    error += getValidType(listItem)
    error += getValidCustomId(listItem)
    error += getValidData(listItem)
    error += getValidOrder(listItem)
    return error
}

String getValidField(AOListItem listItem){
    String error = ""
    error += listItem.getFieldId() == null ? "FieldId NULL; " : ""
    error += (error == "") && listItem.getFieldId() <= 0 ? "FieldId-0; " : ""
    error += (error == "") && fieldMgr.get(listItem.getFieldId()) == null ? "Field Not Exist; " : ""
    return error
}

String getValidType(AOListItem listItem){
    String error = ""
    error += listItem.getListItemType() == null ? "Type NULL; " : ""
    error += (error == "") && !ListItemType.isValidKey(listItem.getListItemType()) ? "Type Not Valid Value; " : ""
    return error
}

String getValidCustomId(AOListItem listItem){
    String error = ""
    error += listItem.getCustomId() == null ? "CustomId NULL" : ""
    error += (error == "") && listItem.getCustomId() == "" ? "CustomId is EMPTY;" : ""
    return error
}

String getValidData(AOListItem listItem){
    String error = ""
    error += listItem.getData() == null ? "Data NULL; " : ""
    error += (error == "") && listItem.getData() == "" ? "Data is EMPTY;" : ""
    return error
}

String getValidOrder(AOListItem listItem){
    String error = ""
    error += listItem.getOrder() == null ? "Order NULL; " : ""
    error += (error == "") && listItem.getOrder() <= 0 ? "Order-0" : ""
    return error
}



def print = ""
listItemMgr.get().each {
    def error = getMessageError(it)
    if(error != ""){
        print += "ID " + it.ID + ": " + error + " <br/> "
    }
}
return "<b>List Items With ERRORS:</b> <br/>" + print

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.ao.v2.field.FieldMgr
import com.deiser.jira.profields.ao.v2.listitem.AOListItem
import com.deiser.jira.profields.ao.v2.listitem.ListItemMgr
import com.deiser.jira.profields.api.configuration.ConfigurationService
import groovy.transform.Field
@Field ListItemMgr listItemMgr = ComponentAccessor.getOSGiComponentInstanceOfType(ListItemMgr.class)
@Field boolean UPDATE = true
main()
/* **** METHODS **** */
def main(){
    def itemsByFieldID = getAllItemsByFieldID()
    def itemsToChange = checkOrder(itemsByFieldID)
    def println = printItems(itemsToChange)
    if(UPDATE){
        listItemMgr.save(itemsToChange)
        println.add(" UPDATED ALL <br/>")
    }
    return println
}
def getAllItemsByFieldID(){
    def fieldWithItems = [:]
    listItemMgr.get().each {
        def values = fieldWithItems[it.fieldId]
        if(values == null){
            fieldWithItems[it.fieldId] = [it]
        }
        else{
            values.add(it)
            fieldWithItems[it.fieldId] = values
        }
    }
    return fieldWithItems
}
def checkOrder(HashMap map){
    def itemsToChange = []
    def keys = map.keySet()
    keys.each{
        def values = map[it]
        orderItems(values, itemsToChange)
    }
    return itemsToChange
}
def printItems(List<AOListItem> items){
    def println = [" *** ITEMS TO UPDATE *** <br/>"]
    items.each { println.add(itemToString(it))}
    return println
}
def orderItems(List<AOListItem> items, List<AOListItem> itemsToChange){
    def sortedItems = items.sort{ a, b -> a.order <=> b.order}
    sortedItems.eachWithIndex { AOListItem entry, int i ->
        if(entry.order != (i +1)){
            entry.order = i + 1
            itemsToChange.add(entry)
        }
    }
}
String itemToString(AOListItem item){
    return String.format("ID(%d); ORDER(%d) FIELD_ID(%d); TYPE(%s); <br/>",
            item.ID,
            item.order,
            item.fieldId,
            item.listItemType
    )
}

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.ao.v2.field.AOField
import com.deiser.jira.profields.ao.v2.field.FieldMgr
import groovy.json.JsonOutput
import groovy.json.JsonSlurper
 
def fieldMgr = ComponentAccessor.getOSGiComponentInstanceOfType(FieldMgr.class)
 
def FIELD_IDs = [X, X];
def CONNECTION_ID = Y
 
def println = "Start <br/>"
 
 
 
FIELD_IDs.each {
 
    def fieldList = fieldMgr.getById(it)
 
    if(fieldList.length == 1){
 
        def field = fieldList[0]
        def data = field.getData()
 
        println += "     Field: Id(" + field.ID + ") Name(" + field.name + ") Data(" + field.data + ") <br/>"
 
        def jsonSlurper = new JsonSlurper()
        def objectJson = jsonSlurper.parseText(data)
 
        objectJson.connectionId = CONNECTION_ID
        def newData = JsonOutput.toJson(objectJson)
 
        field.setData(newData)
 
        println += "     Before Save: Id(" + field.ID + ") Name(" + field.name + ") Data(" + field.data + ") <br/>"
 
        fieldMgr.save(field)
 
        println += "     Saved! <br/>"
    }
}
 
println

import com.deiser.jira.profields.api.subscription.SubscriptionService
import com.atlassian.jira.component.ComponentAccessor

ComponentAccessor.getOSGiComponentInstanceOfType(SubscriptionService.class)
    .get()
    .collect{" - ${it.user}: ${it.name}"}
    .join("<br/>")

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.config.managedconfiguration.ManagedConfigurationItem
import com.atlassian.jira.config.managedconfiguration.ManagedConfigurationItemService
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.fields.CustomField
import com.deiser.jira.profields.ao.v2.field.FieldMgr
 
CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager()
ManagedConfigurationItemService managedConfigurationItemService = ComponentAccessor.getComponent(ManagedConfigurationItemService.class);
 
FieldMgr fieldMgr = ComponentAccessor.getOSGiComponentInstanceOfType(FieldMgr.class)
 
def objects = customFieldManager.getCustomFieldObjects()
print = "*** CustomFields of Profields *** <br/>"
 
def each = objects.each {
    def customType = it.getCustomFieldType().toString()
    if (customType.contains("com.deiser.jira.profields")) {
 
        print += "CustomField ID: " + it.idAsLong + "<br/>"
        print += "Type: " + it.getCustomFieldType().toString() + "<br/>"
        print += "Name: " + it.name + "<br/>"
 
        def field = fieldMgr.getFieldByCustomField(it.idAsLong)
        if(field != null){
            print += "Oh Yeah! It's correct! <br/>"
        }
        else{
            print += "This customfield doesn't exist in Profields <br/>"
 
            ManagedConfigurationItem managedCreatedCustomField = managedConfigurationItemService.getManagedCustomField(it);
            managedConfigurationItemService.removeManagedConfigurationItem(managedCreatedCustomField)
            customFieldManager.removeCustomField(it)
 
            print += "Deleted!! <br/>"
        }
 
        print += "<br/><br/>"
    }
}
 
print

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.config.managedconfiguration.ConfigurationItemAccessLevel
import com.atlassian.jira.config.managedconfiguration.ManagedConfigurationItem
import com.atlassian.jira.config.managedconfiguration.ManagedConfigurationItemBuilder
import com.atlassian.jira.config.managedconfiguration.ManagedConfigurationItemService
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.fields.CustomField
import com.deiser.jira.profields.ao.v2.field.FieldMgr
 
 
String PLUGIN_NAME = "com.deiser.jira.profields";
 
CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager()
ManagedConfigurationItemService managedConfigurationItemService = ComponentAccessor.getComponent(ManagedConfigurationItemService.class);
 
def objects = customFieldManager.getCustomFieldObjects()
print = "*** CustomFields of Profields *** <br/>"
 
objects.each {
    def customType = it.getCustomFieldType().toString()
    if (customType.contains(PLUGIN_NAME)) {
 
        print += "CustomField ID: " + it.idAsLong + "<br/>"
        print += "Type: " + it.getCustomFieldType().toString() + "<br/>"
        print += "Name: " + it.name + "<br/>"
 
        ManagedConfigurationItem managedCreatedCustomField = managedConfigurationItemService.getManagedCustomField(it);
        ManagedConfigurationItemBuilder managedConfigurationItemBuilder = managedCreatedCustomField.newBuilder();
        ManagedConfigurationItem managedConfigurationItem = managedConfigurationItemBuilder
                .setManaged(false)
                .setConfigurationItemAccessLevel(ConfigurationItemAccessLevel.ADMIN)
                .build();
 
        managedConfigurationItemService.updateManagedConfigurationItem(managedConfigurationItem);
        print += 'Unlock CustomField <br/><br/>'
    }
}
 
print

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.api.configuration.ConfigurationService
import static com.atlassian.jira.component.ComponentAccessor.getOSGiComponentInstanceOfType

def configurationService = ComponentAccessor.getOSGiComponentInstanceOfType(ConfigurationService.class)
configurationService.setCache(true)

import com.atlassian.jira.component.ComponentAccessor
import com.deiser.jira.profields.api.configuration.ConfigurationService
import static com.atlassian.jira.component.ComponentAccessor.getOSGiComponentInstanceOfType

def configurationService = ComponentAccessor.getOSGiComponentInstanceOfType(ConfigurationService.class)
configurationService.setCache(false)

import com.atlassian.jira.component.ComponentAccessor
import org.apache.commons.lang3.exception.ExceptionUtils
import org.ofbiz.core.entity.ConnectionFactory
import org.ofbiz.core.entity.DelegatorInterface
 
import java.sql.ResultSet
import java.sql.Statement
 
def delegator = ComponentAccessor.getComponentOfType(DelegatorInterface.class)
def helperName = delegator.getGroupHelperName("default")
def connection = ConnectionFactory.getConnection(helperName)
 
def result = ""
try {
 
    def stmt = connection.createStatement()
     
     ResultSet rs = stmt.executeQuery(
            "select propertystring.id, propertystring.propertyvalue " +
            "from propertyentry, propertystring " +
            "where propertyentry.id = propertystring.id " +
            "and propertyentry.property_key = 'AO_00B950_#'"
     );
     
        while (rs.next()) {
            def id = rs.getString("id");
            def value = rs.getString("propertyvalue");
 
            result += "Version of Profields Database : " + value + "<br/>"
        }
 
} catch (def e) {
    result += "<br/> Error: <br/>" + ExceptionUtils.getStackTrace(e)
}
 
return result

import com.atlassian.jira.component.ComponentAccessor
import org.apache.commons.lang3.StringUtils
import org.apache.commons.lang3.exception.ExceptionUtils
import org.ofbiz.core.entity.ConnectionFactory
import org.ofbiz.core.entity.DelegatorInterface
import java.sql.Statement
 
def delegator = ComponentAccessor.getComponentOfType(DelegatorInterface.class)
def helperName = delegator.getGroupHelperName("default")
def connection = ConnectionFactory.getConnection(helperName)
 
def arrayColumns = ["DISPLAY", "LOWER_DISPLAY", "VALUE", "LOWER_VALUE", "PARENT_VALUE"] as String[]
 
def result = ""
try {
    def statement = connection.createStatement()
 
    arrayColumns.each {
 
    statement.execute("alter table AO_00B950_AOPROJECT_VALUE add " + it +"2 clob")
        statement.execute("update AO_00B950_AOPROJECT_VALUE set " + it +"2 = " + it)
        statement.execute("update AO_00B950_AOPROJECT_VALUE set " + it +" = null")
        statement.execute("alter table AO_00B950_AOPROJECT_VALUE drop column " + it)
 
        statement.execute("alter table AO_00B950_AOPROJECT_VALUE add " + it +" varchar2(4000)")
        statement.execute("update AO_00B950_AOPROJECT_VALUE set " + it +" = " + it +"2")
        statement.execute("alter table AO_00B950_AOPROJECT_VALUE drop column " + it +"2")
 
        result += "Completed " + it + "! <br/>"
 
    }
     
 
} catch (def e) {
    result += "<br/> Error: <br/>" + ExceptionUtils.getStackTrace(e)
}
 
return result

import com.atlassian.jira.component.ComponentAccessor
import org.apache.commons.lang3.StringUtils
import org.apache.commons.lang3.exception.ExceptionUtils
import org.ofbiz.core.entity.ConnectionFactory
import org.ofbiz.core.entity.DelegatorInterface
import java.sql.Statement
 
def delegator = ComponentAccessor.getComponentOfType(DelegatorInterface.class)
def helperName = delegator.getGroupHelperName("default")
def connection = ConnectionFactory.getConnection(helperName)
 
def arrayColumns = ["NEW_VALUE", "OLD_VALUE", "NEW_DISPLAY", "OLD_DISPLAY"] as String[]
 
 
def result = ""
try {
    def statement = connection.createStatement()
 
    arrayColumns.each {
 
    statement.execute("alter table AO_00B950_AOHISTORICAL_FIELD add " + it +"2 clob")
        statement.execute("update AO_00B950_AOHISTORICAL_FIELD set " + it +"2 = " + it)
        statement.execute("update AO_00B950_AOHISTORICAL_FIELD set " + it +" = null")
        statement.execute("alter table AO_00B950_AOHISTORICAL_FIELD drop column " + it)
 
        statement.execute("alter table AO_00B950_AOHISTORICAL_FIELD add " + it +" varchar2(4000)")
        statement.execute("update AO_00B950_AOHISTORICAL_FIELD set " + it +" = " + it +"2")
        statement.execute("alter table AO_00B950_AOHISTORICAL_FIELD drop column " + it +"2")
 
        result += "Completed " + it + "! <br/>"
 
    }
     
 
} catch (def e) {
    result += "<br/>Error:<br/>" + ExceptionUtils.getStackTrace(e)
}
 
return result

import com.atlassian.jira.component.ComponentAccessor
import org.apache.commons.lang3.StringUtils
import org.apache.commons.lang3.exception.ExceptionUtils
import org.ofbiz.core.entity.ConnectionFactory
import org.ofbiz.core.entity.DelegatorInterface
import java.sql.Statement
 
def delegator = ComponentAccessor.getComponentOfType(DelegatorInterface.class)
def helperName = delegator.getGroupHelperName("default")
def connection = ConnectionFactory.getConnection(helperName)
 
def arrayColumns = ["DATA", "LOWER_DATA"] as String[]
 
 
def result = ""
try {
    def statement = connection.createStatement()
 
    statement.execute("alter table AO_00B950_AOLIST_ITEM modify DATA null")
 
    arrayColumns.each {
 
        statement.execute("alter table AO_00B950_AOLIST_ITEM add " + it +"2 clob")
        statement.execute("update AO_00B950_AOLIST_ITEM set " + it +"2 = " + it)
        statement.execute("update AO_00B950_AOLIST_ITEM set " + it +" = null")
        statement.execute("alter table AO_00B950_AOLIST_ITEM drop column " + it)
 
        statement.execute("alter table AO_00B950_AOLIST_ITEM add " + it +" varchar2(4000)")
        statement.execute("update AO_00B950_AOLIST_ITEM set " + it +" = " + it +"2")
        statement.execute("alter table AO_00B950_AOLIST_ITEM drop column " + it +"2")
 
        result += "Completed " + it + "! <br/>"
 
    }
     
     statement.execute("alter table AO_00B950_AOLIST_ITEM modify DATA not null")
 
} catch (def e) {
    result += "<br/>Error:<br/>" + ExceptionUtils.getStackTrace(e)
}
 
return result