Old BQL

gistfile1.txt

public PXSelectJoin<
   NGSampleTest,
   InnerJoin<NGSample2,
        On<NGSampleTest.sampleType, Equal<NGSample2.sampleType>,
        And<NGSampleTest.docRefNbr, Equal<NGSample2.docRefNbr>,
        And<NGSampleTest.docLineNbr, Equal<NGSample2.docLineNbr>>>>,
   LeftJoin<NGBiopsy,
        On<NGSample2.docRefNbr, Equal<NGBiopsy.refNbr>,
        And<NGSample2.sampleType, Equal<NGSampleType.embryo>>>,
   LeftJoin<NGPgtMRequisition,
        On<NGSample2.docRefNbr, Equal<NGPgtMRequisition.refNbr>,
        And<NGSample2.sampleType, Equal<NGSampleType.pgtmFamilySample>>>,
   LeftJoin<NGPgtASrRequisition,
        On<NGBiopsy.pgtASrReqRefNbr, Equal<NGPgtASrRequisition.refNbr>>>>>>,
   Where2<
        Where<NGSampleTest.sampleType, NotEqual<NGSampleType.control>,
        And<NGSampleTest.sampleType, NotEqual<NGSampleType.research>,
        And<IsNull<NGSampleTest.released, False>, Equal<False>>>>,
        And<Where<NGSampleTest.test, Equal<NGTest.pgta>,
        Or<NGSampleTest.test, Equal<NGTest.pgtaNextDay>,
        Or<NGSampleTest.test, Equal<NGTest.pgtsr>>>>>>>
AvailableTests;