Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XSD with "required" attribute option related query 1

Status
Not open for further replies.
rajneesh4u

rajneesh4u

Systems Engineer
Feb 21, 2020
5
IN
Hello All,

I am new to XSD and XML and need to explore if there is option to make sure that any one attribute in a set of attributes within same element is required.

Example:

<xs:element name="where" maxOccurs="1" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="condition" maxOccurs="unbounded" minOccurs="1">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute type="xs:string" name="alias1" use="required"/>
<xs:attribute type="xs:string" name="col1" use="required"/>
<xs:attribute type="xs:string" name="operator" use="required"/>
<xs:attribute type="xs:string" name="string" use="optional"/>
<xs:attribute type="xs:string" name="number" use="optional"/>
<xs:attribute type="xs:string" name="date" use="optional"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>

Here I want to ensure that minimum one attribute in a set of 3 attributes (mentioned as optional in above) are required. All can not be optional , however any one (can be more than one also) is required.

Thanks,
Rajneesh
 
Sort by date Sort by votes
Rajneesh,

With what version of XML Schema are you working?
 
Upvote 0 Downvote
Hi atlopes,

Thanks for your reply.

version="1.0"

This XSD is generated through online tool , by providing XML as input file. XML is also 1.0 version.

Thanks,
Rajneesh
 
Upvote 0 Downvote
Ok, Rajneesh, I don't think you'll be able to enforce that rule with version 1.0 of the XML Schema.

But even if the online tool you're using does not support version 1.1, and as long as your validator/parser does, you can post-process the schema to mandate the presence of one of the attributes.

The highlighted areas of the schema require your attention. Basically, you say version 1.1 is required and then include an assertion that returns true when one of the optional attributes is included in the document.

XML: 
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema"[/URL] elementFormDefault="qualified"
  targetNamespace="info:xml-forum" xmlns="info:xml-forum"
  [highlight #FCE94F]xmlns:vc="[URL unfurl="true"]http://www.w3.org/2007/XMLSchema-versioning"[/URL] vc:minVersion="1.1"[/highlight]>
  
  <xs:element name="where">
  <xs:complexType>
    <xs:sequence>
      <xs:element name="condition" maxOccurs="unbounded" minOccurs="1">
        <xs:complexType>
        <xs:simpleContent>
          <xs:extension base="xs:string">
            <xs:attribute type="xs:string" name="alias1" use="required"/>
            <xs:attribute type="xs:string" name="col1" use="required"/>
            <xs:attribute type="xs:string" name="operator" use="required"/>
            <xs:attribute type="xs:string" name="string" use="optional"/>
            <xs:attribute type="xs:string" name="number" use="optional"/>
            <xs:attribute type="xs:string" name="date" use="optional"/>
            [highlight #FCE94F]<xs:assert test="@string or @number or @date"/>[/highlight]
          </xs:extension>
        </xs:simpleContent>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
</xs:element>

</xs:schema>

An invalid XML document:
XML: 
<?xml version="1.0" encoding="UTF-8"?>
<f:where xmlns:f="info:xml-forum" xmlns:xsi="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema-instance"[/URL]
  xsi:schemaLocation="info:xml-forum forum.xsd">
  <f:condition alias1="alias1" col1="col1" operator="op"></f:condition>
</f:where>

A valid XML document (at least one of the attributes is present):
XML: 
<?xml version="1.0" encoding="UTF-8"?>
<f:where xmlns:f="info:xml-forum" xmlns:xsi="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema-instance"[/URL]
  xsi:schemaLocation="info:xml-forum forum.xsd">
  <f:condition alias1="alias1" col1="col1" operator="op" string="---"></f:condition>
</f:where>
 
Upvote 0 Downvote
Hi Atlopes,
I am working inside the database, it won't be possible.
Oracle XML DB only supports XML Schema 1.0.

Thanks,
Rajneesh

 
Upvote 0 Downvote
Rajneesh said:
Oracle XML DB only supports XML Schema 1.0
Click to expand...

Then you can't use assertions to extend the validation of your schemas.

I'm not familiar with your environment, but can't you submit your XML documents to an XSLT? A transformation stylesheet can be used as a validator, also.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rajneesh4u
  • Locked
  • Question
Is it possible to impose required constraint at value level?
Replies
1
Views
308
atlopes
atlopes
Spunny
  • Locked
  • Question
xsd schema for xml
Replies
0
Views
239
Spunny
Spunny
SerbanC
  • Locked
  • Question
What is wrong with this xml format ?
Replies
1
Views
265
feherke
feherke
rob4733
  • Locked
  • Question
xsd restriction error when validating xml
Replies
3
Views
334
k5tm
k5tm
StephenGunn
  • Locked
  • Question
xml from Team Center and conforming with XLST
Replies
1
Views
314
atlopes
atlopes

Part and Inventory Search

Sponsor

Back
Top