Explanation of Syntax

 

Query statement examples

Some examples query statements are given below.

 

(1) select * from element

Returns all columns from the element declaration table.

 

(2) select distinct StartDate, EndDate from context

Returns unique results from the Start date and End date columns of the context table.

 

(3) select Value from fact where ElementLabel = 'Sales'

Returns the value of the item with the label "Sales". The language and role used to compare labels are determined by the "Label view" settings under "Editor view settings".

 

(4) select ElementLabel, Value from fact where ElementLabel = /Sales/ and Value < 0

Returns the label and value of items that include "Sales" in the label and have a value of less than zero.

 

(5) select Element, ElementLabel, Value from fact  where Element in (select Element from fact except select Element from presentation)

Returns the element name, label, and value for items that are not specified in presentation links and that have a value.

 

(6) select Element, Label, value from fact, label where fact.Element = label.Element

Returns the element name, label, and value from the results of combining, as equivalents, item value tables and label link tables where the element name is the same.

 

Table name list

The following values can be specified in table names.

Table name

Data contents

Remarks

file

Files included in DTSs and instances

none

element

Element declarations

none

presentation

Presentation links

Links for which overwriting is resolved

calculation

Calculation links

Links for which overwriting is resolved

definition

Definition links

Links for which overwriting is resolved

label

Label links

Links for which overwriting is resolved

reference

Reference links

Links for which overwriting is resolved

unresolvedpresentation

Presentation links

All links

unresolvedcalculation

Calculation links

All links

unresolveddefinition

Definition links

All links

unresolvedlabel

Label links

All links

unresolvedreference

Reference links

All links

roletype

roleType elements

none

arcroletype

arcroleType elements

none

context

Contexts

none

unit

Units

none

fact

Item values

none

footnote

Footnote links

none

calculationerror

Item values that the calculation check identified as errors

none

filerelationship

File relationship information

none

namespacedecl

Namespace declarations

none

 

Column name list

The tables below list the column names used in various tables.

Column name list for file tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

SystemId

The system identifier of the file

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

FileType

The file type:
-
Instance: "instance"
-
Schema: "schema"
-
Presentation linkbase: "presentation"
-
Calculation linkbase: "calculation"
-
Definition linkbase: "definition"
-
Label linkbase: "label"
-
Reference linkbase: "reference"
-
Other linkbases: "user"

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

Comment

The content of the comment that appears before the root element

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

 

 

Column name list for arcroletype tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

SchemaSystemId

The system identifier of the schema that defines the arcroleType element

com.fujitsu.xml.xbrl.xwand.taxonomy.XMLSchema

SchemaTargetNamespace

Target namespace of the schema that defines the arcroleType element

com.fujitsu.xml.xbrl.xwand.taxonomy.XMLSchema

ArcroleTypeId

ID attribute value of the arcroleType element

com.fujitsu.xml.xbrl.xwand.taxonomy.role.ArcroleType

ArcroleURI

The arc role URI

com.fujitsu.xml.xbrl.xwand.taxonomy.role.ArcroleType

ArcroleUsedOn

Contents of the arc role UsedOn element

com.fujitsu.xml.xbrl.xwand.taxonomy.role.UsedOnList

CyclesAllowed

Contents of the arc role cyclesAllowed attribute

com.fujitsu.xml.xbrl.xwand.taxonomy.role.ArcroleType

ArcroleDefinition

The arc role definition

com.fujitsu.xml.xbrl.xwand.taxonomy.role.Definition

 

Column name list for roletype tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

SchemaSystemId

The system identifier of the schema that defines the roleType element

com.fujitsu.xml.xbrl.xwand.taxonomy.XMLSchema

SchemaTargetNamespace

Target namespace of the schema that defines the roleType element

com.fujitsu.xml.xbrl.xwand.taxonomy.XMLSchema

RoleTypeId

ID attribute value of the roleType element

com.fujitsu.xml.xbrl.xwand.taxonomy.role.RoleType

RoleURI

The role URI

com.fujitsu.xml.xbrl.xwand.taxonomy.role.RoleType

RoleUsedOn

Contents of the role UsedOn element

com.fujitsu.xml.xbrl.xwand.taxonomy.role.UsedOnList

RoleDefinition

The role definition

