Developer's Guide > Developer's Guide > Codebeamer Development > Execute a custom script > Example Custom Script to Find Items Having a Specific Field Value
Example Custom Script to Find Items Having a Specific Field Value
package config.scripts.workflow



import com.intland.codebeamer.event.util.VetoException

import com.intland.codebeamer.manager.*



if (!beforeEvent) {

return; // do NOTHING on after-event, everything is handled in the before-event

}



// Acquiring the cbQL Manager from codeBeamer

cbQLManager = applicationContext.getBean(CbQLManager.class)



// Parameters of a custom field

def projectId = 280

def trackerId = 35774

def fieldProperty = "customField[1]"



// Desired value of the custom field

def fieldValue = 3



// Query string to find all tracker items having the desired value on the field

def cbQL = "project.id IN (${projectId}) AND tracker.id IN (${trackerId}) AND '${trackerId}.${fieldProperty}' = ${fieldValue}"



// Extracting the tracker item list

trackerItemQueryResult = cbQLManager.runQuery(event.getRequest(), cbQL, new CbQLManager.PagingParams(5, 0));

trackerItemsPage = trackerItemQueryResult.getTrackerItems();

trackerItems = trackerItemsPage.getList();



// Some action

throw new VetoException(trackerItems.get(0).toString())
Was this helpful?