Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 4.0.M5
    • None
    • Core Library
    • None

    Description

             List<Object[]> result = ObjectSelect.query(Artist.class)
                      // result
                      .columns(artistCount, minSalary, namePart)
                      // WHERE clause
                      .where(Artist.DATE_OF_BIRTH.lt(new Date())) 
                      // additional condition in WHERE clause
                      .or(...)                      
                      // HAVING clause
                      .having(namePart.like("P%"))                
                      // additional condition in HAVING clause
                      .or(...)                                    
                      .select(context);
      
              for(Object[] r : result) {
                  long count = (long)r[0];
                  int min = (int)r[1];
                  String name = (String)r[2];
              }
      

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            ntimofeev Nikita Timofeev
            ntimofeev Nikita Timofeev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment