Solved

XMLExists with Multiple Value Parameter

Posted on 2014-11-14
4
61 Views
Last Modified: 2015-02-19
I am pulling data from a XML field in an Oracle database for use in a Crystal Report.  Currently, I'm using XMLExists with a parameter which works fine (below).  The problem is only one parameter value can be entered for each report.  Is there a way to query an XML field with a multiple value parameter?

      xmlexists('declare default element namespace "http://somenamespace.com/common/xsd"; (: :)
             /Person[Id={?ID}]' passing xmlfield)

Thanks!
0
Comment
Question by:SBsUserName
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40442586
I suspect not.  It will depend on whether you can change the = {?ID} to IN {?ID}.

mlmcc
0
 

Author Comment

by:SBsUserName
ID: 40443594
"In" wouldn't work.  Thanks though.
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question