com.fujitsu.xml.xbrl.xwand.taxonomy.role.Definition

 

 

Column name list for element tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

SchemaSystemId

The system identifier of the schema that defines the element

com.fujitsu.xml.xbrl.xwand.taxonomy.XMLSchema

SchemaTargetNamespace

Target namespace of the schema that defines the element

com.fujitsu.xml.xbrl.xwand.taxonomy.XMLSchema

Element

Qualified name of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementId

ID attribute value of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementLabel

A label that is associated with an element and matches the "Language", "Label link role", and Label role" set for "Label view" under "Editor view settings".
(The explanation for the ElementLabel column in the other tables below is the same as here.)
This is a blank character string if none of the labels match.

com.fujitsu.xml.xbrl.xwand.taxonomy.Label

ElementPrefix

Prefix of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementURI

The element namespace URI

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementName

The local name of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeURI

The namespace URI of the element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeName

The local name of the element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupURI

The namespace URI of the element substitution group

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupName

The local name of the element substitution group

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementPeriodType

The date type of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementBalance

The balance classification of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementAbstract

Indicates whether or not the element is an abstract element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementNillable

Indicates whether or not nil can be set for the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

 

 

Column name list for presentation, calculation, definition, unresolvedpresentation,unresolvedcalculation, and unresolveddefinition tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

LinkbaseSystemId

System identifier of the linkbase that defines the link

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

Element

Qualified name of the link destination element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementId

ID attribute value of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementLabel

The label associated with the link destination element

com.fujitsu.xml.xbrl.xwand.taxonomy.Label

ElementPrefix

Prefix of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementURI

The namespace URI of the link destination element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementName

The local name of the link destination element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeURI

The namespace URI of the link destination element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeName

The local name of the link destination element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupURI

The namespace URI of the substitution group for the link destination element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupName

The local name of the substitution group for the link destination element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementPeriodType

The date type of the link destination element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementBalance

The balance classification of the link destination element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementAbstract

Indicates whether or not the link destination element is an abstract element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementNillable

Indicates whether or not nil can be set for the link destination element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ParentElement

The qualified name of the link source element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

XLinkRole

The extended link role of the link

com.fujitsu.xml.xbrl.xwand.common.XLinkDecl

SrcLocatorRole

The link source locator role

com.fujitsu.xml.xbrl.xwand.common.Locator

SrcLocatorLabel

The xlink:label attribute value of the link source locator

com.fujitsu.xml.xbrl.xwand.common.Locator

DestLocatorRole

The link destination locator role

com.fujitsu.xml.xbrl.xwand.common.Locator

DestLocatorLabel

The xlink:label attribute value of the link destination locator

com.fujitsu.xml.xbrl.xwand.common.Locator

Arcrole

The arc role specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

LinkOrder

The order specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

Priority

The priority specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

Use

The use attribute value specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

PreferredLabel

The preferredLabel attribute value specified in the arc.
This is enabled only in the presentation and  unresolvedpresentation tables.

com.fujitsu.xml.xbrl.xwand.taxonomy.PresentationArc

Weight

The weight attribute value specified in the arc.
This is enabled only in the calculation and  unresolvedcalculation tables.

com.fujitsu.xml.xbrl.xwand.taxonomy.CalculationArc

TargetRole

The xbrldt:targetRole attribute value specified in the arc. This is enabled only in the definition and  unresolveddefinition tables.

com.fujitsu.xml.xbrl.xwand.common.Arc

ContextElement

The xbrldt:contextElement attribute value specified in the arc. This is enabled only in the definition and  unresolveddefinition tables.

com.fujitsu.xml.xbrl.xwand.common.Arc

Closed

The xbrldt:closed attribute value specified in the arc. This is enabled only in the definition and  unresolveddefinition tables.

com.fujitsu.xml.xbrl.xwand.common.Arc

Usable

The xbrldt:usable attribute value specified in the arc. This is enabled only in the definition and  unresolveddefinition tables.

com.fujitsu.xml.xbrl.xwand.common.Arc

The data type for the following columns is numeric values, and other columns are character columns:

LinkOrder, Priority, Weight

 

 

Column name list for label, reference, unresolvedlabel, and unresolvedreference tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

LinkbaseSystemId

System identifier of the linkbase that defines the link

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

