Databases
StackOverflow2013
Postsdbo
POXPath query with variable multiple conditions
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POXPath query with variable multiple conditions
    primarykey
    data
    text
    <p>Long-time listener, first-time caller. I'm relatively new to XPath and looked at several other threads here and elsewhere but I can't seem to get a query working, any help would be great.</p> <p>I have XML as follows:</p> <pre><code>&lt;catalog&gt; &lt;book pgid="28054" lang="en"&gt; &lt;title&gt;The Brothers Karamazov&lt;/title&gt; &lt;author&gt;Dostoyevsky, Fyodor&lt;/author&gt; &lt;friendly_title&gt;The Brothers Karamazov by Fyodor Dostoyevsky&lt;/friendly_title&gt; &lt;file&gt; &lt;type&gt;ePub&lt;/type&gt; &lt;path&gt;cache/generated/28054/&lt;/path&gt; &lt;name&gt;pg28054.epub&lt;/name&gt; &lt;size&gt;800&lt;/size&gt; &lt;/file&gt; &lt;file&gt; &lt;type&gt;PDF&lt;/type&gt; &lt;path&gt;2/8/0/5/28054/&lt;/path&gt; &lt;name&gt;28054-pdf.pdf&lt;/name&gt; &lt;size&gt;5829&lt;/size&gt; &lt;/file&gt; &lt;file&gt; &lt;type compression="zipped"&gt;PDF&lt;/type&gt; &lt;path&gt;2/8/0/5/28054/&lt;/path&gt; &lt;name&gt;28054-pdf.zip&lt;/name&gt; &lt;size&gt;1693&lt;/size&gt; &lt;/file&gt; &lt;file&gt; &lt;type encoding="utf-8" compression="zipped"&gt;Text&lt;/type&gt; &lt;path&gt;2/8/0/5/28054/&lt;/path&gt; &lt;name&gt;28054-0.zip&lt;/name&gt; &lt;size&gt;726&lt;/size&gt; &lt;/file&gt; &lt;/book&gt; &lt;/catalog&gt; </code></pre> <p>(catalog is the root element, and in this example there are no <code>&lt;contributor&gt;</code> elements)</p> <p>I have the query working on author, contributor, title, and language searches, but I am getting hung up on adding a file type condition. This query to find books with author OR contributor containing "Dostoyevsky" and title containing "Brothers" with language "en" is <em>working</em> (i.e. giving expected results), but if there's a better way to write it I'm all ears:</p> <pre><code>/catalog//book/*[(contains(self::author,'Dostoyevsky') or contains(self::contributor,'Dostoyevsky')) and contains(../title,'Brothers') and ../@lang = 'en'] </code></pre> <p>What I <em>can't</em> get to work is limiting the query results to files of a certain type, i.e. appending <code>and ../file/type='PDF'</code> or something. Didn't have any luck with <code>|</code> unions either.</p> <p>Thanks in advance.</p> <p>Oh, and if it matters, the query needs to be built dynamically (from form input), so it needs to retain a universal syntax that would work with any number of user-supplied criteria.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USswornabsent
    1. USswornabsent
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POXPath query with variable multiple conditions
      1. USBrian
      1. VTFavorite
    2. VO
      singulars
      1. POXPath query with variable multiple conditions
      1. USswornabsent
      1. VTFavorite
    1. COPlease, do your homework and at least provide real, well-formed and meaningful XML document.
      singulars
      1. POXPath query with variable multiple conditions
      1. USDimitre Novatchev
    2. COWhat is it you want, Dimitre? This _is_ my real XML. I didn't think the content was relevant.
      singulars
      1. POXPath query with variable multiple conditions
      1. USswornabsent
    3. CO@swornabsent : Dimitre is right, your XML is not well formed. The way you write your lang attribute is not XML. You should update your question to make it valid (e.g. lang="...").
      singulars
      1. POXPath query with variable multiple conditions
      1. USVincent Biragnet
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload