Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
edit dataset unable to acces to the lower part of SQL window
Lucquy
<p>Hello,</p>
<p> </p>
<p>I am an occasional user and in the edit dataset "build a sql select query" window, I can't access to the colomns of the lower part "Column", "Alias", "Output", Sort type" and "Sort order".</p>
<p> </p>
<p>I can set them by using the SQL text but it is less user friendly.</p>
<p> </p>
<p>I use Birt 4.5.0 in Eclipse Mars with Ubuntu 14.04.</p>
<p> </p>
<p>Thanks</p>
<p> </p>
Find more posts tagged with
Comments
jfranken
<p>Could you please post a screenshot?</p>
Lucquy
<p>Here it is</p>
<p> </p>
<p><a class="bbc_url" href="
http://pix.toile-libre.org/?img=1454576955.png"><img
src="
http://pix.toile-libre.org/upload/img/1454576955.png"
; alt="1454576955.png"></a></p>
<p> </p>
<p>Thanks for your help</p>
jfranken
<p>Click to check the checkboxes next to the column names in the table in the middle section. The columns should be added to the bottom list and you should be able to scroll to them. If you've already tried this, there might be a setting in Window => Preferences to increase the number of columns displayed. I'm not sure if the display can be changed.</p>
Lucquy
<p>Taht is OK, if I click on the check boxe the column is added or disappear if I deselect it.</p>
<p>But the problem is I can't access to the rows in the lower part (this one I surraouded on the screen shot) to, for exemple, modify the alias, sort type or the sort order etc...</p>
<p> </p>
<p>I can do what I want by the SQL, or other screens like outuput columns, filters etc.. But I can't do directly on the edit dataset-->SQL select query.</p>
<p> </p>
<p>I have searched in the preferences but i did not found any relative item.</p>
<p>Thange of behavior came when I have updated from kepler to Mars.</p>
<p> </p>
<p>Excuse my spelling but I am french .....</p>