Element

The qualified name of the link source element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementId

ID attribute value of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementLabel

The label associated with the link source element.
This is enabled only in reference and unresolvedreference tables.

com.fujitsu.xml.xbrl.xwand.taxonomy.Label

ElementPrefix

Prefix of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementURI

The namespace URI of the link source element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementName

The local name of the link source element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeURI

The namespace URI of the link source element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeName

The local name of the link source element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupURI

The namespace URI of the substitution group for the link source element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupName

The local name of the substitution group for the link source element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementPeriodType

The data type for the link source element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementBalance

The balance classification for the link source element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementAbstract

Indicates whether or not the link source element is an abstract element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementNillable

Indicates whether or not nil can be specified in the link source element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

XLinkRole

The extended link role of the link

com.fujitsu.xml.xbrl.xwand.common.XLinkDecl

SrcLocatorRole

The link source locator role

com.fujitsu.xml.xbrl.xwand.common.Locator

SrcLocatorLabel

The xlink:label attribute value of the link source locator

com.fujitsu.xml.xbrl.xwand.common.Locator

DestLocatorRole

The link destination locator role

com.fujitsu.xml.xbrl.xwand.common.Locator

DestLocatorLabel

The xlink:label attribute value of the link destination locator

com.fujitsu.xml.xbrl.xwand.common.Locator

Arcrole

The arc role specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

LinkOrder

The order specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

Priority

The priority specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

Use

The use attribute value specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

Label

The contents of the label.
This is enabled only in label and unresolvedlabel tables.

com.fujitsu.xml.xbrl.xwand.taxonomy.Label

LabelLanguage

The language of the label.
This is enabled only in label and unresolvedlabel tables.

com.fujitsu.xml.xbrl.xwand.taxonomy.Label

PartURI

The namespace URI of the part element.
This is enabled only in the reference and unresolvedreference tables.

com.fujitsu.xml.xbrl.xwand.taxonomy.Part

PartName

The local name of the part element.
This is enabled only in the reference and unresolvedreference tables.

com.fujitsu.xml.xbrl.xwand.taxonomy.Part

PartValue

The contents of the part element.
This is enabled only in the reference and unresolvedreference tables.

com.fujitsu.xml.xbrl.xwand.taxonomy.Part

The data type for the following columns is numeric values, and other columns are character columns:

LinkOrder, Priority

 

 

Column name list for fact and calculationerror tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

InstanceSystemId

The system identifier of the instance document

com.fujitsu.xml.xbrl.xwand.instance.Instance

Element

The qualified name of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementId

ID attribute value of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementLabel

The label associated with the element

com.fujitsu.xml.xbrl.xwand.taxonomy.Label

ElementPrefix

Prefix of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementURI

The namespace URI of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementName

The local name of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeURI

The namespace URI of the element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeName

The local name of the element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupURI

The namespace URI of the substitution group for the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupName

The local name of the substitution group for the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementPeriodType

The date type of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementBalance

The balance classification of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementAbstract

Indicates whether or not the link source element is an abstract element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementNillable

Indicates whether or not nil can be specified in the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

Value

The fact value

com.fujitsu.xml.xbrl.xwand.instance.Item

Tuple

The path expression for the tuple belonging to the fact. If a tuple does not belong, this is null.

com.fujitsu.xml.xbrl.xwand.instance.Tuple

Precision

The precision attribute value of the fact

com.fujitsu.xml.xbrl.xwand.instance.Item

Decimals

The decimals attribute value of the fact

com.fujitsu.xml.xbrl.xwand.instance.Item

Language

The xml:lang attribute value of the fact

com.fujitsu.xml.xbrl.xwand.instance.Item

Nil

The xsi:nil attribute value of the fact. If not specified, this is "false".

com.fujitsu.xml.xbrl.xwand.instance.Item

ContextId

The context ID referenced by the fact

com.fujitsu.xml.xbrl.xwand.instance.Context

Period

The date of the context referenced by the fact.
-
If the date type is instant: That date
-
If the date type is duration: Start date, End date
-
If the date type is forever: "Forever"

com.fujitsu.xml.xbrl.xwand.instance.Period

StartDate

