How to use condition expressions in a query? about dynamoid HOT 6 OPEN

It seems QueryFilter/ScanFilter don't support conditions on collections like List and Map:

This parameter does not support attributes of type List or Map.
https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_Scan.html#DDB-Scan-request-ScanFilter
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/LegacyConditionalParameters.QueryFilter.html

But recently where was switched from them to the Expressions style, that does support such conditions.

So right now 'settings.color.not_null' => true should not work but it seems easy to support it. Will try to add it soon and release in the next release.

from dynamoid.

The work is in progress (#696) - I will come back to it soon.

from dynamoid.

I will check if it's possible to do it with QueryFilter/ScanFilter request parameters (that are deprecated now).

from dynamoid.

Sorry for bothering @andrykonchin , but maybe any update on this? Found filter_expression_convertor (

from dynamoid.

Hi @andrykonchin . I see new version is here, I checked https://github.com/Dynamoid/dynamoid/pull/655/files but not sure how correctly to pass params to the .where method to filter by the Map fields which has some key 😞 Can you please help with that? Maybe we also need some READE section with how-to section on how to use new expressions

I still see:

field :metadata, :map 

# ...

Model.where("metadata.scores.not_null": true ).count

Traceback (most recent call last):
        1: from (irb):9
Dynamoid::Errors::Error (Unsupported operator screen_scores in metadata.scores.not_null)

from dynamoid.

OK I see Dynamoid::Criteria::Chain doesn't allow it via def field_condition which does the following:

name, operator = key.to_s.split('.')

So for where("settings.color.not_null": true) it returns => ["metadata", "screen_scores", "not_null"]

from dynamoid.