Jaspersoft Studio JsonQL subdatasource shows too many rows

Changed Severity from Minor to Critical

---

System Message

Changed Resolution from Open to Works as Designed

Changed Status from New to Feedback Requested

Changed Assigned User from - to @narcism

---

Hi,In essence, what you describe is expected.The ..* query will pick up anything starting from the JSON key that it is applied on, meaning that it will produce arrays of nodes.And each node in that array could be: also an array, an object or a plain value. So in your case it first picks up the arrays containing your desired objects and then those objects. You need to either apply filters to your query - something like: ..*(@isObject) - or redesign you query to land on the desired keys and then go back up a level.Maybe the sample documentation here(https://jasperreports.sourceforge.net/sample.reference/jsonqldatasource/index.html#jsonql) could be of use.Hope this helps,Narcis

Thanks the (@isObject) is the solution for it. Have a good weekend!

Changed Status from Feedback Requested to Closed

---