rlothai
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by rlothai
-
-
Hello,
I want to use the JsonDataSource in our bank project and have begun experimenting with it in iReport, with some success. Does anyone know if there is a third-party parsing engine being used or is this home grown? I could not glean the answer from a short look at the code. I need to locate a more or less complete reference for the query syntax, as I will be doing complex logic for some fields.
I can so far grab values from within my own JSON string using syntax like: sections[0].fields[0].value in my fielddescriptions. I really need to be able to look for specific values of the keys for objects in an array, but cannot figure out what that syntax should look like. Later I will also need to show or hide fields based on boolean values stored with the fields (are functions available, and how?).
I downloaded and got the JSON example working with the queryString syntax in the orders report: Northwind.Orders(CustomerID == $P{CustomerID} and was hoping to use something similar. So far I can't get the queryString to work with a similar lookup in my own json, and the == does not seem to work in fields either (not sure they are supposed to in fields, as not only can I not find documentation but I am also new to Jasper).
While I can give you example JSON and have you solve the problem, what I would prefer is a link to some decent documentation I can digest and use myself.
Thanks in advance and looking forward
json parsing engine and query syntax for JsonDataSource
in Products
Posted
Hello, this is a bump with a more specific question. Assuming an object array with an embedded object array, like this:
"sections": [{
I have succeeded in getting a query like this to work: