I am trying to make a fetch using custom SQL, I tried with CustomQueryExpressionHintKey, but I also needed to return raw rows instead of complete Enterprise Objects, the thing is that it looks like if I use raw rows my custom SQL is ignored. Here is the code:
EOFetchSpecification fs = new EOFetchSpecification("Inventory", null, null, false, false, null);
fs.setHints(new NSDictionary("SELECT t0.productid, t0.qty FROM public.inventory t0 WHERE t0.productid IN(1, 2, 3, 4, 5, 6)", "CustomQueryExpressionHintKey");
fs.setRawRowKeyPaths(new NSArray(new String[] {"productid", "qty"}));
fs.setRefreshesRefetchedObjects(true);
NSArray inventory = ec.objectsWithFetchSpecification(fs);
Logged SQL:
SELECT t0.productid, t0.qty FROM public.inventory
as you can see my SQL was ignored.
Am I doing something wrong?, or the CustomQueryExpressionHintKey is only intended to fetch complete EO's?
