Translation

02010100.xhp par_id3145134 help.text
English fWRgB
Context English Vietnamese Actions
02010100.xhp
par_id3154964
help.text
To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:
02010100.xhp
hd_id3146916
help.text
Field
02010100.xhp
par_id3156372
help.text
<ahelp hid="HID_QRYDGN_ROW_FIELD">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The "Table name.*" option selects all data fields with the effect that the specified criteria will be applied to all table fields.
02010100.xhp
hd_id3145150
help.text
Alias
02010100.xhp
par_id3146315
help.text
<ahelp hid="HID_QRYDGN_ROW_ALIAS">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias.
02010100.xhp
par_id3155959
help.text
In a SQL statement, aliases are defined as follows:
02010100.xhp
par_id3149922
help.text
SELECT column AS alias FROM table.
02010100.xhp
par_id3159335
help.text
For example:
02010100.xhp
hd_id3148485
help.text
Table
02010100.xhp
par_id3163665
help.text
<ahelp hid="HID_QRYDGN_ROW_TABLE">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query.
02010100.xhp
hd_id3154207
help.text
Sort
02010100.xhp
par_id3150979
help.text
<ahelp hid="HID_QRYDGN_ROW_ORDER">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level.
02010100.xhp
hd_id3150384
help.text
Visible
02010100.xhp
par_id3146133
help.text
<ahelp hid="HID_QRYDGN_ROW_VISIBLE">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it.
02010100.xhp
hd_id3154714
help.text
Criteria
02010100.xhp
par_id3145134
help.text
<ahelp hid="HID_QRYDGN_ROW_CRIT">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>
02010100.xhp
hd_id3152477
help.text
or
02010100.xhp
par_id3154585
help.text
Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR.
02010100.xhp
par_id3148800
help.text
You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:
02010100.xhp
hd_id3148419
help.text
Functions
02010100.xhp
par_id3153233
help.text
<ahelp hid="HID_QRYDGN_ROW_FUNCTION" visibility="hidden">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine.
02010100.xhp
par_id8760818
help.text
If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:
02010100.xhp
par_id3150307
help.text
Option
02010100.xhp
par_id3152993
help.text
Effect
02010100.xhp
par_id3155377
help.text
No function
02010100.xhp
par_id3155533
help.text
No function will be executed.
02010100.xhp
par_id3166420
help.text
Average
02010100.xhp
par_id3154486
help.text
Calculates the arithmetic mean of a field.
02010100.xhp
par_id3149979
help.text
Count
02010100.xhp
par_id3155810
help.text
Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b).
02010100.xhp
par_id3151333
help.text
a) COUNT(*): Passing an asterisk as the argument counts all records in the table.

Loading…

User avatar None

String updated in the repository

LibreOffice Help - master / text/sdatabaseVietnamese

 
4 months ago
Browse all component changes

Glossary

English Vietnamese
No related strings found in the glossary.

String information

Context
02010100.xhp
par_id3145134
help.text
Source string description
fWRgB
Source string location
02010100.xhp
String age
4 months ago
Source string age
4 months ago
Translation file
vi/helpcontent2/source/text/sdatabase.po, string 109