How to set band value in where clause using Groovy script

Support
#1

Hi,

How can we fetch the value from another band under where clause using groovy script?

for ex:
I tried this but failed:

def NAME
def tx = persistence.createTransaction()
try {
    def em = persistence.getEntityManager()
    NAME= persistence.getEntityManager().reload(params['Name'], "Name-screen-view")
	


} finally {
    tx.end()
}

[["FirstName":NAME.firstName,
"ID":NAME.id]]

Where:

ID == ${header.userID}

here ${header.userID} is the value set in header band so based on ${header.userID} I want to fetch value for FirstName
(${header.userID} & “ID”:NAME.id both having same values. Name .id is a subset of header.userID)

Note: I already set the parameters for both screens i.e., header & Name

Thanks,
Saurabh

#3

Hi

If a header is a parent band for the band with groovy script, you can access value using:

def groupId = parentBand.getParameterValue('userID')

Thanks,
Andrey