Query not working in webApp

[Heku_]

Hello everyone, I've been trying to query the service table via Javascript, but i don't get any records.

I've tried lots of querys and giving admin access to the webApp user, but nothing appears in the debugging page

Any solution? Thank you in advance

[AkshayAnand]

Hi @Heku_ 

In the <select> tag you aren't defining any <node> to select for the querydef. You can try giving nodes inside the select to get the results. Nodes are the parameters you want to query/get using the querydef function.

Example:- 

Hope this helps.

Regards

Akshay

[Heku_]

No, SelectAll adds all fields on the select part, so node isn't needed. I've tried it anyway but it didn't work...

[AkshayAnand]

Hi @Heku_ 

Also your logs will not be visible in the debug mode, you can see your logs under Home>>Monitoring >> web@default >> Open log journal . There you can sort based on the dates and you will be able to see your lgs for webapps.

Regards

Akshay

[Heku_]

Error can be seen in debug mode 

[AkshayAnand]

Hi @Heku_ 

Could you please parsing the XML object to string using "toString()" funtion and then try to log Error and let me know if this works.

Regards

Akshay

[Heku_]

Same result as logError(result), empty error...

[Marcel_Szimonisz · Accepted solution]

Hello @Heku_ ,

i have never used select all tbh. You can print result with JSON.Stringify(). Can you skip that selectAll?. Have you tried something like:

var res = query.ExecuteQuery();
var services= res.getElementsByTagName("service");

logInfo(services.length);
logInfo(JSON.Stringify(services));

 Do you have admin rights? Have you run the web app in admin mode? You can escalate admin rights for the query when you do not want to give admin rights to web app user.

Marcel Szimonisz

[Sukrity_Wadhwa]

Hi @Heku_.,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!