Unable to get records as per sort_key

Question

Unable to get records as per sort_key

connect-javed001 opened this issue 4 years ago · 16 comments

Trying to get records in descending order, but it's always returns same result, I have sort_key (as current timestamp), can u please help me ?

Also provide solution when we want to search records based on date filter using sort key

connect-javed001 commented 4 years ago

Yes

Answer 1 · 2021-02-16T18:40:37.000Z

What code are you using? Have you delcared the index in your model?

Answer 2 · 2021-02-17T03:51:53.000Z

No, Defined primaryKey & compositeKey only

Answer 3 · 2021-02-17T15:40:56.000Z

Can you show us your model?

Answer 4 · 2021-02-17T15:47:29.000Z

namespace App\Models;

use BaoPham\DynamoDb\DynamoDbModel;

class Activity extends DynamoDbModel
{
    protected $table;
    protected $primaryKey;
    protected $compositeKey;

    public function __construct()
    {
        $this->primaryKey = config('dynamodb.connections.aws.hash_key');
        $this->compositeKey = [
            config('dynamodb.connections.aws.hash_key'),
            config('dynamodb.connections.aws.sort_key')
        ];
        $this->table = "Activity";
    }
}

Answer 5 · 2021-02-19T12:08:43.000Z

Could you try using the index?

/**
 * Indexes.
 * [
 *     '<simple_index_name>' => [
 *          'hash' => '<index_key>'
 *     ],
 *     '<composite_index_name>' => [
 *          'hash' => '<index_hash_key>',
 *          'range' => '<index_range_key>'
 *     ],
 * ]
 *
 * @var array
 */
protected $dynamoDbIndexKeys = [
    'count_index' => [
        'hash' => 'count'
    ],
];

Answer 6 · 2021-02-22T03:45:29.000Z

where we need to define above index ?

Answer 7 · 2021-02-23T12:14:48.000Z

In the model?

Answer 8 · 2021-03-05T18:42:10.000Z

Did it work?

Answer 9 · 2021-03-12T03:56:03.000Z

No. Still getting same issue

Answer 10 · 2021-03-16T11:32:55.000Z

What does your model look like now?

Answer 11 · 2021-03-21T11:22:51.000Z

namespace App\Models;

use BaoPham\DynamoDb\DynamoDbModel;

class ActivityTracking extends DynamoDbModel
{
    protected $table;
    protected $primaryKey;
    protected $compositeKey;

    /**
     * Indexes.
     * [
     *     '<simple_index_name>' => [
     *          'hash' => '<index_key>'
     *     ],
     *     '<composite_index_name>' => [
     *          'hash' => '<index_hash_key>',
     *          'range' => '<index_range_key>'
     *     ],
     * ]
     *
     * @var array
     */
    protected $dynamoDbIndexKeys = [
        'count_index' => [
            'hash' => 'count'
        ],
    ];

    public function __construct()
    {
        $this->primaryKey = config('aws.hash_key');
        $this->compositeKey = [
            config('aws.hash_key'),
            config('aws.sort_key')
        ];
        $this->table = "ActivityTracking";
    }
}

Answer 12 · 2021-03-26T17:20:16.000Z

Are you using withIndex('count_index') ?

Answer 13 · 2021-03-27T09:33:34.000Z

Yes, But at server end, Index not defined

Answer 14 · 2021-03-28T03:53:06.000Z

Is it compulsory to create index for sorting ?

Answer 15 · 2021-04-06T15:18:58.000Z

You’ll need to create the index before you can use it.