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. The system searches for files based on the key-value pair of the user-defined metadata. 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. The system searches for files based on the key-value pair of the object tag. Both the key and value of the object tag 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 available for simple queries, aggregate operations, and sorting. The table also specifies the operators supported by each field.

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