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.
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 |
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: |
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". |
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. |
com.fujitsu.xml.xbrl.xwand.taxonomy.PresentationArc |
|
Weight |
The weight attribute
value specified in the arc. |
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. |
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. |
com.fujitsu.xml.xbrl.xwand.taxonomy.Label |
|
LabelLanguage |
The language of the label. |
com.fujitsu.xml.xbrl.xwand.taxonomy.Label |
|
PartURI |
The namespace URI of
the part element. |
com.fujitsu.xml.xbrl.xwand.taxonomy.Part |
|
PartName |
The local name of the part element. |
com.fujitsu.xml.xbrl.xwand.taxonomy.Part |
|
PartValue |
The contents of the part element. |
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. |
com.fujitsu.xml.xbrl.xwand.instance.Period |
|
StartDate |
The start date of the context referenced by the
fact. |
com.fujitsu.xml.xbrl.xwand.instance.Period |
|
EndDate |
The end date of the context referenced by the
fact. |
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. |
java.lang.String |
|
CalculatedValue |
The calculation results value. |
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. |
com.fujitsu.xml.xbrl.xwand.instance.Period |
|
StartDate |
The context start date.
|
com.fujitsu.xml.xbrl.xwand.instance.Period |
|
EndDate |
The context end date.
|
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 |
List of functions are shown below.
Table: Function list (String functions)
|
Components |
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. |
Table: Function list (Number functions)
|
Components |
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 |
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 |
Description |
|
xbrl_label(element, [lang [, labelRole [, extendedLinkRole]]]) |
Returns the label of the
element. |
|
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 |
Description |
|
if(condition, expr1, expr2) |
If condition is true, returns expr1. Otherwise returns expr2. |
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".