Query Wizard

From 215707177c272f9fcf73a79b9150fe677b991716 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Fri, 24 Dec 2021 11:32:32 -0300 Subject: Refactor database files Change-Id: If6acf26ea094234d06522c26c8bb8274c0abdaa5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127430 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- .../shared/explorer/database/querywizard00.xhp | 49 ------------------ .../shared/explorer/database/querywizard01.xhp | 48 ----------------- .../shared/explorer/database/querywizard02.xhp | 59 --------------------- .../shared/explorer/database/querywizard03.xhp | 60 ---------------------- .../shared/explorer/database/querywizard04.xhp | 59 --------------------- .../shared/explorer/database/querywizard05.xhp | 43 ---------------- .../shared/explorer/database/querywizard06.xhp | 60 ---------------------- .../shared/explorer/database/querywizard07.xhp | 42 --------------- .../shared/explorer/database/querywizard08.xhp | 51 ------------------ source/text/shared/guide/data_queries.xhp | 2 +- source/text/shared/guide/database_main.xhp | 2 +- source/text/shared/guide/main.xhp | 2 +- 12 files changed, 3 insertions(+), 474 deletions(-) delete mode 100644 source/text/shared/explorer/database/querywizard00.xhp delete mode 100644 source/text/shared/explorer/database/querywizard01.xhp delete mode 100644 source/text/shared/explorer/database/querywizard02.xhp delete mode 100644 source/text/shared/explorer/database/querywizard03.xhp delete mode 100644 source/text/shared/explorer/database/querywizard04.xhp delete mode 100644 source/text/shared/explorer/database/querywizard05.xhp delete mode 100644 source/text/shared/explorer/database/querywizard06.xhp delete mode 100644 source/text/shared/explorer/database/querywizard07.xhp delete mode 100644 source/text/shared/explorer/database/querywizard08.xhp (limited to 'source/text/shared') diff --git a/source/text/shared/explorer/database/querywizard00.xhp b/source/text/shared/explorer/database/querywizard00.xhp deleted file mode 100644 index ffe7474007..0000000000 --- a/source/text/shared/explorer/database/querywizard00.xhp +++ /dev/null @@ -1,49 +0,0 @@ - - - - - - - - -Query Wizard -/text/shared/explorer/database/querywizard00.xhp - - - -

mw deleted 2 index entries - -Query Wizard -The Query Wizard helps you to design a database query. The saved query can be called later, either from the graphical user interface, or using the automatically created SQL language command. -

-Query Wizard - Field selection - - diff --git a/source/text/shared/explorer/database/querywizard01.xhp b/source/text/shared/explorer/database/querywizard01.xhp deleted file mode 100644 index 16eb42baa1..0000000000 --- a/source/text/shared/explorer/database/querywizard01.xhp +++ /dev/null @@ -1,48 +0,0 @@ - - - - - - - - -Query Wizard - Field Selection -/text/shared/explorer/database/querywizard01.xhp - - - -

-Query Wizard - Field Selection -Specifies the table to create the query, and specifies which fields you wish to include in the query. -

- -Tables -Specifies the table for which the query is to be created. -

- -Fields in the Query -Displays all fields that will be included in the new query. -Query Wizard - Sorting order - - diff --git a/source/text/shared/explorer/database/querywizard02.xhp b/source/text/shared/explorer/database/querywizard02.xhp deleted file mode 100644 index 10d4ed3339..0000000000 --- a/source/text/shared/explorer/database/querywizard02.xhp +++ /dev/null @@ -1,59 +0,0 @@ - - - - - - - - -Query Wizard - Sorting Order -/text/shared/explorer/database/querywizard02.xhp - - -UFI: new Query Wizard page 2 - - - -

-Query Wizard - Sorting Order -Specifies the sorting order for the data records in your query. -

- -Sort by -Specifies the field by which the created query is sorted. - - - - -Ascending -Click to sort in alphabetically or numerically ascending order. - - - - -Descending -Click to sort in alphabetically or numerically descending order. - - - -And then by -Specifies additional fields by which the created query is sorted, if previous sort fields are equal. -Query Wizard - Search conditions - - diff --git a/source/text/shared/explorer/database/querywizard03.xhp b/source/text/shared/explorer/database/querywizard03.xhp deleted file mode 100644 index bc4c9c1661..0000000000 --- a/source/text/shared/explorer/database/querywizard03.xhp +++ /dev/null @@ -1,60 +0,0 @@ - - - - - - - - -Query Wizard - Search Conditions -/text/shared/explorer/database/querywizard03.xhp - - -UFI: new Query Wizard page 3 - - - -

-Query Wizard - Search Conditions -Specifies the search conditions to filter the query. -

- -Match all of the following -Select to filter the query by all the conditions using a logical AND. - -Match any of the following -Select to filter the query by any of the conditions using a logical OR. - - - -Field -Select the field name for the filter condition. - - - -Condition -Select the condition for the filter. - - - -Value -Enter the value for the filter condition. -Query Wizard - Detail or summary - - diff --git a/source/text/shared/explorer/database/querywizard04.xhp b/source/text/shared/explorer/database/querywizard04.xhp deleted file mode 100644 index d22a8d98b6..0000000000 --- a/source/text/shared/explorer/database/querywizard04.xhp +++ /dev/null @@ -1,59 +0,0 @@ - - - - - - - - -Query Wizard - Detail or Summary -/text/shared/explorer/database/querywizard04.xhp - - -UFI: new Query Wizard page 4 - - - -

