Query by nested field

You can call the NestedQuery operation to query data based on a nested field. You cannot use nested fields to directly query data. You must wrap the nested field in a nested query. To implement the nested query, you must specify a subquery (which can be any query) and the path of the nested field.

Examples

nested_query = RangeQuery('n.nl', range_from=100, range_to=300, include_lower=True, include_upper=True)
query = NestedQuery('n', nested_query)
rows, next_token, total_count, is_all_succeed = client.search(
    table_name, index_name, 
    SearchQuery(query, limit=100, get_total_count=True), 
    ColumnsToGet(return_type=ColumnReturnType.ALL)
)