alba.ortega Posted March 4, 2015 Share Posted March 4, 2015 Hi all, I hope you can help me. Let me explain this bug as well as I can: 1)I have a report sorted by parameters, the primary is the "Owner", the table looks like: As you can see, there's a "Pool" owner, this owner comes because this condition in Text Field:IF($F{_id.Owner}==null,"Pool",$F{_id.Owner})2)Clicking any value, they will pass to another report, with some parameters associated to each "Ticket (Creation date, due date, name of owner, description...) This report works perfectly except when I try to drilldown this "Pool" Owner, when I drilldown it, the reports with details is returning all the repository, I mean, all the "tickets" associated to any owner, and what I want to see is all the "unassigned tickets", which could have the owner name as empty or null or white space...I have a condition in the Dataset Table report parameter like: ($P{Owner}==null || $P{Owner}.equals(""))?new String(""): ""OpnPrps.CurAgtNme":""+$P{Owner}+"","I'm thinking that maybe the problem is the initial condition $P{Owner}==null || $P{Owner}.equals(""), and this equals("") is not getting correctly all the values but I'm not sure. Thanks & kind regards.AlbaO. Link to comment Share on other sites More sharing options...
AnnMary.Thomas Posted March 5, 2015 Share Posted March 5, 2015 can you please elaborate the question. It is not clear. Link to comment Share on other sites More sharing options...
alba.ortega Posted March 5, 2015 Author Share Posted March 5, 2015 Hi! Ok, I will try....I have the table from Image 1, And when I click in "Pool" value, itdrilldown many details in other table, this drilldown is sorted by this Owner, however, when Pool (Pool means all the null/empty values), the reports is being sorted by any data (all the inventory) but I want to sort them with Owner == null. Link to comment Share on other sites More sharing options...
james.t Posted March 5, 2015 Share Posted March 5, 2015 In SQL this should be$P{owner} IS NULL Link to comment Share on other sites More sharing options...
alba.ortega Posted March 9, 2015 Author Share Posted March 9, 2015 Thank you, however,I'm using MongoDB, and also is not quite easy, I mean, I need to find a way to configure a conditional param in the subquery of my details in order to get the values I'm searching. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now