The start date of the context referenced by the fact.
-
If the date type is instant: That date
-
If the date type is duration: Start date
-
If the date type is forever: "Forever"

com.fujitsu.xml.xbrl.xwand.instance.Period

EndDate

The end date of the context referenced by the fact.
-
If the date type is instant: That date
-
If the date type is duration: End date
-
If the date type is forever: "Forever"

com.fujitsu.xml.xbrl.xwand.instance.Period

Identifier

The identifier of the context referenced by the fact

com.fujitsu.xml.xbrl.xwand.instance.Identifier

Scheme

The scheme of the context referenced by the fact

com.fujitsu.xml.xbrl.xwand.instance.Identifier

Segment

The XML expression for the segment of the context referenced by the fact. If there are no segments, this is null.

com.fujitsu.xml.xbrl.xwand.instance.Segment

Scenario

The XML expression for the scenario of the context referenced by the fact. If there are no scenarios, this is null.

com.fujitsu.xml.xbrl.xwand.instance.Scenario

UnitId

The ID of the unit referenced by the fact. If the fact is a non-numeric value type, this is a blank character string.

com.fujitsu.xml.xbrl.xwand.instance.Unit

UnitContent

The contents of the unit referenced by the fact. If the fact is a non-numeric value type, this is a blank character string.

com.fujitsu.xml.xbrl.xwand.instance.Unit

XLinkRole

The extended link role of the calculation link in the error.
This is enabled only in the Calculationerror table.

java.lang.String

CalculatedValue

The calculation results value.
This is enabled only in the Calculationerror table.

java.math.BigDecimal

The data type for the following column is numeric values, and other columns are character columns:

CalculatedValue

 

Column name list for context tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

InstanceSystemId

The system identifier of the instance document

com.fujitsu.xml.xbrl.xwand.instance.Instance

ContextId

The context ID

com.fujitsu.xml.xbrl.xwand.instance.Context

Period

The date of the context.
-
If the date type is instant: That date
-
If the date type is duration: Start date, End date
-
If the date type is forever: "Forever"

com.fujitsu.xml.xbrl.xwand.instance.Period

StartDate

The context start date.
-
If the date type is instant: That date
-
If the date type is duration: Start date
-
If the date type is forever: "Forever"

 

com.fujitsu.xml.xbrl.xwand.instance.Period

EndDate

The context end date.
-
If the date type is instant: That date
-
If the date type is duration: End date
-
If the date type is forever: "Forever"

 

com.fujitsu.xml.xbrl.xwand.instance.Period

Identifier

The context identifier

com.fujitsu.xml.xbrl.xwand.instance.Identifier

Scheme

The scheme of the context

com.fujitsu.xml.xbrl.xwand.instance.Identifier

Segment

The XML expression for the segment of the context. If there are no segments, this is a blank character string.

com.fujitsu.xml.xbrl.xwand.instance.Segment

Scenario

The XML expression for the scenario of the context. If there are no scenarios, this is a blank character string.

com.fujitsu.xml.xbrl.xwand.instance.Scenario

 

 

Column name list for unit tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

InstanceSystemId

The system identifier of the instance document

com.fujitsu.xml.xbrl.xwand.instance.Instance

UnitId

The unit ID. If the fact is a non-numeric value type, this is a blank character string.

com.fujitsu.xml.xbrl.xwand.instance.Unit

UnitContent

The contents of the unit. If the fact is a non-numeric value type, this is a blank character string.

com.fujitsu.xml.xbrl.xwand.instance.Unit

 

 

Column name list for footnote tables

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

LinkbaseSystemId

The system identifier of the instance document

com.fujitsu.xml.xbrl.xwand.instance.Instance

Element

The qualified name of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementId

ID attribute value of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementLabel

The label associated with the element

com.fujitsu.xml.xbrl.xwand.taxonomy.Label

ElementPrefix

Prefix of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementURI

The namespace URI of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementName

The local name of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeURI

The namespace URI of the element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementTypeName

The local name of the element type

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupURI

The namespace URI of the substitution group for the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementSubstitutionGroupName

The local name of the substitution group for the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementPeriodType

The date type of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementBalance

The balance classification of the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementAbstract

Indicates whether or not the link source element is an abstract element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

ElementNillable

Indicates whether or not nil can be specified in the element

