Cacher is the code snippet organizer for pro developers

    oInfoObjects = (IInfoObjects)iStore.query("Select * from CI_INFOOBJECTS where si_id =  142913"); 
    oInfoObject = (IInfoObject) oInfoObjects.get(0);
    ISchedulingInfo schedulingInfo = (ISchedulingInfo)oInfoObject.getSchedulingInfo();
    
    IProperties properties = (IProperties)schedulingInfo.properties();
    IProperties destination = (IProperties)properties.getProperties("SI_DESTINATIONS");
    IProperties internal = (IProperties)destination.getProperties("1");
    IProperties schedulingOptions = (IProperties)internal.getProperties("SI_DEST_SCHEDULEOPTIONS");
    IProperties mailAddress = (IProperties)schedulingOptions.getProperties("SI_MAIL_ADDRESSES");
    IProperty address = (IProperty)mailAddress.getProperty("1");
    String email1 = (String)address.getValue();
    log.write(email1);