nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I tell which parameter is which?

mkdz

When I edit my dataset, I have a query with a few parameters: 
 
<img src='http://i.imgur.com/z4YCoF0.png' alt='Posted Image' class='bbc_img' /> 
 
When i go to the Parameters screen, I get this: 
 
<img src='http://i.imgur.com/Lk1hqCE.png' alt='Posted Image' class='bbc_img' /> 
 
How do I know which parameter is which?

Find more posts tagged with

Comments

CBR

The list is sorted by the location of the ? in your query. You have 7 question marks, so you have 7 entries. First entry is first question mark, second is second and so on.

mkdz

<blockquote class='ipsBlockquote' data-author="'cbrell'" data-cid="114204" data-time="1360856466" data-date="14 February 2013 - 08:41 AM">
The list is sorted by the location of the ? in your query. You have 7 question marks, so you have 7 entries. First entry is first question mark, second is second and so on. </blockquote>
 
****, that can get to be a pain as I add and remove parameters. <_< 
 
Thanks!

CBR

Yes you got it. It is a real pain when adding and removing parameters. To be sure that everything is correct you would need to check the parameters tab every time you change your query. Unfortunately that is the only mechanism provided to add parameters to your query (no named parameters possible)

mkdz

Yea, it's sort of frustrating. All my parameter names get changed and reset every time I add or remove a parameter. Are named parameters a planned feature?

Hans_vd

On a project I worked on we created the habit of starting every query in every report with a SQL WITH clause. Especially when you are using the same report parameters in different places in your data set's query this is really useful.

It is explained in this blogpost:
http://enterprisesmartapps.wordpress.com/2011/01/10/re-using-parameters-in-birt-data-set/

Regards
Hans

mkdz

Awesome, thanks!

CBR

oh i remember that. This is indeed a very cool SQL feature that can be used to work around the missing named parameters.

Thanks Hans for bringing it back to my attention (i read your blog post some month ago about that topic but forgot it in the meantime)

@mkdz:
As far as i know named parameters are not a planned feature in BIRT. I heared a lot of people yelling about that since years (the problem already exists since the first version of BIRT). I think it would make sense to search for an issue in the bug tracker (bugs.eclipse.org) and eventually vote for the feature.