Uploaded image for project: 'Apache MetaModel (Retired)'
  1. Apache MetaModel (Retired)
  2. METAMODEL-1134

Support for NOT / NOT IN operator

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 5.0.0
    • 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

          Activity

            People

              Unassigned Unassigned
              h.drexler Hans Drexler
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: