helpTestProcess("SELECT * FROM xmltest.doc1 WHERE ItemID > ANY (SELECT itemNum FROM stock.items WHERE itemNum IN (SELECT itemNum FROM stock.items WHERE itemNum IN ('001','002') ) )", expectedDoc, metadata, dataMgr); //$NON-NLS-1$
}
@Test public void testSubqueryInXMLQueryCriteriaNestedMappingClass() throws Exception {
FakeMetadataFacade metadata = exampleMetadataCached();
FakeDataManager dataMgr = exampleDataManagerNested(metadata);
String expectedDoc =
"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n" + //$NON-NLS-1$
"<Catalogs>\r\n" + //$NON-NLS-1$
" <Catalog>\r\n" + //$NON-NLS-1$
" <Items>\r\n" + //$NON-NLS-1$