How can I create a dynamic query in Amplify Datastore

user_1752012 0
Viewed 374

How do i create a dynamic query in amplify react application

Expected Query:

const posts = await DataStore.query(Post, c => c.or(
  c => c.rating("gt", 4).status("eq", PostStatus.PUBLISHED)
));

'rating' and 'status' may change depends on user. Please help me to create a dynamic datastore query.

amplify datastore aws-amplify typescript reactjs
1 Answers

let just say you have an object which defines what user can use what filter queries. Here I assumed user can be of two types typeA and typeB.

const queryTable = {
    typeA: ['status', 'rating'],
    typeB: ['active', 'status']
}

const posts = await DataStore.query(Post, c => c.or(
    c => {
        const operator = "eq" || "gt";
        const value = 4 || "published";
        queryTable[user.type].forEach(func, => {
            c.[func](operator, value)
        })
        return c
    }
));

You have to figure out a way how you can pass operator and value.

user_58156360
Related