Re: Query Builder use

Patrick Halstead — Mon, 11 Jan 2010 16:42:29 GMT

Hi Chaula,

You know, you could use DBXL to map your XML to tables and then use QueryDB to filter it using the conditions you listed. It should work fine. Probably an hour to setup.

Thanks!

Re: Query Builder use

ErnestoM — Mon, 04 Jan 2010 19:05:37 GMT

Hi Chaula,

Unfortunately, QueryDB does not support anything like this (it will not parse the xml within a column).

For a video demo on QueryDB, click here.

Query Builder use

cganatra@asite.com — Mon, 04 Jan 2010 15:05:42 GMT

Hello,

I would like to explain our requirement. In our SQL Server, we have a table which has few columns , one of the column stores XML data.

The XML structures also varies.

e.g.

other XML structure may be

1) if user wants to query the data which has temp of grade >=2 OR support=multi, then it returns appropriate data.

Also user needs returned fields to be varied, he may only need lang or he only needs grade.

2) If user wants to query the data which has class of stu <= 300 AND country <> "PAK" then it should return appropriate data.

Also user needs returned fields to be varied, he may only need stu ,country and rank.

Is this possible using WSPP Query Builder or any other Tool ? Please suggest.

Note :: data is XML string which is stored in varchar column.

Thanks and Regards,

Chaula

Qdabra Database Accelerator

Re: Query Builder use

Re: Query Builder use

Query Builder use