com.fujitsu.xml.xbrl.xwand.taxonomy.ElementDecl

Value

The fact value

com.fujitsu.xml.xbrl.xwand.instance.Item

Tuple

The path expression for the tuple belonging to the fact. If a tuple does not belong, this is blank characters

com.fujitsu.xml.xbrl.xwand.instance.Tuple

Precision

The precision attribute value of the fact

com.fujitsu.xml.xbrl.xwand.instance.Item

Decimals

The decimals attribute value of the fact

com.fujitsu.xml.xbrl.xwand.instance.Item

Language

The xml:lang attribute value of the fact

com.fujitsu.xml.xbrl.xwand.instance.Item

Nil

The xsi:nil attribute value of the fact. If not specified, this is "false".

com.fujitsu.xml.xbrl.xwand.instance.Item

ContextId

The ID of the context referenced by the fact

com.fujitsu.xml.xbrl.xwand.instance.Context

UnitId

The ID of the unit referenced by the fact. If the fact is a non-numeric value type, this is a blank character string.

com.fujitsu.xml.xbrl.xwand.instance.Unit

XLinkRole

The extended link role of the link

com.fujitsu.xml.xbrl.xwand.common.XLinkDecl

SrcLocatorRole

The link source locator role

com.fujitsu.xml.xbrl.xwand.common.Locator

SrcLocatorLabel

The xlink:label attribute value of the link source locator

com.fujitsu.xml.xbrl.xwand.common.Locator

DestLocatorRole

The link destination locator role

com.fujitsu.xml.xbrl.xwand.common.Locator

DestLocatorLabel

The xlink:label attribute value of the link destination locator

com.fujitsu.xml.xbrl.xwand.common.Locator

Arcrole

The arc role specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

LinkOrder

The order specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

Priority

The priority specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

Use

The use attribute value specified in the arc

com.fujitsu.xml.xbrl.xwand.common.Arc

Footnote

The contents of the footnote

com.fujitsu.xml.xbrl.xwand.instance.Footnote

FootnoteLanguage

The footnote language

com.fujitsu.xml.xbrl.xwand.instance.Footnote

The data type for the following columns is numeric values, and other columns are character columns:

LinkOrder, Priority

 

 

Column name list for filerelationship table

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

SrcSystemId

The system identifier of the source file

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

SrcFileType

The file type of the source file (same as the FileType column of the file table)

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

DestSystemId

The system identifier of the destination file

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

DestFileType

The file type of the destination file (same as the FileType column of the file table)

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

RelationshipType

The relationship type:

-       “import” : the destination file is obtained from the import element

-       “schemaRef” : the destination file is obtained from the schemaRef element

-       “linkbaseRef” : the destination file is obtained from the linkbaseRef element

-       “roleRef” : the destination file is obtained from the roleRef element

-       “arcroleRef” : the destination file is obtained from the arcroleRef element

-       “locator” : the destination file is obtained from the loc element

java.lang.String

 

 

Column name list for namespacedecl table

Column name

Explanation

Return Type of

XBRLResultSet.getObject method

SystemId

The system identifier of the file

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

FileType

The file type (same as the FileType column of the file table)

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

Prefix

The namespace prefix

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

NamespaceURI

The namespace URI

com.fujitsu.xml.xbrl.xwand.common. XBRLDocument

 

 

Function list

List of functions are shown below.

 

Table: Function list (String functions)

 

Components
(String functions)

Description

concat(str1, str2 [, str3])

Returns a concatenated string.

length(str)

Returns the length of a string.

lower(str)

Returns the argument in lowercase.

substr(str, startIndex[, length])

Returns the substring of a string. If length is omitted, the function returns a substring starting at startIndex until the end of the input string.

upper(str)

Returns the argument in uppercase.

instr(str, searchstr, [,position [, occurrence]])

Returns the start position of searchstr within str.
Returns 0 if searchstr is not found. If a negative integer -n is passed to position, the search begins from the nth position of the end to the head of string.

 

Table: Function list (Number functions)

 

Components
(Number functions)

Description

abs(num)

Returns the absolute value.

ceil(num)

Returns the smallest integer value not less than the argument.

floor(num)

Returns the largest integer value not greater than the argument.

round(num)

Rounds the argument.

 

Table: Function list (Aggregate functions)

 

