tencent cloud

Cloud Infinite

Scalar Search Expression Syntax

Unduh
Mode fokus
Ukuran font
Terakhir diperbarui: 2026-09-08 16:24:28
Diterjemahkan oleh AI

Introduction

Through this document, you can learn about:
The fields and operators supported by scalar search conditions, and the operator support status for each Field.
Operators supported in scalar search conditions include eq (equal to), gt (greater than), gte (greater than or equal to), lt (less than), lte (less than or equal to), exist (existence query), match-phrase (fuzzy query), and prefix (prefix query).
Operators supported in aggregation operations include min (minimum value), max (maximum value), average (average value, similar to avg in SQL), sum (summation), count (counting), distinct (deduplicated row count, similar to count(distinct) in SQL; the result of deduplicated row count is an approximate value. When the deduplicated row count is less than 10,000, the result is close to the exact value. When the deduplicated row count reaches 100 million, the error is around 2%), and group (group counting, which may have errors when the group size is large).
When searching for files using custom tag fields (CustomId and CustomLabels), the system searches for files by the Key-Value pairs of object tags. Object tag keys and values are case-insensitive. For example, to search for files that have the tag Bucket = examplebucket, set the query condition to {"Bucket": "examplebucket"}.
The following table lists the fields supported in scalar search conditions and aggregation operations, and the operator support status for each Field.

Scalar Search Conditions

Field
Type
Description
Supported Operators
Sorting Supported or Not
COSTaggingCount
Int
Number of COS custom tags
eq,gt,gte,lt,lte
Yes
COSTagging.*
Container
COS custom tags. Stores the key names and key-value pairs of your business custom tags on COS objects, which can be used as filter criteria for search during queries
eq,gt,gte,lt,lte,prefix,exist
No
COSUserMeta.*
Container
COS custom headers. Stores the key names and key-value pairs of your business on COS objects, which can be used as filter criteria for search during queries.
eq,gt,gte,lt,lte,prefix,exist
No
CreateTime
String
Timestamp of metadata creation time in RFC3339Nano format
eq,gt,gte,lt,lte
Yes
CustomId
String
Custom ID of the file. After the file is indexed into the dataset, it is stored as an attribute of the metadata in that row for association and mapping with your business system. You can pass in this value based on your business requirements, for example, associating a URI with an ID in your system. It is recommended to pass in a globally unique value
eq,gt,gte,lt,lte,prefix
Yes
CustomLabels.*
Container
Custom tag list of the file. Stores the key names and key-value pairs defined by your business, which can be used as filter criteria for search during queries
eq,gt,gte,lt,lte,prefix,exist
No
ETag
String
When an Object is generated, a corresponding ETag is created. The ETag is used to identify the content of the Object
eq,gt,gte,lt,lte,prefix
Yes
FileModifiedTime
String
Timestamp of the file's last modification time in RFC3339Nano format
eq,gt,gte,lt,lte
Yes
Filename
String
File path
eq,gt,gte,lt,lte,match-phrase,prefix
Yes
MediaType
String
File media type
Enum values:
image: image
other: other
document: document
archive: archive
audio: audio
video: video
eq,gt,gte,lt,lte,prefix
Yes
ObjectACL
String
File access permission attribute
eq,gt,gte,lt,lte
Yes
ObjectId
String
Unique object ID
eq,gt,gte,lt,lte,prefix
Yes
ServerSideEncryption
String
Encryption algorithm. Requires setting x-cos-server-side-encryption.
eq,gt,gte,lt,lte,prefix
Yes
Size
Int
File size, in bytes
eq,gt,gte,lt,lte
Yes
UpdateTime
String
Timestamp of metadata modification time in RFC3339Nano format
After metadata is created, if it has not been updated, the timestamp of the metadata modification time is the same as the timestamp of the metadata creation time
eq,gt,gte,lt,lte
Yes
URI
String
Resource identifier field, indicating the file address for which an index needs to be created
eq,gt,gte,lt,lte,prefix
Yes

Scalar Search Aggregation Operations

Field
Type
Description
Supported Operators
Sorting Supported or Not
ContentDisposition
String
Specifies the name of the Object when the Object is downloaded. The COS Object HTTP attribute Content-Disposition needs to be set
count,distinct,group
Yes
ContentEncoding
String
Specifies the content encoding format of the Object when the Object is downloaded. The COS Object HTTP attribute Content-Encoding needs to be set
count,distinct,group
Yes
ContentLanguage
String
Language used by the Object content. The COS Object HTTP attribute Content-Language needs to be set
count,distinct,group
Yes
ContentType
String
File content type (MIME Type)
count,distinct,group
Yes
COSCRC64
String
File CRC64 value
count,distinct,group
Yes
COSStorageClass
String
File storage class
count,distinct,group
Yes
COSTagging.*
Container
COS custom tags. Stores the key names and key-value pairs of your business custom tags on COS objects, which can be used as filter criteria for search during queries
-
No
COSTaggingCount
Int
Number of COS custom tags
min,max,average,sum,count,distinct,group
Yes
COSUserMeta.*
Container
COS custom headers. Stores the key names and key-value pairs of your business on COS objects, which can be used as filter criteria for search during queries
-
No
CreateTime
String
Timestamp of metadata creation time in RFC3339Nano format
count,distinct,group
Yes
CustomId
String
Custom ID of the file. After the file is indexed into the dataset, it is stored as an attribute of the metadata in that row for association and mapping with your business system. You can pass in this value based on your business requirements, for example, associating a URI with an ID in your system. It is recommended to pass in a globally unique value
count,distinct,group
Yes
CustomLabels.*
Container
Custom tag list of the file. Stores the key names and key-value pairs defined by your business, which can be used as filter criteria for search during queries
-
No
ETag
String
When an Object is generated, a corresponding ETag is created. The ETag is used to identify the content of the Object
count,distinct,group
Yes
FileModifiedTime
String
Timestamp of the file's last modification time in RFC3339Nano format
count,distinct,group
Yes
Filename
String
File path
count,distinct,group
Yes
MediaType
String
File media type
Enum values:
image: image
other: other
document: document
archive: archive
audio: audio
video: video
count,distinct,group
Yes
ObjectACL
String
File access permission attribute
count,distinct,group
Yes
ObjectId
String
Unique object ID
count,distinct,group
Yes
ServerSideEncryption
String
Encryption algorithm. Requires setting x-cos-server-side-encryption
count,distinct,group
Yes
Size
Int
File size, in bytes
min,max,average,sum,count,distinct,group
Yes
UpdateTime
String
Timestamp of metadata modification time in RFC3339Nano format
After metadata is created, if it has not been updated, the timestamp of the metadata modification time is the same as the timestamp of the metadata creation time
count,distinct,group
Yes
URI
String
Resource identifier field, indicating the file address for which an index needs to be created
count,distinct,group
Yes



Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan