Kx Dashboard and TorQ Gateway connection

[JerLucid]

Hi team,

Can you please provide me with the steps required to allow the

TorQ Gateway to work with KxDashboards?

Currently my Dashboards are connecting to a relay process, which routes the query to the Gateway, as I saw this recommended in a previous post, but I'd like

to move over to a direct connection if possible. 

I see there is a file called kxdash.q in the code/gateway folder, with 

an enabled flag at the top, should it simple be a matter of

setting .kxdash.enabled to 1b? 

Many Thanks

[JerLucid]

Just following up on this one. Can someone provide steps to enable TorQ Gateway to work with Kx Dashboards please?

Many Thanks

[Sophie Loca]

Hi JerLucid,

Thanks for following up on this. We are working on resolving this issue and will be in touch with any updates.

Best,

Sophie

[Sophie Loca]

Hi JerLucid,

If you make the below changes to the code you should be able to directly query the gateway:

/TorQ/code/gateway/kxdash.q

enabled:@[value;`enabled;{1b}];, 

 and 

.z.ps: .kxdash.dashps  /For now we had to revert this to the previous version

/TorQ/config/settings/gateway.q

\d .kxdash

enabled:1b  

Here are some example queries that worked for us:

.kxdash.dashexec["select from trade";`rdb;raze]

.kxdash.dashexec["select sum size by sym from trade";`rdb`hdb;{sum x}]

{[s] .kxdash.dashexec[({select from trade where sym in x};s);`rdb`hdb;raze]}[`MSFT] /Parameterised version

Please let me know if this works for you okay.

Best,

Sophie

[Jeremy Lucid]

Excellent, thanks Sophie, I appreciate the examples you provided too 

--
dataintellect.com
dataintellect.com/thoughts
---
You received this message because you are subscribed to a topic in the Google Groups "Data Intellect kdb+/TorQ" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/kdbtorq/FDkCUoQA7XE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to kdbtorq+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/kdbtorq/ccbf19ae-454e-4cf0-8174-54a19db578f2n%40googlegroups.com.