Components
(Aggregate functions)

Description

avg(expr)

Returns the average value.

count("*" | expr | distinct columnName)

Returns a count of values. When "distinct columnName" is passed to the function, it counts the number of columnName values with duplicated values removed.

max(expr)

Returns the maximum value.

min(expr)

Returns the minimum value.

sum(expr)

Returns the sum.

 

Table: Function list (XBRL functions)

 

Components
(XBRL functions)

Description

xbrl_label(element, [lang [, labelRole [, extendedLinkRole]]])

Returns the label of the element.
The argument "element" must be either the column "element" or "parentelement", or a return value of xbrl_explicitmember().
When the 2nd, 3rd, 4th arguments are omitted, used instead are respectively: the label language, the label role, label extended link role selected in the Editor View Setting dialog box.

xbrl_explicitmember(dimItemNsURI, dimItemLocalName)

Returns the dimension member QName of the dimension item with the specified namespace URI and the local name. This function is available only for "fact" and "context" tables. When you apply it to other tables, it returns an empty string.

 

Table: Function list (Others)

 

Components
(Others)

Description

if(condition, expr1, expr2)

If condition is true, returns expr1. Otherwise returns expr2.

 

 

 

Explanation of syntax

The syntax of a query statement is shown below.

<select statement> (union [ all ] | intersect | except ) <select statement> ]... [group by <expression> [, <expression>...]] [having <condition statement>] [ order by <expression> [ asc | desc ]  [, <expression> [ asc | desc ] ]... ]

The syntax of a select statement is shown below.

select [distinct] ( "*" | <expression> [, <expression>]... ) from <table name> [[left | right] join <table name> [on <condition statement>]]... [ where <condition statement> ]

 

 

Table name:

Use a character string that has at least one character and is made up of alphanumerics and underscores. The first character must be an alphabetic.

Expression:

Either column name, function, number, string literals, or those connected by operators (any of +, -, *, /). For column names, if multiple tables are specified in the "from" clause, a column belonging to a specific table can be specified by entering the column before <table-name> and a period (.).

Condition statements:

The two types of simple condition statements are as follows:

<column-name> <relational-operator> (<column-name> | <numeric-value> | <character-string> | <regular-expression>)

<column-name> in "(" <select-statement> ")"

 

The above can be combined using not, and, or, and brackets.

not <condition-statement>

<condition-statement> and <condition-statement>

<condition-statement> or <condition-statement>

"(" <condition-statement> ")"

Relational operators:

= , != , <>, > , < , >= , <=

Numeric values:

Integers, decimal fractions, and floating-point representations can be used.

Character strings:

Enclose character strings in either double quotes or single quotes.

If double quotes are used in the representation, and a double quote is specified in the character string, enter two double quotes in succession.

If single quotes are used in the representation, and a single quote is specified in the character string, enter two single quotes in succession.

Regular expressions:

Enclose regular expression character strings between either slashes or backslashes ("\").

If slashes are used in the representation, and a slash is specified in the character string, enter two slashes in succession.

If backslashes are used in the representation, and a backslash is specified in the character string, enter two backslashes in succession.

Alias table/column name:

You can specify an alias table/column name using the "as" keyword as follows:

 

    select f.value as v, l.label as l from fact as f join label as l on f.element = l.element

 

 

Notes:

-   Keywords, table names, and column names are not case-sensitive.

-   The same table cannot be coded more than once in a "from" clause.

-   When a column name is followed by the operator "-", insert a white space between the column name and the "-". The character "-" can appear in a column name and therefore an expression such as "<column name>-" is treated as a column name which ends with "-". Thus a white space is required in order to avoid such ambiguity.

 

 

Supplementary information:

union, union all, intersect, and except operations

 

If two select statements are linked by a union, union all, intersect, or except operation, the same column must be specified in both statements.

The union operation returns the union of the results of two select statements. Duplicated data is excluded.

The union all operation returns the union of the results of two select statements. Duplicated data is not excluded.

The intersect operation returns the intersection of the results of two select statements. Duplicated data is excluded.

The except operation returns the exceptions of two select statements. Duplicated data is excluded.

 

in condition statement operation

 

If the value in the column specified before the in clause is included in the results of the select statement specified after the in clause, the result is "true".

If it is not included, the result is "false".