andey.wei

I want to accomplish something of this nature <filterExpression>jaspersoft_user is "CURRENT_JASPERSOFT_USERNAME"</filterExpression>[/code]How do I use the current logged in Jaspersoft username in my filter expression?

The problem was putting jaspersoft behind a nginx proxy. Nginx doesn't forward underscored headers. Therefore, I renmaed the CSRF tokens and it worked fine.

As you can see i'm logged in as superuser. And I have superuser roles assigned Ok let's create the user Nothing Happens? I can't edit, or modify exsisting users. What the problem? How do i fix this?

I would like to check the parameter, but I'm not sure how. I tried "CASE WHEN ($P{site_id_1} = NULL)", but it always will fail that check.

I have two inputs. "Sites" & "Controllers". Controllers are the children of Sites. "Controllers" Custom Input Query select id, name from controllers where $X{IN, site_id, site_id_1}[/code]When site_id_1 has nothing selected I expect: the return set to be empty I get: all the controllers in the DB Question: How do I make the query return no results when site_id_1 has no options selected? What I've tried: select id, name from controllers where (case when ($P{site_id_1} = null) then id = 0 else $X{IN, site_id, site_id_1} end)[/code]However I don't know the data type of $P{site_id_1}, thus I don't know how to write an expression to test if the parameter is empty. Thanks in Advance!

Thanks once again marianol, option #2 worked like a charm

Exactly: http://community.bitnami.com/t/crash-after-deleting-anonymoususer-on-jasperreports/22967 And: http://community.jaspersoft.com/questions/821774/i-deleted-included-users-create-my-own-organization-now-i-get-internal-server-error Neither of these two questions have an answer. What am I expected to do? Just launch a new instance? (Just a suggestion: If the anonymousUser is essential, then I shouldn't be able to delete it from the UI)

FYI for anyone reading this: currently new AWS jasperserver-5.5 install use /etc/init.d/tomcat7

WOW thank you Marianol for your help. I was able to delete your custom input, and then recreate it. But, I'm missing one last key. Where do I figure out the filter ID. Where do I figure out that the filter id was "billing_address_state_1". When I look at the schema of the data set you provided, it was just "billing_address_state". Can I assume that "_1" will be appended to every filter created from the adhoc view?

i know jaspersoft creates basic filters like user_id automatically. However, that wasn't why I was asking the question. I was just trying to provide a simple example on how I would proceed when using a custom input. What I'm actually trying to do involves a couple cascading inputs, and a dataset with many joins.

Thank you, I never actually realized I could create a query from the Edit --> Reports, because it was greyscaled. I guess that was me just being dumb. However I'm still having an issue with the query, when I create the query, I get this error: ".... JRRuntimeException: Parameter "Select_The_User_Id" does not exist.". Isn't that what i called the input, in the above example?

Problem When I create a custom input, I cannot figure out how to make it turn the results I want. Simplified Senario Simple Report from a Simple adhoc view, from a simple domain, from a generic mysql data sourceReport Edit --> Controls & Resources --> Add Input ControlDefine an Input Control in the next stepDefine a Query in the next stepName the Query: 'Select_The_User_Id_Query'Link a Data Source to the Query: 'selected the mysql data source'Done! Now lets look at how the report looks like The input looks good. Question: How do I make the custom report filter results to only display user_id = 44 ? Thanks in Advance EDIT: Progress MadeCreating a custom report query was right in front of my face select * from user_sites where user_id = $P{Select_The_User_Id}[/code]Report --> Edit --> Query"Click here to create a new query"Name the Query: 'Whatever_query"Link to data source: " select my database"Definee the query. This is what I don't understand. The second cascading input I created has a query like "select * from users where id = $P{Select_The_User_Id}", which works. But the report "Query" claims that the parameter doesn't exisit. Why is that?

1. As far as I'm aware I should be able to with a commerial license? 2. From the basic tutorials I've read, there should be a "manage organizations" 3. I'm logged in as "superuser", I just ordered the instance a yesteday

Under "Manage" there isn't an opttion for "Organization". I just purchased jaspersoft AWS instance