Object Storage Service:Appendix: List of fields and operators for scalar retrieval

Notes

• Simple queries support the following operators: eq (equal to), gt (greater than), gte (greater than or equal to), lt (less than), lte (less than or equal to), match (fuzzy query), and prefix (prefix query). Aggregate operations support the following operators: min (minimum), max (maximum), average (average), sum (sum), count (count), distinct (deduplicated count), and group (grouped count).

• To search for files using the OSSUserMeta.* field, replace the asterisk (*) with the key of the user-defined metadata. Files are matched by the key-value pair. The key is case-insensitive, and the value is case-sensitive.

  For example, you can search for files with the user-defined metadata x-oss-meta-location=hangzhou by setting the query condition to {"Field": "OSSUserMeta.x-oss-meta-location", "Value": "hangzhou", "Operation": "eq"}.

• To search for files using the OSSTagging.* field, replace the asterisk (*) with the key of the object tag. Files are matched by the key-value pair. Both the key and the value are case-sensitive.

  For example, to search for files that have the tag owner=John, set the query condition to {"Field": "OSSTagging.owner", "Value": "John", "Operation": "eq"}.

Support list

The following table lists the fields and their supported operators for simple queries, aggregate operations, and sorting.

In the table, ✓ indicates that the field supports the operator, and × indicates that it does not.