Amazon DynamoDB Query: Missing BEGINS_WITH condition?!

Hi,

As described here, there should be a “BEGINS_WITH” condition along with other conditions available in the Amazon DynamoDB Query node but it doesn’t exist in the node’s configurations. Luckily I could make a fake range to use with “BETWEEN” but it’s not a promising solution. Is there a particular reason for not having “BEGINS_WITH”?

:blush:

HI Armin,
We are using the condition expression API, which replaces the previous operators. Here you have to use the begins_with (a , substr) function as described here: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Query.html#Query.KeyConditionExpressions. Please let me know if that works! Generally, we just pass the expression on to the official Amazon library, so everything they support, we support.
Kind regards,
Alexander

1 Like

Hi Alexander,

I want to use the condition on the range key but the operator “begins_with” is not available. I cannot pass the operator as a flow variable too.

:blush:

Hi,
Can you send a screenshot of the dialog with your expression?
Kind regards,
Alexander

There is no “BEGINS_WITH” operator for the range key.

:blush:

Hi,
Ah, now I get it. My bad! I will open a ticket so that this is added to the node! Unfortunately I do not know of a workaround right now :-/
Kind regards,
Alexander

3 Likes