Subobject and "best" value query

Declaration

{{#subobject:
 |Assessment name=Assessment 1a
 |Assessment year=2005
 |Assessment value=13
 |@category=Assessment
}}{{#subobject:
 |Assessment name=Assessment 1b
 |Assessment year=2006
 |Assessment value=2
 |@category=Assessment
}}{{#subobject:
 |Assessment name=Assessment 1c
 |Assessment year=2005
 |Assessment value=14
 |@category=Assessment
}}

Standard table

	Assessment name	Assessment year	Assessment value
Subobject and "best" value query	Assessment 1c	2005	14
Subobject and "best" value query	Assessment 1a	2005	13
Subobject and "best" value query	Assessment 1b	2006	2

Highest assessment value

{{#ask: [[Category:Assessment]]
  <q>[[Assessment value::{{#ask: [[Category:Assessment]] |?Assessment value|sort=Assessment value|order=desc|limit=1 
|headers=hide|mainlabel=-|link=none|searchlabel=}}]]
  </q>
 |?Assessment name
 |?Assessment year
 |?Assessment value
}}

	Assessment name	Assessment year	Assessment value
Subobject and "best" value query	Assessment 1c	2005	14

{{#ask: [[-Has subobject::{{FULLPAGENAME}}]]
  <q>[[Assessment value::{{#ask: [[-Has subobject::{{FULLPAGENAME}}]] |?Assessment value|sort=Assessment value|order=desc|limit=1 
|headers=hide|mainlabel=-|link=none|searchlabel=}}]]
  </q>
 |?Assessment name
 |?Assessment year
 |?Assessment value
}}

	Assessment name	Assessment year	Assessment value
Subobject and "best" value query	Assessment 1c	2005	14

Lowest assessment value

{{#ask: [[Category:Assessment]]
  <q>[[Assessment value::{{#ask: [[Category:Assessment]] |?Assessment value|sort=Assessment value|order=asc|limit=1 
|headers=hide|mainlabel=-|link=none|searchlabel=}}]]
  </q>
 |?Assessment name
 |?Assessment year
 |?Assessment value
}}

	Assessment name	Assessment year	Assessment value
Subobject and "best" value query	Assessment 1b	2006	2