By choosing a field and
clicking on the arrows <<, this field name is copied at the current cursor position in
the query box. Here we select the author_id field, remove the digit 1, and click <<.
Then we add the condition = 2.
The Show this query here again option (checked by default) means that the query
will stay in the box after its execution if we are still on the same page. This can be
better seen for a query like an UPDATE or DELETE, which affects a table but does not
produce a separate results page.
Clicking Into the Query Box
The default value of the $cfg['TextareaAutoSelect'] configuration directive is
TRUE. This is why the first click into this box selects all its contents. (This is a way to
quickly copy the contents elsewhere or delete them from the box.) The next click puts
the cursor at the click position. If the directive is set to FALSE, the first click does not
select all the contents of this text area.
The Query Window
In Chapter 3, we discussed the purpose of this window and the procedure for
changing some parameters (like dimension). This window can be easily opened from
the left panel using the SQL icon or the Query window link, and is very convenient
for entering a query and testing it:
Entering SQL Commands
[ 198 ]
The following screenshot shows the query window that appears over the right panel:
It contains the same Fields selector and << button as that used in a Table view context.
Pages:
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193