DynamoDB table design

I'm new to DynamoDB, but have worked for over 20 years with SQL Server. I need to design a table of call recordings, but I'm struggling with the whole thing because it seems very different to the tables I'm used to.

I need to store the following information:

RecordingID (GUID / string) CallersNumber (string) DialledNumber (string) Direction (string) (inbound/outbound call) CreatedTime (datetime) StartTime(datetime) EndTime(datetime) AgentIDs (list) - agents involved in the call QueueIDs (list) - call centre queues FilePath (string) - URL to call recording

I'd like to share the table creation script, but I can't see anywhere to generate one (an issue for later when deploying to a customer site). I've created the RecordingID as a partition ID, then added the other fields as attributes.

I have two issues:

1. I need to run searches on all the fields, but can only do a scan not a query because they're not the partition key - which is a bit rubbish, in SQL you simply add an index to avoid an expensive scan.

2. On the front end app, paging is failing to work because the primary key, RecordingID (e.g. ebda49c6-17fa-4468-8417-aad7322251bb), is not correctly ordered correctly and so when I retrieve a record set the LastEvaluatedKey/ExclusiveLastKey method of paging is not working.

Am I using the right table design?