Start line:  
End line:  

Snippet Preview

Snippet HTML Code

Stack Overflow Questions
  /*
   * Copyright 2014-2015 the original author or authors.
   *
   * Licensed under the Apache License, Version 2.0 (the "License");
   * you may not use this file except in compliance with the License.
   * You may obtain a copy of the License at
   *
   *     http://www.apache.org/licenses/LICENSE-2.0
   *
  * Unless required by applicable law or agreed to in writing, software
  * distributed under the License is distributed on an "AS IS" BASIS,
  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
  * either express or implied. See the License for the specific language
  * governing permissions and limitations under the License.
  */
 package org.dbflute.cbean.coption;

The option for ScalarSelect.
You can filter an aggregate function by scalar function filters.

Author(s):
jflute
 
 public class ScalarSelectOption extends FunctionFilterOption {
 
     // ===================================================================================
     //                                                                     Function Option
     //                                                                     ===============
     
Set the value for coalesce function.
If you set string value and the derived column is date type, it converts it to a date object internally. For example, "2010-10-30 12:34:56.789", "2010/10/30" and so on ... are acceptable.

Parameters:
coalesce An alternate value when group function returns null. (NullAllowed: if null, no coalesce)
Returns:
this. (NotNull)
 
     public ScalarSelectOption coalesce(Object coalesce) {
         doCoalesce(coalesce);
         return this;
     }

    
Round the specified part of the number.

Parameters:
round Decimal digits or date format for round. (NullAllowed: if null, no round)
Returns:
this. (NotNull)
 
     public ScalarSelectOption round(Object round) {
         doRound(round);
         return this;
     }

    
Truncate the specified part of the number or date-time value.

Parameters:
trunc Decimal digits or date option for trunc. (NullAllowed: if null, no trunc)
Returns:
this. (NotNull)
 
     public ScalarSelectOption trunc(Object trunc) {
         doTrunc(trunc);
         return this;
     }
 
     // ===================================================================================
     //                                                                      Purpose Option
     //                                                                      ==============
     // -----------------------------------------------------
     //                                         Truncate Date
     //                                         -------------
     
Truncate the month and day and time part of the date or the date-time value.
  e.g. 2012/12/31 01:50:46 -> 2012/01/01 00:00:00
 

Returns:
this. (NotNull)
 
     public ScalarSelectOption truncMonth() {
         doTruncMonth();
         return this;
     }

    
Truncate the day and time part of the date or the date-time value.
  e.g. 2012/12/31 01:50:46 -> 2012/12/01 00:00:00
 

Returns:
this. (NotNull)
 
     public ScalarSelectOption truncDay() {
         doTruncDay();
         return this;
     }

    
Truncate the time part of the date-time value.
  e.g. 2012/12/31 01:50:46 -> 2012/12/31 00:00:00
 

Returns:
this. (NotNull)
 
     public ScalarSelectOption truncTime() {
         doTruncTime();
         return this;
    }
    // -----------------------------------------------------
    //                                              Add Date
    //                                              --------
    // no DreamCruise ticket when ScalarSelect
    // cannot use not grouping column
    
Add years to the date or date-time value.

Parameters:
addedYear The count of added years. (NullAllowed: if null, no dateAdd)
Returns:
this. (NotNull)
    public ScalarSelectOption addYear(Integer addedYear) {
        doAddYear(addedYear);
        return this;
    }

    
Add months to the date or date-time value.

Parameters:
addedMonth The count of added months. (NullAllowed: if null, no dateAdd)
Returns:
this. (NotNull)
    public ScalarSelectOption addMonth(Integer addedMonth) {
        doAddMonth(addedMonth);
        return this;
    }

    
Add days to the date or date-time value.

Parameters:
addedDay The count of added days. (NullAllowed: if null, no dateAdd)
Returns:
this. (NotNull)
    public ScalarSelectOption addDay(Integer addedDay) {
        doAddDay(addedDay);
        return this;
    }

    
Add hours to date-time value.

Parameters:
addedHour The count of added hours. (NullAllowed: if null, no dateAdd)
Returns:
this. (NotNull)
    public ScalarSelectOption addHour(Integer addedHour) {
        doAddHour(addedHour);
        return this;
    }

    
Add minutes to date-time value.

Parameters:
addedMinute The count of added minutes. (NullAllowed: if null, no dateAdd)
Returns:
this. (NotNull)
    public ScalarSelectOption addMinute(Integer addedMinute) {
        doAddMinute(addedMinute);
        return this;
    }

    
Add seconds to date-time value.

Parameters:
addedSecond The count of added seconds. (NullAllowed: if null, no dateAdd)
Returns:
this. (NotNull)
    public ScalarSelectOption addSecond(Integer addedSecond) {
        doAddSecond(addedSecond);
        return this;
    }
New to GrepCode? Check out our FAQ X