Package lu.kbra.pclib.db.annotations.view

Annotation Interface View

@Documented
@Retention(RUNTIME)
@Target(TYPE)
public @interface View

Required Element Summary

Required Elements

Modifier and Type	Required Element	Description
Table[]	tables

Optional Element Summary

Optional Elements

Modifier and Type	Optional Element	Description
String	condition
String	customSQL
String	dbms
String[]	groupBy
String	name
OrderBy[]	orderBy
UnionTable[]	unionTables
WithTable[]	with

Element Details

condition

@QueryableHint(type="VIEW_CONDITION")
String condition

Default:

""

customSQL

@QueryableHint(type="VIEW_CUSTOM_SQL")
String customSQL

Default:

""

groupBy

@QueryableHint(type="VIEW_GROUP_BY")
String[] groupBy

Default:

{}

name

@QueryableHint(type="NAME_OVERRIDE")
String name

Default:

""

orderBy

@QueryableHint(type="VIEW_ORDER_BY")
OrderBy[] orderBy

Default:

{}

tables

@QueryableHint(type="VIEW_TABLES")
Table[] tables

unionTables

@QueryableHint(type="VIEW_UNION_TABLES")
UnionTable[] unionTables

Default:

{}

with

@QueryableHint(type="VIEW_WITH_TABLES")
WithTable[] with

Default:

{}

dbms

@DbmsFilter
String dbms

Default:

""