Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
In MetaModel it is not possible to write a query containing a NOT/NOT IN operator. In our case we want to select the highest job from a table that is not in failed or completed state. This can not be done (ok, this example is a bit too easy, but in our project we have a query that can not be handled).
select max(jobid) from foo where state not in ('COMPLETE', 'FAILED')
Attachments
Issue Links
- links to