AppSync: how to compare strings lexicographically in VTL

Yan Cui

I help clients go faster for less using serverless technologies.

I had been working on a client project where I built the GraphQL backend for a new social network using primarily AppSync, Lambda and DynamoDB.

One of the features of the app was to support private messaging between two users. To allow either user to fetch their chat messages in chronological descending order, I modelled the chat_messages DynamoDB table as below:

where userIds is the HASH key, and timestamp is the RANGE key.

Here, userIds is a composite key made up of the two users’ IDs, arrange in lexicographical order. If you know the two users’ IDs, you can fetch the chat messages using a DynamoDB Query operation.

So in the VTL template, I had something like this:

However, this didn’t work.

Given the following input:

The $userIds variable would be interpreted as 35c1f714–46c1–4ccb-87fc-933da626ce6a_08371580–48e2–43e7–9b1c-75804b9e7e12, where the user IDs are arranged in the wrong order. What’s going on?

If you work with Java everyday then the problem might be obvious to you, that to compare strings lexicographically you need to use the compareTo method on the first string. And since VTL is implemented in Java, that is also the case here.

Instead, the right way to do it is this:

I have found the VTL Reference page very handy while working with VTL. But unfortunately, lexicographical string comparison was not mentioned in the VTL docs. Without helpful folks like Richard and Franck I would have easily spent hours banging my head against this problem!


I hope this post helps you in a similar way should you run into the same problem, as my way of passing it forward.


Whenever you’re ready, here are 4 ways I can help you:

  1. If you want a one-stop shop to help you quickly level up your serverless skills, you should check out my Production-Ready Serverless workshop. Over 20 AWS Heroes & Community Builders have passed through this workshop, plus 1000+ students from the likes of AWS, LEGO, Booking, HBO and Siemens.
  2. If you want to learn how to test serverless applications without all the pain and hassle, you should check out my latest course, Testing Serverless Architectures.
  3. If you’re a manager or founder and want to help your team move faster and build better software, then check out my consulting services.
  4. If you just want to hang out, talk serverless, or ask for help, then you should join my FREE Community.