BiTel

Connection con = connectionSet3.getConnection();
ContractParameterManager cpm = new ContractParameterManager(con);
String str=cpm.getListParamValue(cid,61);
print (str);

OUT:
61

Connection con = connectionSet3.getConnection();
ContractParameterManager cpm = new ContractParameterManager(con);
String str=cpm.getListParamValue(cid,61);
print (str);

OUT:
Нет

import ru.bitel.bgbilling.kernel.script.server.dev.EventScriptBase;
import ru.bitel.bgbilling.kernel.event.Event;
import ru.bitel.bgbilling.server.util.Setup;
import ru.bitel.common.sql.ConnectionSet;
import bitel.billing.common.TimeUtils;
import ru.bitel.bgbilling.kernel.event.events.ContractCreatedEvent;
import bitel.billing.server.npay.bean.ServiceObjectManager;
import bitel.billing.server.npay.bean.ServiceObject;
import java.sql.*;
import java.util.Date;
import bitel.billing.server.contract.bean.*;


public class myclass
   extends EventScriptBase
{
   @Override
   public void onEvent( Event event1, Setup setup2, ConnectionSet connectionSet3 )
      throws Exception
   {

Connection con = connectionSet3.getConnection();
ContractParameterManager cpm = new ContractParameterManager(con);

int cid = event1.getContractId();
String str=cpm.getListParamValue(cid,61);
print (str);

if (str.equals("Да"))
{print("Да");}
if (str.equals("Нет")) {print( "Нет"); }
   }
}

            String query = "SELECT if ( cp.val < 1, cp.custom_value, vls.title ) FROM contract_parameter_type_7 as cp LEFT JOIN contract_parameter_type_7_values as vls ON vls.id=cp.val WHERE cid=? AND cp.pid=?";
            PreparedStatement ps = con.prepareStatement( query );
            ps.setInt( 1, cid );
            ps.setInt( 2, pid );
           ResultSet rs = ps.executeQuery();
            if ( rs.next() )
            {
                result = rs.getString( 1 );
            }
            rs.close();
            ps.close();