-Query Wizard - Detail or Summary -Specifies whether to display all records of the query, or only the results of aggregate functions. -This page is only displayed when there are numerical fields in the query that allow the use of aggregate functions. -

- -Detailed query -Select to show all records of the query. - -Summary query -Select to show only results of aggregate functions. -Select the aggregate function and the field name of the numeric field in the list box. You can enter as many aggregate functions as you want, one in each row of controls. - -Aggregate function -Select the aggregate function. - -Field name -Select the numeric field name. - -+ -Appends a new row of controls. - -− -Removes the last row of controls. -Query Wizard - Grouping - - diff --git a/source/text/shared/explorer/database/querywizard05.xhp b/source/text/shared/explorer/database/querywizard05.xhp deleted file mode 100644 index 058d394201..0000000000 --- a/source/text/shared/explorer/database/querywizard05.xhp +++ /dev/null @@ -1,43 +0,0 @@ - - - - - - - - -Query Wizard - Grouping -/text/shared/explorer/database/querywizard05.xhp - - - -

-Query Wizard - Grouping -Specifies whether to group the query. The data source must support the SQL statement "Group by clauses" to enable this page of the Wizard. -

- -Group by -Displays all fields that are to be used to group the query. -Query Wizard - Grouping conditions - - diff --git a/source/text/shared/explorer/database/querywizard06.xhp b/source/text/shared/explorer/database/querywizard06.xhp deleted file mode 100644 index 0f5c69f341..0000000000 --- a/source/text/shared/explorer/database/querywizard06.xhp +++ /dev/null @@ -1,60 +0,0 @@ - - - - - - - - -Query Wizard - Grouping Conditions -/text/shared/explorer/database/querywizard06.xhp - - -UFI: new Query Wizard page 6 - - - -

-Query Wizard - Grouping Conditions -Specifies the conditions to group the query. The data source must support the SQL statement "Group by clauses" to enable this page of the Wizard. -

- -Match all of the following -Select to group the query by all the conditions using a logical AND. - -Match any of the following -Select to group the query by any of the conditions using a logical OR. - - - -Field name -Select the field name for the grouping condition. - - - -Condition -Select the condition for the grouping. - - - -Value -Enter the value for the grouping condition. -Query Wizard - Aliases - - diff --git a/source/text/shared/explorer/database/querywizard07.xhp b/source/text/shared/explorer/database/querywizard07.xhp deleted file mode 100644 index 449c11b4f0..0000000000 --- a/source/text/shared/explorer/database/querywizard07.xhp +++ /dev/null @@ -1,42 +0,0 @@ - - - - - - - - -Query Wizard - Aliases -/text/shared/explorer/database/querywizard07.xhp - - -UFI: new Query Wizard page 7 - - - -

-Query Wizard - Aliases -Assigns aliases to field names. Aliases are optional, and can provide more user-friendly names, which are displayed in place of field names. For example, an alias can be used when fields from different tables have the same name. -

- -Alias -Enter the alias for the field name. -Query Wizard - Overview - - diff --git a/source/text/shared/explorer/database/querywizard08.xhp b/source/text/shared/explorer/database/querywizard08.xhp deleted file mode 100644 index f94b755a7c..0000000000 --- a/source/text/shared/explorer/database/querywizard08.xhp +++ /dev/null @@ -1,51 +0,0 @@ - - - - - - - - -Query Wizard - Overview -/text/shared/explorer/database/querywizard08.xhp - - -UFI: new Query Wizard page 8 - - - -

-Query Wizard - Overview -Enter a name of the query, and specify whether you want to display or to modify the query after the Wizard is finished. -

- -Name of the query -Enter the name of the query. - -Display query -Select to save and display the query. - -Modify query -Select to save the query and open it for editing. - -Overview -Displays a summary of the query. -Query Wizard - - diff --git a/source/text/shared/guide/data_queries.xhp b/source/text/shared/guide/data_queries.xhp index b7347fffcc..82ab190591 100644 --- a/source/text/shared/guide/data_queries.xhp +++ b/source/text/shared/guide/data_queries.xhp @@ -41,7 +41,7 @@ If you often want to access only a subset of your data that can be well defined by a filter condition, you can define a query. This is basically a name for the new view at the filtered data. You open the query and see the current data in the table layout that you defined. Creating a New Query With the Query Wizard -In %PRODUCTNAME you can create a new query using the Query Wizard: +In %PRODUCTNAME you can create a new query using the Query Wizard: Open the database file where you want to create the new query. diff --git a/source/text/shared/guide/database_main.xhp b/source/text/shared/guide/database_main.xhp index 6a142d0005..ec874dc4e4 100644 --- a/source/text/shared/guide/database_main.xhp +++ b/source/text/shared/guide/database_main.xhp @@ -50,7 +50,7 @@

Queries

Create new query or table view, edit query structure -Query Wizard +Query Wizard Enter, edit and copy records

Tables

Create new table, edit table structure, index, relations diff --git a/source/text/shared/guide/main.xhp b/source/text/shared/guide/main.xhp index c962100ac7..a3f45acf2e 100644 --- a/source/text/shared/guide/main.xhp +++ b/source/text/shared/guide/main.xhp @@ -115,7 +115,7 @@

Data Sources

Working with databases in %PRODUCTNAME Table Wizard -Query Wizard +Query Wizard Forms Wizard Report Wizard

-- cgit