Find with primary key and nested attribute

[kjohnstonadept]

I noticed that if I am using a primary key with a nested attribute as a property, and I try to do a find using just that property value, what happens is that onetable constructs the key expression just fine, but it adds a filter expression that looks for an exact match of the nested object with just the primary key property.

Is there a way to have find exclude that filter expression and just do a search on the key?

Example:

Schema:

export const ProductSchema = {
    format: 'onetable:1.1.0',
    version: '0.0.1',
    indexes: {
        primary: { hash: 'pk', sort: 'sk' },
        gsi1: { hash: 'pk1', sort: 'sk1' },
        gsi2: { hash: 'pk2', sort: 'sk2' }
    },
    params: {
        isoDates: true,
        timestamps: true
    },
    models: {
        Product: {
            pk: { type: String, value: 'prod#${attrs.id}' },
            sk: { type: String, value: 'INFO' },
            attrs: {
                type: Object,
                schema: {
                    id: { type: String },
                    type: { type: String },
                    description: { type: String },
                    prices: { type: Array }
                }
            }
        }
    } as const
};

This returns an empty array:

const stuff = await productModel.find({ attrs: { id } });

This is the query generated:

    {
        "cmd": {
            "ExpressionAttributeNames": {
                "#_0": "attrs",
                "#_1": "pk",
                "#_2": "sk"
            },
            "ExpressionAttributeValues": {
                ":_0": {
                    "id": "b21015fa-0861-43e8-b156-a6170ab3130e"
                },
                ":_1": "prod#b21015fa-0861-43e8-b156-a6170ab3130e",
                ":_2": "INFO"
            },
            "FilterExpression": "#_0 = :_0",
            "KeyConditionExpression": "#_1 = :_1 and #_2 = :_2",
            "TableName": "billing-v1-test-kJomZu",
            "ConsistentRead": false,
            "ScanIndexForward": true
        },
        "items": [],
        "op": "find",
        "properties": {
            "attrs": {
                "id": "b21015fa-0861-43e8-b156-a6170ab3130e"
            },
            "pk": "prod#b21015fa-0861-43e8-b156-a6170ab3130e",
            "sk": "INFO"
        },
        "params": {
            "parse": true,
            "high": true,
            "checked": true
        }
    }

Update: I see now that the filter expression is always added with find, even when the key attribute is at the top level. Of course at the top level the filter expression works, since there are no nested properties.

[mobsense]

You could try a where expression. Those support dotted properties in the expressions.

[kjohnstonadept]

I tried this - but it throws an error:

        const products = await productModel.find({}, { where: '${attrs.id} = @{id}', substitutions: { id: id } });

    TypeError: Cannot read property 'id' of undefined

      at Model.getPropValue (node_modules/dynamodb-onetable/dist/cjs/Model.js:261:18)

[mobsense]

Can you create a debug test case for us to look at so we can reproduce?