Class SpaceQuery

java.lang.Object
com.avoka.tm.query.SpaceQuery

public class SpaceQuery extends Object

Provides a form space query class.

Examples

Please find the space query examples about list, get first and count below.

Space Query List Example

This Groovy example shows how to list spaces matching certain criteria ordered ascending by name (maximum number of 4 records).

 import com.avoka.tm.query.*
 import com.avoka.tm.vo.*

 List<Space> spaces = new SpaceQuery()
     .setFetchLimit(4)
     .addOrderByAsc("name")
     .listValues()

 // In JSON format
 String spacesJson = new SpaceQuery()
     .setFetchLimit(4)
     .addOrderByAsc("name")
     .listJson() 

Space Query First Example

This Groovy example shows how to get first space matching certain criteria ordered descending by id.

 import com.avoka.tm.query.*
 import com.avoka.tm.vo.*

 Space space = new SpaceQuery()
     .setName(spaceName)
     .firstValue()

 // In JSON format
 String spaceJson = new SpaceQuery()
     .setName(spaceName)
     .firstJson()  

Space Query Count Example

This Groovy example shows how to count all spaces matching certain criteria.

 import com.avoka.tm.query.*

 int spaceWithCtxPathCount = new SpaceQuery()
     .setContextPath(ctxPath)
     .count() 
Since:
5.0.0
See Also:
  • Constructor Details

  • Method Details

    • setId

      public SpaceQuery setId(Long id)
      Set the space id (PK) query parameter.
      Parameters:
      id - the space id (PK) query parameter
      Returns:
      the space query
    • setName

      public SpaceQuery setName(String name)
      Set the space name query parameter.
      Parameters:
      name - the space name query parameter
      Returns:
      the space query
    • setContextPath

      public SpaceQuery setContextPath(String contextPath)
      Set the space context path parameter.
      Parameters:
      contextPath - the space content path parameter
      Returns:
      the space query
    • setFetchLimit

      public SpaceQuery setFetchLimit(int fetchLimit)
      Set the query fetch limit to limit the maximum number of records returned. The default query fetch limit is 100 records.
      Parameters:
      fetchLimit - the query fetch limit
      Returns:
      the space query
    • addOrderByAsc

      public SpaceQuery addOrderByAsc(String orderProperty)
      Add the sort order by ascending to the query.
      Parameters:
      orderProperty - the property to sort by (required)
      Returns:
      the space query
    • addOrderByDesc

      public SpaceQuery addOrderByDesc(String orderProperty)
      Add the sort order by descending to the query.
      Parameters:
      orderProperty - the property to sort by (required)
      Returns:
      the space query
    • count

      public int count()
      Execute a select count query and return the total number of records selected by the query.
      Returns:
      the total number of records selected by the query
    • listValues

      public List<Space> listValues()
      Execute the space query and return a list of Space value objects.
      Returns:
      execute the space query and return a list of Space value objects
    • listJson

      public String listJson()
      Execute the query and return a space JSON array list.
      Returns:
      execute the query and return a space JSON array list
    • firstValue

      public Space firstValue()
      Execute the query and return the first space value object for the query.
      Returns:
      execute the query and return the first space value object for the query
    • firstJson

      public String firstJson()
      Execute the query and return the first space JSON value.
      Returns:
      execute the query and return the first space JSON value