XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » XQuery sort & extract data
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-> + Problems with FTP upload via X... (3)
-> + What path notation works when ... (6)
-> - Xquery Exception (1)
-> + [java] [Fatal Error] Test.xml:... (2)
-> + unable to produce correct XML ... (2)
-> + where can I find stylusxql uti... (3)
-> + Trouble Mapping Multiple Eleme... (3)
-> - input parameter (1)
-> - set element value (1)
-> + Xquery Performance Issue (21)
-> + Run Xquery Program using Java (3)
-> + XQuery XML to CSV (3)
-> + XQuery MySQL connector (4)
-> + XQuery with JDBC connection is... (3)
-> + Create FTP Server (2)
-> + XQuery Nested Loop Lookup (5)
-> + Xpath using a Variable for [@I... (2)
-> - My xqDoc option is disabled. (1)
-> + Xpath ancestor selection (4)
-> + Exception: sequence of more th... (2)
-> + XQUF usage (3)
-> - xquery rule execution (1)
-> + Loving XQuery (3)
-> + Cross Referencing Country Name... (4)
-> + Creating a Pivot Table with xQ... (2)
-> + Error Please Help (3)
-> - Error Please Help (1)
-> + XPath descendant question (2)
-> + java/lang/OutOfMemoryError Run... (2)
-> + Xquery key value lookup (8)
-> + Improve xQuery Performance (3)
-> + MS SQL Server - Disable order ... (10)
-> + proper use of fn:distinct-valu... (2)
-> + Ignore DTD (7)
-> - Thanks Ivan (1)
-> + Trying to get 2nd value of nod... (5)
-> + Outer joins (4)
-> + Figured Out Issues From Last P... (2)
-> + Best Way To Generate Complex X... (3)
-> + count in xquery (4)
-> + left/right presentation (3)
-> + new to stylus - connecting to ... (2)
-> + XQuery problem with namespaces (4)
-> + .conv and xquery problem (3)
-> + Can pass text into CONV file (2)
-> + doc-available not working as e... (4)
-> + ddtekjava write to file only e... (5)
-> + arrayindexoutofbounds with ddt... (7)
-> + XSD: Structure definition depe... (2)
-> + Fatal Error whitespace expecte... (3)
-> + Executing a pipeline sequence ... (2)
-> - Data Transfer (1)
-> + Specifying the SEF File Locati... (4)
-> + Multiply numbers... (2)
-> + Using Generated Java-Code... (5)
-> + Mapper does not show all nodes... (5)
-> - Xul tree search using XQuery X... (1)
-> + converting XML to CSV (2)
-> - datadirect licenses (1)
-> + generate a uuid (2)
-> + Help to write Xquery (2)
-> + XQuery java ddtek:serialize-to... (2)
-> + EDI to XML Automation (2)
-> + Generating XQUERY to use in Or... (2)
-> + Stylus is not easy to learn XQ... (2)
-> - java.lang.OutOfMemoryError (1)
-> + how to save to xml format (2)
-> + Formating a date in xquery (2)
-> + two xml statements when mappin... (5)
-> + XQuery (2)
-> + saxon-license.lic Not Found (2)
-> + hands off conversion to final ... (2)
-> + fn:substring in XQuery to Orac... (4)
-> + Using Saxon with XQuery to ins... (4)
-> + Can't SAVE or DO a SAVE AS Fro... (2)
-> + Saxon Unexpected token < e o f... (2)
-> + Inserting and selecting data i... (2)
-> - convert sql statement into xml... (1)
-> + need help in converting this a... (2)
-> + IS IT POSSIBLE TO DO AN XQUERY... (2)
-> + XQUERY RESULTS NOT IN PROPER F... (2)
-> + how to get data from database ... (2)
-> + tree view in xquery (2)
-> + Need help with SelectsingleNod... (5)
-> - counting in query (1)
-> + WebApplication with Xquery (3)
-> + Limit to number of elements in... (3)
-> + Automate xquery Conversion (2)
-> + ddtek:wscall problem (2)
-> - Problem with case sensitive (1)
-> + Is this the formal tech suppor... (2)
-> + problem with Conditional Expre... (5)
-> - problem with Conditional Expre... (1)
-> + connect to mysql for xquery? (2)
-> - NOOB Help (1)
-> - Getting rid of empty namespace... (1)
-> + Xquery not yielding results (3)
-> - fn:replace() inserting spaces ... (1)
-> + Xquery XML document with spcei... (7)
-> + XLS (MS Excel) to XML Converte... (3)
-> + Little Help :))) (2)
-> + Xquery tag position (2)
-> - Can I connect to MonetDB/XQuer... (1)
-> + Is there a way to format a num... (2)
-> + Please help convert SQL query ... (3)
-> + Connect to SQL Server Express ... (3)
-> - Convert HTML to XML within C# ... (1)
-> + return different result based ... (7)
-> + Java Heap Space (2)
-> + XQuery Results export to multi... (3)
-> + NO RETURN (5)
-> + Part of a csv into a current X... (3)
-> + How to escape ampersand in xqu... (2)
-> + How to Convert CSV lines to in... (5)
-> + Data connection Stylus Studio ... (2)
-> + Nested XQuery FLOWRs with RDBM... (3)
-> + observing xquery at work (2)
-> + alternative for 'exists' (4)
-> + Xquery and webpages how? (2)
-> + Help with another DataDirect p... (5)
-> + How to resolve XPTY0004 error (3)
-> + Search a sequence of siblings ... (3)
-> + DataDirect process getting XPS... (2)
-> + Find the parent who doesn't ha... (3)
-> + Help with a basic FLWOR query (3)
-> + xQuery Efficient Performance B... (5)
-> + How to break down a sequence a... (3)
-> + Xquery returning odd number fo... (2)
-> + Problems with Java date parame... (3)
-> + Xquery filter on multiple valu... (2)
-> + Xquery filter by using contain... (5)
-> + multiple xslt execution using ... (2)
-> + How to access to global variab... (6)
-> + "Value can not be converted to... (4)
-> + (simple) problem with xquery (3)
-> + Version of xQuery Included wit... (3)
-> + xQuery 1.0 Produces XPTY0004 E... (3)
-> + Replace Node with Set of Nodes (2)
-> + Unable to Use File Name as Ext... (5)
-> + EDI to XSD and validation (2)
-> + Sample XQuery extension using ... (2)
-> + Another EDI problem (7)
-> + Removing xmls:od and xmls:xsi ... (2)
-> + Configuring MarkLogic with Sty... (10)
-> + EDI to XML (7)
-> + Can't write to SQL-Server (4)
-> + XQuery and SQL-Server (2)
-> + Connection to MS SQL Server in... (2)
-> + copy/modify with Stylus Studio... (5)
-> - copy/modify with Stylus Studio... (1)
-> + [SQLServer JDBC Driver]Value c... (5)
-> + wild card chracter usage in XS... (2)
-> + Xquery with SQL NEWID function (4)
-> + Change Only One Line (5)
-> + Format DB xQuery results (3)
-> + Adding MsSQL Database to XQuer... (3)
-> + Need help with using XQuery in... (2)
-> + please help! simple XML transf... (2)
-> + xquery for invoice data (3)
-> + Xquery to cross reference two ... (3)
-> + how to list distinct value? (5)
-> + Reading XML Files Across Netwo... (8)
-> + I want to automatically check ... (4)
-> + Parent tags (5)
-> + Remove Empty tags (2)
-> + dynamic function call | dynami... (3)
-> + Can I define a function like f... (3)
-> + remove empty tags (4)
-> + Loops (7)
-> + flat to XML with xQuery (4)
-> + Xquery for timer based events. (2)
-> + Cleaning up Word 2007 xml (3)
-> + Xquery string-pad function (5)
-> + DB to XML Data Source (2)
-> + XML Streaming not working (2)
-> + XQuery General Question (11)
-> + ERROR XQueryMediator Error dur... (2)
-> + Print Date in XML File (2)
-> + Aritmetic in Xquery (2)
-> + Use content of node as node na... (2)
-> + Better way to do this? (3)
-> + Get output line by line!! (2)
-> + Use of if-then-else (2)
-> + Manipulation of XQuery output!... (4)
-> + Subtract times (6)
-> + Using xQuery to call a Convers... (3)
-> + How to add a custom class to t... (3)
-> + How to get rid of multiple occ... (2)
-> + Problem with conditional JOINi... (8)
-> + XQuery editor whitin Stylus St... (3)
-> + Get rid of spaces in returned ... (4)
-> + Can XQuery be embeded in a Jav... (2)
-> + Need help on converting <br... (3)
-> + postgresql (3)
-> + No format-number functionsupp... (4)
-> + Swapping elements using XQuery... (2)
-> + Trying to contact DataDirect d... (3)
-> + External Java functions with b... (5)
-> + Looking for xQuery help (6)
-> + Built-in processor & filtered ... (2)
-> + Multiple Sibling Matches (2)
-> + Issue with data($element) (4)
-> + convert text to xml from more ... (2)
-> + xquery syntax (2)
-> + SQL Table To XML using XQuery (4)
-> + delimiting values of attribute... (3)
-> + empty child nodes (9)
-> + Illegal XML characters (4)
-> + Complete SQL Server database t... (34)
-> + Prevent xquery from converting... (8)
-> + Another edi question. (6)
-> + Running xquery with a source c... (4)
-> + xml to edi segment count quest (3)
-> + Running xquery from the comman... (7)
-> + How to change the node name in... (5)
-> + How to loop through a set of e... (10)
-> + Can I pass a parameter/vaiable... (3)
-> + generating an XML file (3)
-> + generating log files of Xquery... (2)
-> + Stylus Studio crashes when edi... (3)
-> + Checking for Values in an Arra... (3)
-> + Adding embedded functions (11)
-> + multiple DTPs at the same leve... (2)
-> + java.lang.OutOfMemoryError: Ja... (3)
-> + xml validation against wsdl (2)
-> + Using same Xquery (4)
-> + Changing name value pairs to t... (4)
-> + removing unwanted attributes r... (4)
-> + Repeated Crashing of System (2)
-> + Create multiple XML Files (5)
-> + Best xQuery engine? (2)
-> + Xquery outputs XML attributes ... (4)
-> + DataDirect SequeLink as a DB-t... (2)
-> + Using same xquery for 2 xml fi... (5)
-> + Performance of XQuery (2)
-> + fail to use Saxon Process for ... (4)
-> + Conditional statements in xque... (2)
-> + Option Declaration Using Saxon (2)
-> + Multiple option declarations (2)
-> + Importing modules with a Custo... (3)
-> + Possible bug: Problem with aut... (5)
-> + getting the value of an attrib... (4)
-> + Memory problems using xQuery (6)
-> + Adding a namespace (6)
-> + [DataDirect][XQuery][err:FODC0... (9)
-> + Mapping Trouble (4)
-> + Two level grouping (5)
-> + Error: A parameter of the oper... (3)
-> + Grouping in xQurey (Nested For... (7)
-> + err:XPST0005 - Error at line 9... (4)
-> + Error at line 1, column 126. U... (6)
-> + Strange output (2)
-> - word count for each category (1)
-> + Need help with this xquery (2)
-> + XML DOM (3)
-> + License issues related to XQue... (3)
-> + XQuery, ddtek:wscall, and an e... (9)
-> + How to give sub equation nos (3)
-> + XML DOM (3)
-> + forcing empty elements to have... (4)
-> + SQL Server 2005 XQuery help (4)
-> + Type error (5)
-> + MarkLogic queries (2)
-> + relative uri (3)
-> + Recursive Template Funcion Fro... (2)
-> - Create RDF for xml (1)
-> + Schema validation errors (2)
-> + KEYWORD EXTRACTION FROM XML DO... (6)
-> + Newbie struggling with nested ... (4)
-> + Path evaluation bug (?) concer... (2)
-> + XPath query (3)
-> + make sequence (4)
-> + XPath Query Editor Schema-Awar... (3)
-> + Newbe To This Form of programm... (2)
-> + Connection to remote database (2)
-> + Addnamespace using xquery (4)
-> + FATAL ERROR: Invalid document ... (3)
-> + FLOWR Loop Counter (5)
-> + Stylus Studio XML generation f... (2)
-> + Potential bugs? (2)
-> + hierarchical XML into tables (2)
-> + Incremental line counts (4)
-> + preceding-sibling syntax help ... (2)
-> + Creating hierarchical identifi... (5)
-> + Convert decimal to Hex. (3)
-> + XQuery automated comparison of... (3)
-> + validating schemas (2)
-> + very simple fn:string() proble... (5)
-> + Need help with a XSL file (2)
-> + Problems with conversion from ... (3)
-> + MS Sql Server (2)
-> + XQuery equivalent of xsl:resul... (2)
-> + tokenizing a string - problem ... (3)
-> + XQuery and eXist error process... (2)
-> + Deploying an xquery file with ... (2)
-> + Newbie struggling with simple ... (4)
-> + summing up the figure in the n... (8)
-> + Variable as part of a tag? (2)
-> + xquery element tag name (2)
-> + xquery - question for count fu... (3)
-> + get multiple values from multi... (4)
-> + Is it possible to add new data... (7)
-> + Can't connect to DB - MS SQL S... (16)
-> + sequence distinct values (4)
-> + XSQL QUERY (2)
-> + External xquery functions (2)
-> + Error in Xquery V3.0 (7)
-> + Problem getting distinct value... (2)
-> + XQuery reference book recommen... (2)
-> + it's possible to have a where ... (2)
-> + XSLT sorting parent nodes by m... (2)
-> + Catalyst EDI Mapping (2)
-> + h2 element is there but XQuery... (2)
-> + Adding the XML header to an ou... (2)
-> + Newbie question regarding dyna... (2)
-> + Group parent elements in targe... (5)
-> + Need XPath to return just imme... (4)
-> + XQUERY Java run-time error (4)
-> + dbxml and collection() (2)
-> + Nothing returned when namespac... (3)
-> + XQERY and Stylus Studio suppor... (3)
-> + x12 837 convert to xml fail wi... (3)
-> + Choose more than one attribute (2)
-> + XQuery Engine (4)
-> + finding nodes in source docume... (2)
-> + unable to create any xquery (3)
-> + counter in xquery (5)
-> + How to change JVM settings -Xm... (4)
-> + Postgresql (3)
-> + Can I call an xquery file from... (5)
-> + How to output a text with a mi... (3)
-> + Mapping - How Include the Sche... (6)
-> + XQuery beginner problem (2)
-> + No output from StylusFile Conv... (3)
-> + getting all nodes leading up t... (3)
-> + Java exception when apply regu... (5)
-> + X12 resources not reachable (T... (13)
-> + XQuery error on Oracle views (5)
-> + Results multiplied by number o... (3)
-> - Continous sequence check (1)
-> + No results for second row of s... (14)
-> + Problems connecting to DB2/400... (6)
-> + External Class : Invalid linki... (8)
-> + Error during SQL execution: [O... (2)
-> + Warnings when running Schema a... (2)
-> + XQuery basics (2)
-> + XPath Query Editor - not visib... (3)
-> + Document loading and unloading (3)
-> + Xpath to return xmlns (3)
-> + How to execute xQuery and exec... (3)
-> + Schema Aware Saxon (5)
-> + Want to execute a XQuery by AP... (7)
-> + Use a user-defined adapter as ... (2)
-> + RDB collections versus DB-to-X... (5)
-> + XMLTABLE WITH COLUMN OF ALL NO... (5)
-> + Xquery question (4)
-> - XQuery 1.0 is now a Proposed R... (1)
-> + I can't seem to get my xml "re... (7)
-> + Custom pipeline elements (4)
-> + FIND ALL ELEMENTS WITH SAME NA... (3)
-> - CONCATENATE COMPLEX TYPE ELEME... (1)
-> + XQuery & MySQL (4)
-> - Referring elements from an imp... (1)
-> + Selecting operator from XML to... (5)
-> + copy-namespaces mode (5)
-> + XQuery and Javascript 1.5+ on ... (2)
-> - XQuery sort & extract data (4)
-> ->XQuery sort & extract dat...
-> ->XQuery sort & extract dat...
-> ->Re: XQuery sort & extract...
-> + [DataDirect][XQuery]No value h... (9)
-> + About typing system for XQuery... (5)
-> + root() vs // - saxon and built... (3)
-> + XQuery or XPath "between" func... (4)
-> + Xpath Query Editor button grey... (3)
-> + Processing Instructions, Built... (4)
-> + XPath parser in Java (3)
-> + XQuery "declare xmlspace prese... (10)
-> + Save results of XQuery as CSV? (7)
-> + Cleanup and combine question (3)
-> + xquery function from within xs... (4)
-> + Saxon XQuery error (4)
-> + xquery and 1gb xml files (3)
-> + How can i output key words suc... (5)
-> + Viewing XQuery (4)
-> - Webinar: Using XQuery and Data... (1)
-> + Java code generated by Xquery ... (6)
-> + Multiple items in return (2)
-> + Confused using match (2)
-> + Counting distinct node types (7)
-> + XQUERY Newbie question (3)
-> + Receiving a function as a para... (7)
-> + Xpath Version - and Doc for Re... (2)
-> + Convert namespace? (2)
-> + Can I search for one line and ... (3)
-> + Reading Data from Soap Respons... (2)
-> + Access To XML Query Question (4)
-> + Xquery find avg and count (3)
-> + Bug using global variables in ... (3)
-> - Problem uploading XSLT to xml ... (1)
-> + Bug? HTMLTidy does not support... (2)
-> + Finding a string within an XML... (4)
-> + Store query result in java.lan... (2)
-> + Comparing databases and XML. (3)
-> + namespace information with XQu... (4)
-> + Single row to multiple row tra... (3)
-> + Webservice call failed (2)
-> + Stylus Studio has encountered ... (2)
-> + My XQUERY on Berkley DBXML s... (2)
-> + Filtering multiple values from... (5)
-> + SaxonB8.4 testing (8)
-> + Problem with oracle large tabl... (3)
-> + incorrect syntax? (3)
-> + XQUERY-based app usage (4)
-> + position() and last() in XQuer... (3)
-> + Returning Values (5)
-> + new to XQuery- "expected cardi... (2)
-> + using XQuery to keep all data ... (2)
-> + search in XQuery (6)
-> + Defined source and destination... (2)
-> + Stopping running xquery in R2 (4)
-> + XQuery where can i use it? (5)
-> + Scheduling the conversion (2)
-> + Converting Oracle table to XML... (5)
-> - Formating and Indentation Pres... (1)
-> + Omiting the XML declaration fr... (4)
-> + Define function (4)
-> + External Java class problems (15)
-> + C++/COM API for XQuery (3)
-> + PROBLEM AT THE DECLARATION OF ... (3)
-> - Cobol Flat file to XML (1)
-> + xpath question (2)
-> + XQST0059 cannot locate the req... (6)
-> + How to generate XML with proce... (2)
-> + ODBC Connection refused (12)
-> + node search and replace (3)
-> + generate xml file on web serve... (5)
-> + How to navigate to a ref node (5)
-> + How to query when a default na... (2)
-> + full xpath to a node (3)
-> + Performance bench (2)
-> + how to run xquery using java (2)
-> + [ convert dtd to xsd ] (3)
-> + How to map a recursive node? (9)
-> + java class implementing extern... (3)
-> + context to context reference (2)
-> + Problems with Replace (7)
-> + Use of special characters in X... (5)
-> + How to write XML Parser IN VC+... (2)
-> + Xquery (5)
-> + Trivial XQUERY application que... (2)
-> + XML as a data model (2)
-> + XQuery (2)
-> + Relative path (2)
-> + Support for xml is-idref (4)
-> + Accessing the document context... (3)
-> + Getting recursion return type ... (4)
-> + Parsing XMLFormatted as String... (5)
-> + XQuery Replace (2)
-> - How to join the two table usin... (1)
-> + Update variable value inside b... (5)
-> + Run XQuery on XMLDB databases (2)
-> + Treatment of reserved characte... (6)
-> + XQuery Core (6)
-> + Built-In Saxon 8.4 processor (3)
-> + dynamic order by clause (3)
-> + Dynamical xpath (3)
-> + How to use xquery? :) (2)
-> + Converting SQL query to XQuery (4)
-> - New XQuery Primer: Learn XQuer... (1)
-> - XQuery Co-Author and XML Indus... (1)
-> + sequence to collect (3)
-> + user defined functions in xque... (2)
-> + Need second set of eyes to deb... (2)
-> - Xquery calling Java function f... (1)
-> + Xquery on existing XML files i... (2)
-> + Need Help Resorting (11)
-> + "for" clause question (2)
-> + New XQuery Video: Using DataDi... (2)
-> + data() function not returning... (2)
-> + XSL-FO using RenderX's XEP on ... (4)
-> + Xquery to find sample data fil... (4)
-> + Xquery to find sample data fil... (4)
-> + Error with Berkeley XML DB and... (13)
-> + Berkeley XML DB & Professional... (3)
-> + question (2)
-> + Writing UDDI API's in XQuery (2)
-> - DataDirect XQuery Enables XQue... (1)
-> + Xquery to MS/SQL? (8)
-> + Left Outer Join in XQuery (2)
-> - New XQJ Tutorial and Example F... (1)
-> + asked (2)
-> - generate XML file from tables ... (1)
-> - XQuery interest growing: DevX (1)
-> + New to XQuery question (2)
-> - Help Support XQuery in the Mic... (1)
-> + Xquery and Web Service Caller (4)
-> + XQuery from JavaScript? (4)
-> + Find Maximum Numeric Value in ... (2)
-> + Can you use XQuery and SQL/XML... (2)
-> + XQuery and Relational Data map... (2)
-> + STyluus and C# (MS) (2)
-> - XQuery making headlines (again... (1)
-> + XQuery Syntax (2)
-> - XQuery in Outer Space (1)
-> + import several modules in a xq... (2)
-> - Developers Flock to XQuery Spe... (1)
-> + UPDATE (2)
-> + global variable (4)
-> + XQuery on all XML Files in a D... (12)
-> + Stylus Studio Interoperability... (5)
-> - Genereating values in a combob... (1)
-> - SQL Server 2005 "Yukon" (1)
-> - XQuery Drivers (1)
-> - Database Trends and Applicatio... (1)
-> - Why XQuery? How new XML Standa... (1)
-> - Develop, Edit and Debug XQuery... (1)
-> + Native XML Database Tools (3)
-> - XQuery in Bank Systems and Tec... (1)
-> + User functions (5)
-> + Setting Values for External Va... (4)
-> - XQuery 2005 Road Show (1)
-> - XQuery Introduction (1)
-> - New XQuery Developer Awards Pr... (1)
-> + Convert String to xml document... (2)
-> + import de modules (7)
-> + String to XML conversion in a ... (2)
-> + DML language (2)
-> + Newbie Xquery problem to solve (7)
-> - What is XQuery? (1)
-> - XQuery Talk: Priscilla Walmsle... (1)
-> + Learn XQJ : The XQuery API for... (3)
-> + XQuery to consolidate modular ... (6)
-> + problem with xquery (4)
-> + use cases (5)
-> - XQuery and XQJ Talk with Jason... (1)
-> + append the output of the xquer... (3)
-> + Problem with command line argu... (4)
-> - Can you associate hundreds of ... (1)
-> + PARAMETER VALUES IN STYLUS STU... (2)
-> + Problem with stylusxql calls (5)
-> - Join us for Eggs & XML at the ... (1)
-> + More about Java extensions and... (2)
-> + Stylus Studio Crashes with Jav... (6)
-> - An Interview with Jason Hunter... (1)
-> + attribute order in query resul... (3)
-> - Interview with XQuery Guru Dr.... (1)
-> + SequenceType matching failed" ... (2)
-> + XQuery tutorial (3)
-> - W3C Releases Public Working Dr... (1)
-> + Problem with a function (3)
-> + Problem with Stylus Studio 5.3 (5)
-> + Studio Studio crashes (7)
-> + STYLUSXQL (8)
-> + Execute a Query From the Comma... (2)
-> + Import Modules. (8)
-> + User-Defined Functions (3)
-> + new to Xquery (3)
-> + XQuery engines (4)
-> + APIs or OCXs (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
M KlineSubject: XQuery sort & extract data
Author: M Kline
Date: 25 Oct 2006 07:08 PM
Hello -
I'm new to XQuery but I was able to extract data from my existing XML document. The resulting XML is good, however because the Customer sends the XML with all <Value> elements, I'm not sure how to extract/pick...sorry for wrong terminology...only the elements that I want, then sort them because they're all <Value>.

I really only want the "Shipper's ID# for Shipment" value, the "Pay Item" value, the "Purchase Order Number" value, "Sellers Inv #" value, the "Invoice" value (which includes a date, quantity, piece price and part number), "Order Number" value, "Check Number" value, "Received" which is a date Value.....then sort that by the "Shipper ID Number".

Also, once I can get this done, can I somehow put this in a Word document so our Accounting Department can use it?

Here's an example of the resulting XQuery in hopes it makes more sense:

<xqr:xpath-query-result xmlns:xqr="http://www.stylusstudio.com/xpath-query-result">
<!-- Query Result: Element(s) -->
<Value Display="Remittance Information Only">I</Value>
<Value>60214.59</Value>
<Value Display="Credit">C</Value>
<Value Display="Automated Clearing House (ACH)">ACH</Value>
<Value Display="Vendor Payment">VEN</Value>
<Value Display="Current Transaction Trace Numbers">1</Value>
<Value>2006102053094</Value>
<Value Display="Transaction Creation" Function="UnknownItem">097</Value>
<Value>20061020</Value>
<Value>50039</Value>
<Value Display="Payer">PR</Value>
<Value>MYCUSTOMER</Value>
<Value Display="D-U-N-S Number, Dun &amp; Bradstreet">1</Value>
<Value>123456789</Value>
<Value Display="Accounts Payable Department">AP</Value>
<Value>ACCOUNTING PERSON</Value>
<Value Display="Telephone">TE</Value>
<Value>1-555-555-5555</Value>
<Value Display="Electronic Mail">EM</Value>
<Value>blahblahblah@customer.com</Value>
<Value>1</Value>
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
<Value>090838</Value>
<Value Display="Pay Item">PI</Value>
<Value>26.8</Value>
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
<Value>00300000</Value>
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
<Value>ERS Invoice37209</Value>
<Value Display="Invoice" Function="UnknownItem">003</Value>
<Value>20061019</Value>
<Value>2000</Value>
<Value>0.0134</Value>
<Value>0001072000</Value>
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
<Value>3725789</Value>
<Value Display="Check Number">CK</Value>
<Value>1166481</Value>
<Value Display="Received" Function="ReceivedDate">050</Value>
<Value>20061004</Value>
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
<Value>090838</Value>
<Value Display="Pay Item">PI</Value>
<Value>5</Value>
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
<Value>00300000</Value>
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
<Value>ERS Invoice37209</Value>
<Value Display="Invoice" Function="UnknownItem">003</Value>
<Value>20061019</Value>
<Value>1000</Value>
<Value>0.005</Value>
<Value>0001087000</Value>
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
<Value>3725789</Value>
<Value Display="Check Number">CK</Value>
<Value>1166481</Value>
<Value Display="Received" Function="ReceivedDate">050</Value>
<Value>20061004</Value>
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
<Value>090835</Value>
<Value Display="Pay Item">PI</Value>
<Value>132</Value>
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
<Value>00300000</Value>
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
<Value>ERS Invoice37209</Value>
<Value Display="Invoice" Function="UnknownItem">003</Value>
<Value>20061019</Value>
<Value>500</Value>
<Value>0.264</Value>
<Value>0001134000</Value>
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
<Value>3725786</Value>
<Value Display="Check Number">CK</Value>
<Value>1166481</Value>
<Value Display="Received" Function="ReceivedDate">050</Value>
<Value>20061004</Value>
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
<Value>090835</Value>
<Value Display="Pay Item">PI</Value>
<Value>73.32</Value>
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
<Value>00300000</Value>
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
<Value>ERS Invoice37209</Value>
<Value Display="Invoice" Function="UnknownItem">003</Value>
<Value>20061019</Value>
<Value>50</Value>
<Value>1.4664</Value>
<Value>0001140000</Value>
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
<Value>3725786</Value>
<Value Display="Check Number">CK</Value>
<Value>1166481</Value>
<Value Display="Received" Function="ReceivedDate">050</Value>
<Value>20061004</Value>
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
<Value>090833</Value>
<Value Display="Pay Item">PI</Value>
<Value>6.57</Value>
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
<Value>00300000</Value>
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
<Value>ERS Invoice37209</Value>
<Value Display="Invoice" Function="UnknownItem">003</Value>
<Value>20061019</Value>
<Value>140</Value>
<Value>0.0469</Value>
<Value>0003035000</Value>
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
<Value>3725784</Value>
<Value Display="Check Number">CK</Value>
<Value>1166481</Value>
<Value Display="Received" Function="ReceivedDate">050</Value>
<Value>20061004</Value>
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
<Value>090833</Value>
..........then repeats with the next Shipper ID Number information, etc. until the end of the XML

Thanks much!

Mary
Postnext
Ivan PedruzziSubject: XQuery sort & extract data
Author: Ivan Pedruzzi
Date: 25 Oct 2006 10:46 PM
Hi Mary,

Could you post a sample of your input document?


Ivan Pedruzzi
Stylus Studio Team
http://www.stylusstudio.com/xml_download.html

Postnext
M KlineSubject: XQuery sort & extract data
Author: M Kline
Date: 26 Oct 2006 05:55 AM
Sure thing. It's a huge file, so I've copied and pasted some of it here.
Thank You.

<?xml version="1.0"?>
<!DOCTYPE FormData [
]>
<FormData DocType="Remittance Advice" Name="Generic Remittance Advice" SenderID="XXXX" ReceiverID="XXX" Version="1.0" TestProd="Test" SupplierID="Ixxxxxx" PartnerID="XXXXXXXXXXX" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="file:///c:/Documents%20and%20Settings/mkline/Desktop/StylusStryker820.xsd">
<Form Name="RMMain">
<Item Name="TransHandlingCode">
<Value Display="Remittance Information Only">I</Value>
</Item>
<Item Name="Amount">
<Value>60214.59</Value>
</Item>
<Item Name="CreditDebitFlag">
<Value Display="Credit">C</Value>
</Item>
<Item Name="PaymentMethodCode">
<Value Display="Automated Clearing House (ACH)">ACH</Value>
</Item>
<Item Name="BusinessFunctionCode">
<Value Display="Vendor Payment">VEN</Value>
</Item>
<Item Name="TraceCode">
<Value Display="Current Transaction Trace Numbers">1</Value>
</Item>
<Item Name="RMNum" Info2="1">
<Value>xxxxxxxxxxxx</Value>
</Item>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Transaction Creation" Function="UnknownItem">097</Value>
</Item>
<Item Name="Date">
<Value>20061020</Value>
</Item>
<Item Name="Time">
<Value>50039</Value>
</Item>
</Group>
</Form>
<Form Name="NameAddressDetail">
<Item Name="Type" NadType="PR">
<Value Display="Payer">PR</Value>
</Item>
<Item Name="Name" NadName="PR">
<Value>CUSTOMER NAME</Value>
</Item>
<Item Name="Qualifier" NadQual="PR">
<Value Display="D-U-N-S Number, Dun &amp; Bradstreet">1</Value>
</Item>
<Item Name="Code" NadCode="PR">
<Value>XXXXXXXXX</Value>
</Item>
<Form Name="ContactDetail">
<Group>
<Item Name="Type">
<Value Display="Accounts Payable Department">AP</Value>
</Item>
<Item Name="Name" NadContactName="PR">
<Value>XXXX XXXX</Value>
</Item>
<Item Name="CommType">
<Value Display="Telephone">TE</Value>
</Item>
<Item Name="CommNum">
<Value>1-555-555-5555</Value>
</Item>
<Item Name="CommType2">
<Value Display="Electronic Mail">EM</Value>
</Item>
<Item Name="CommNum2">
<Value>XXXX.XXXXXX@XXXXXXX.com</Value>
</Item>
</Group>
</Form>
</Form>
<Form Name="EntityDetail">
<Item Name="AssignedNum">
<Value>1</Value>
</Item>
<Form Name="RMItemDetail">
<Item Name="RefIDQual">
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
</Item>
<Item Name="RefID">
<Value>090838</Value>
</Item>
<Item Name="PaymentActionCode">
<Value Display="Pay Item">PI</Value>
</Item>
<Item Name="PaymentAmount">
<Value>26.8</Value>
</Item>
<Form Name="ReferenceNums">
<Group>
<Item Name="Qualifier">
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
</Item>
<Item Name="Number">
<Value>00300000</Value>
</Item>
</Group>
<Group>
<Item Name="Qualifier">
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
</Item>
<Item Name="Number">
<Value>ERS Invoice37209</Value>
</Item>
</Group>
</Form>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Invoice" Function="UnknownItem">003</Value>
</Item>
<Item Name="Date">
<Value>20061019</Value>
</Item>
</Group>
</Form>
<Form Name="ItemDetail">
<Item Name="Quantity">
<Value>2000</Value>
</Item>
<Item Name="UnitPrice">
<Value>0.0134</Value>
</Item>
<Item Name="BuyerPartNum" PxrTheirPartNumber="1">
<Value>0001072000</Value>
</Item>
<Form Name="ReferenceDetail">
<Item Name="Qualifier">
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
</Item>
<Item Name="Number">
<Value>3725789</Value>
</Item>
<Item Name="Qualifier2">
<Value Display="Check Number">CK</Value>
</Item>
<Item Name="Number2">
<Value>1166481</Value>
</Item>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Received" Function="ReceivedDate">050</Value>
</Item>
<Item Name="Date">
<Value>20061004</Value>
</Item>
</Group>
</Form>
</Form>
</Form>
</Form>
<Form Name="RMItemDetail">
<Item Name="RefIDQual">
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
</Item>
<Item Name="RefID">
<Value>090838</Value>
</Item>
<Item Name="PaymentActionCode">
<Value Display="Pay Item">PI</Value>
</Item>
<Item Name="PaymentAmount">
<Value>5</Value>
</Item>
<Form Name="ReferenceNums">
<Group>
<Item Name="Qualifier">
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
</Item>
<Item Name="Number">
<Value>00300000</Value>
</Item>
</Group>
<Group>
<Item Name="Qualifier">
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
</Item>
<Item Name="Number">
<Value>ERS Invoice37209</Value>
</Item>
</Group>
</Form>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Invoice" Function="UnknownItem">003</Value>
</Item>
<Item Name="Date">
<Value>20061019</Value>
</Item>
</Group>
</Form>
<Form Name="ItemDetail">
<Item Name="Quantity">
<Value>1000</Value>
</Item>
<Item Name="UnitPrice">
<Value>0.005</Value>
</Item>
<Item Name="BuyerPartNum" PxrTheirPartNumber="1">
<Value>0001087000</Value>
</Item>
<Form Name="ReferenceDetail">
<Item Name="Qualifier">
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
</Item>
<Item Name="Number">
<Value>3725789</Value>
</Item>
<Item Name="Qualifier2">
<Value Display="Check Number">CK</Value>
</Item>
<Item Name="Number2">
<Value>1166481</Value>
</Item>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Received" Function="ReceivedDate">050</Value>
</Item>
<Item Name="Date">
<Value>20061004</Value>
</Item>
</Group>
</Form>
</Form>
</Form>
</Form>
<Form Name="RMItemDetail">
<Item Name="RefIDQual">
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
</Item>
<Item Name="RefID">
<Value>090835</Value>
</Item>
<Item Name="PaymentActionCode">
<Value Display="Pay Item">PI</Value>
</Item>
<Item Name="PaymentAmount">
<Value>132</Value>
</Item>
<Form Name="ReferenceNums">
<Group>
<Item Name="Qualifier">
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
</Item>
<Item Name="Number">
<Value>00300000</Value>
</Item>
</Group>
<Group>
<Item Name="Qualifier">
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
</Item>
<Item Name="Number">
<Value>ERS Invoice37209</Value>
</Item>
</Group>
</Form>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Invoice" Function="UnknownItem">003</Value>
</Item>
<Item Name="Date">
<Value>20061019</Value>
</Item>
</Group>
</Form>
<Form Name="ItemDetail">
<Item Name="Quantity">
<Value>500</Value>
</Item>
<Item Name="UnitPrice">
<Value>0.264</Value>
</Item>
<Item Name="BuyerPartNum" PxrTheirPartNumber="1">
<Value>0001134000</Value>
</Item>
<Form Name="ReferenceDetail">
<Item Name="Qualifier">
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
</Item>
<Item Name="Number">
<Value>3725786</Value>
</Item>
<Item Name="Qualifier2">
<Value Display="Check Number">CK</Value>
</Item>
<Item Name="Number2">
<Value>1166481</Value>
</Item>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Received" Function="ReceivedDate">050</Value>
</Item>
<Item Name="Date">
<Value>20061004</Value>
</Item>
</Group>
</Form>
</Form>
</Form>
</Form>
<Form Name="RMItemDetail">
<Item Name="RefIDQual">
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
</Item>
<Item Name="RefID">
<Value>090835</Value>
</Item>
<Item Name="PaymentActionCode">
<Value Display="Pay Item">PI</Value>
</Item>
<Item Name="PaymentAmount">
<Value>73.32</Value>
</Item>
<Form Name="ReferenceNums">
<Group>
<Item Name="Qualifier">
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
</Item>
<Item Name="Number">
<Value>00300000</Value>
</Item>
</Group>
<Group>
<Item Name="Qualifier">
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
</Item>
<Item Name="Number">
<Value>ERS Invoice37209</Value>
</Item>
</Group>
</Form>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Invoice" Function="UnknownItem">003</Value>
</Item>
<Item Name="Date">
<Value>20061019</Value>
</Item>
</Group>
</Form>
<Form Name="ItemDetail">
<Item Name="Quantity">
<Value>50</Value>
</Item>
<Item Name="UnitPrice">
<Value>1.4664</Value>
</Item>
<Item Name="BuyerPartNum" PxrTheirPartNumber="1">
<Value>0001140000</Value>
</Item>
<Form Name="ReferenceDetail">
<Item Name="Qualifier">
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
</Item>
<Item Name="Number">
<Value>3725786</Value>
</Item>
<Item Name="Qualifier2">
<Value Display="Check Number">CK</Value>
</Item>
<Item Name="Number2">
<Value>1166481</Value>
</Item>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Received" Function="ReceivedDate">050</Value>
</Item>
<Item Name="Date">
<Value>20061004</Value>
</Item>
</Group>
</Form>
</Form>
</Form>
</Form>
<Form Name="RMItemDetail">
<Item Name="RefIDQual">
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
</Item>
<Item Name="RefID">
<Value>090833</Value>
</Item>
<Item Name="PaymentActionCode">
<Value Display="Pay Item">PI</Value>
</Item>
<Item Name="PaymentAmount">
<Value>6.57</Value>
</Item>
<Form Name="ReferenceNums">
<Group>
<Item Name="Qualifier">
<Value Display="Purchase Order Number" Function="PONum">PO</Value>
</Item>
<Item Name="Number">
<Value>00300000</Value>
</Item>
</Group>
<Group>
<Item Name="Qualifier">
<Value Display="Seller's Invoice Number" Function="UnknownItem">IV</Value>
</Item>
<Item Name="Number">
<Value>ERS Invoice37209</Value>
</Item>
</Group>
</Form>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Invoice" Function="UnknownItem">003</Value>
</Item>
<Item Name="Date">
<Value>20061019</Value>
</Item>
</Group>
</Form>
<Form Name="ItemDetail">
<Item Name="Quantity">
<Value>140</Value>
</Item>
<Item Name="UnitPrice">
<Value>0.0469</Value>
</Item>
<Item Name="BuyerPartNum" PxrTheirPartNumber="1">
<Value>0003035000</Value>
</Item>
<Form Name="ReferenceDetail">
<Item Name="Qualifier">
<Value Display="Order Number" Function="UnknownItem">OQ</Value>
</Item>
<Item Name="Number">
<Value>3725784</Value>
</Item>
<Item Name="Qualifier2">
<Value Display="Check Number">CK</Value>
</Item>
<Item Name="Number2">
<Value>1166481</Value>
</Item>
<Form Name="DateTime">
<Group>
<Item Name="Qualifier">
<Value Display="Received" Function="ReceivedDate">050</Value>
</Item>
<Item Name="Date">
<Value>20061004</Value>
</Item>
</Group>
</Form>
</Form>
</Form>
</Form>
<Form Name="RMItemDetail">
<Item Name="RefIDQual">
<Value Display="Shipper's Identifying Number for Shipmen">SI</Value>
</Item>
<Item Name="RefID">
<Value>090833</Value>
</Item>
<Item Name="PaymentActionCode">
<Value Display="Pay Item">PI</Value>
</Item>

Posttop
M KlineSubject: Re: XQuery sort & extract data
Author: M Kline
Date: 26 Oct 2006 08:32 PM

Hi Ivan

Here's the attachment.

Thanks much!

Mary

(See attached file: 820Copy.xml)


|---------+--------------------------------------------------->
| | "stylus-studio-xquery Listmanager" |
| | <stylus-studio-xquery.listmanager@stylus|
| | studio.com> |
| | |
| | 10/25/2006 10:49 PM |
| | Please respond to "XQuery Help and |
| | Discussion" |
|---------+--------------------------------------------------->
>---------------------------------------------------------------------------------------------------------------------------------------------|
| |
| To: (Recipients of 'stylus-studio-xquery' suppressed) |
| cc: |
| Subject: XQuery sort & extract data |
>---------------------------------------------------------------------------------------------------------------------------------------------|




From: Ivan Pedruzzi

Hi Mary,

Could you post a sample of your input document?


Ivan Pedruzzi
Stylus Studio Team
http://www.stylusstudio.com/xml_download.html


--
To reply:stylus-studio-xquery.17322@stylusstudio.com
To start a new topic:stylus-studio-xquery@stylusstudio.com
To login:http://www.stylusstudio.com/SSDN/
To (un)subscribe:stylus-studio-xquery.list-request@stylusstudio.com



Unknown820Copy.xml
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.