SQLiteQueryBuilder.BuildUnionSubQuery Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| BuildUnionSubQuery(String, String[], ICollection<String>, Int32, String, String, String, String) |
Construct a |
| BuildUnionSubQuery(String, String[], ICollection<String>, Int32, String, String, String[], String, String) |
Obsolete.
This member is deprecated. |
BuildUnionSubQuery(String, String[], ICollection<String>, Int32, String, String, String, String)
Construct a SELECT statement suitable for use in a group of
SELECT statements that will be joined through UNION operators
in buildUnionQuery.
[Android.Runtime.Register("buildUnionSubQuery", "(Ljava/lang/String;[Ljava/lang/String;Ljava/util/Set;ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;", "GetBuildUnionSubQuery_Ljava_lang_String_arrayLjava_lang_String_Ljava_util_Set_ILjava_lang_String_Ljava_lang_String_Ljava_lang_String_Ljava_lang_String_Handler")]
public virtual string? BuildUnionSubQuery(string? typeDiscriminatorColumn, string[]? unionColumns, System.Collections.Generic.ICollection<string>? columnsPresentInTable, int computedColumnsOffset, string? typeDiscriminatorValue, string? selection, string? groupBy, string? having);[<Android.Runtime.Register("buildUnionSubQuery", "(Ljava/lang/String;[Ljava/lang/String;Ljava/util/Set;ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;", "GetBuildUnionSubQuery_Ljava_lang_String_arrayLjava_lang_String_Ljava_util_Set_ILjava_lang_String_Ljava_lang_String_Ljava_lang_String_Ljava_lang_String_Handler")>]
abstract member BuildUnionSubQuery : string * string[] * System.Collections.Generic.ICollection<string> * int * string * string * string * string -> string
override this.BuildUnionSubQuery : string * string[] * System.Collections.Generic.ICollection<string> * int * string * string * string * string -> stringParameters
- typeDiscriminatorColumn
- String
the name of the result column whose cells will contain the name of the table from which each row was drawn.
- unionColumns
- String[]
the names of the columns to appear in the
result. This may include columns that do not appear in the
table this SELECT is querying (i.e. mTables), but that do
appear in one of the other tables in the UNION query that we
are constructing.
- columnsPresentInTable
- ICollection<String>
a Set of the names of the columns that appear in this table (i.e. in the table whose name is mTables). Since columns in unionColumns include columns that appear only in other tables, we use this array to distinguish which ones actually are present. Other columns will have NULL values for results from this subquery.
- computedColumnsOffset
- Int32
all columns in unionColumns before this index are included under the assumption that they're computed and therefore won't appear in columnsPresentInTable, e.g. "date * 1000 as normalized_date"
- typeDiscriminatorValue
- String
the value used for the type-discriminator column in this subquery
- selection
- String
A filter declaring which rows to return,
formatted as an SQL WHERE clause (excluding the WHERE
itself). Passing null will return all rows for the given
URL.
- groupBy
- String
A filter declaring how to group rows, formatted
as an SQL GROUP BY clause (excluding the GROUP BY itself).
Passing null will cause the rows to not be grouped.
- having
- String
A filter declare which row groups to include in
the cursor, if row grouping is being used, formatted as an
SQL HAVING clause (excluding the HAVING itself). Passing
null will cause all row groups to be included, and is
required when row grouping is not being used.
Returns
the resulting SQL SELECT statement
- Attributes
Remarks
Construct a SELECT statement suitable for use in a group of SELECT statements that will be joined through UNION operators in buildUnionQuery.
Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.
Applies to
BuildUnionSubQuery(String, String[], ICollection<String>, Int32, String, String, String[], String, String)
Caution
deprecated
This member is deprecated.
[Android.Runtime.Register("buildUnionSubQuery", "(Ljava/lang/String;[Ljava/lang/String;Ljava/util/Set;ILjava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;", "GetBuildUnionSubQuery_Ljava_lang_String_arrayLjava_lang_String_Ljava_util_Set_ILjava_lang_String_Ljava_lang_String_arrayLjava_lang_String_Ljava_lang_String_Ljava_lang_String_Handler")]
[System.Obsolete("deprecated")]
public virtual string? BuildUnionSubQuery(string? typeDiscriminatorColumn, string[]? unionColumns, System.Collections.Generic.ICollection<string>? columnsPresentInTable, int computedColumnsOffset, string? typeDiscriminatorValue, string? selection, string[]? selectionArgs, string? groupBy, string? having);[<Android.Runtime.Register("buildUnionSubQuery", "(Ljava/lang/String;[Ljava/lang/String;Ljava/util/Set;ILjava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;", "GetBuildUnionSubQuery_Ljava_lang_String_arrayLjava_lang_String_Ljava_util_Set_ILjava_lang_String_Ljava_lang_String_arrayLjava_lang_String_Ljava_lang_String_Ljava_lang_String_Handler")>]
[<System.Obsolete("deprecated")>]
abstract member BuildUnionSubQuery : string * string[] * System.Collections.Generic.ICollection<string> * int * string * string * string[] * string * string -> string
override this.BuildUnionSubQuery : string * string[] * System.Collections.Generic.ICollection<string> * int * string * string * string[] * string * string -> stringParameters
- typeDiscriminatorColumn
- String
the name of the result column whose cells will contain the name of the table from which each row was drawn.
- unionColumns
- String[]
the names of the columns to appear in the
result. This may include columns that do not appear in the
table this SELECT is querying (i.e. mTables), but that do
appear in one of the other tables in the UNION query that we
are constructing.
- columnsPresentInTable
- ICollection<String>
a Set of the names of the columns that appear in this table (i.e. in the table whose name is mTables). Since columns in unionColumns include columns that appear only in other tables, we use this array to distinguish which ones actually are present. Other columns will have NULL values for results from this subquery.
- computedColumnsOffset
- Int32
all columns in unionColumns before this index are included under the assumption that they're computed and therefore won't appear in columnsPresentInTable, e.g. "date * 1000 as normalized_date"
- typeDiscriminatorValue
- String
the value used for the type-discriminator column in this subquery
- selection
- String
A filter declaring which rows to return,
formatted as an SQL WHERE clause (excluding the WHERE
itself). Passing null will return all rows for the given
URL.
- selectionArgs
- String[]
- groupBy
- String
A filter declaring how to group rows, formatted
as an SQL GROUP BY clause (excluding the GROUP BY itself).
Passing null will cause the rows to not be grouped.
- having
- String
A filter declare which row groups to include in
the cursor, if row grouping is being used, formatted as an
SQL HAVING clause (excluding the HAVING itself). Passing
null will cause all row groups to be included, and is
required when row grouping is not being used.
Returns
the resulting SQL SELECT statement
- Attributes
Remarks
This member is deprecated. This method's signature is misleading since no SQL parameter substitution is carried out. The selection arguments parameter does not get used at all. To avoid confusion, call #buildUnionSubQuery instead.
Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.