You
can run queries over the XOG client; there was a subtle trick to it though - you had to be running the XOG client in the "right" way; offhand I can't recall the trick (it might just have been running it via xog.bat instead of run.bat :unsure: or "how" you are running your PC based XOG client???) but I will dig it out of my documentation next week for you.
As Kathy implies; its all just the web-services stuff really, but using the "Query API" instead of the "Object API"
--
EDIT : OK here is how I can do it;
I've created a query in studio called "simple_query" (it just contains the default NSQL that Clarity puts in when you create a query)
I have a properties file for my DEV environment called "Q_DEV.properties";:
# server host name you want to test against
servername=***.***.***.***
portnumber=yyyy
#set to true if running against a SSL enabled server
sslenabled=false
output=outputQDEV.xml
username=AAAAAA
password=BBBBBB
input=../xml/QUERY_RUN.xml
(obviously I've obscured my server and user details!)
then I use the following XML in a file called "QUERY_RUN.xml";
<?xml version="1.0" encoding="UTF-8"?>
<Query xmlns="http://www.niku.com/xog/Query">
<Code>simple_query</Code>
</Query>
(the difference here between my XML and yours is that I just don't have all the NikuDataBus stuff?)
And finally this is my "BAT" file that I use to run XOG;
@echo off
PATH="C:\Program Files\Java\jre1.5.0_12\bin"
JAVA_HOME=C:\Program Files\Java\jre1.5.0_12\bin
if exist outputQDEV.xml erase outputQDEV.xml
call xog -propertyfile QDEV.properties
@echo
pause
I think the important bit here is that I am using "call xog" rather than "call run"?
--
So when I run my BAT file, I just get an "outputQDEV.xml" that contains the output of the NSQL statement.
?