NodeJS GCP Datastore Unable To Query

user_7877886 0
Viewed 101

I am trying to query the user by the Datastore auto-generated ID.

Below GQL query is able to run on Datastore Console
select * from User where __key__ = Key(User, 123)

But JS code using Datastore JS Library, doesn't work and returning empty list.

const filterKey = dataStore.key(['User', 123]);

dataStore.runQuery(dataStore.createQuery(relationEntity).filter('__key__', filterKey));
datastore google-cloud-platform
1 Answers

Something I see with your query is that you are missing the comparison operator inside the filter clause. Aside from that, what does relationEntity hold? To mimic your GQL query, it should be the kind name of the entities you want to fetch. I made this query to fetch entities based on your GQL query select * from User where __key__ = Key(User, 123):

const { Datastore } = require("@google-cloud/datastore");

const datastore = new Datastore();
//Kind = “User”, ID = 5634161670881280, using [default] namespace

const entKey = datastore.key(["User", 5634161670881280]);
const query = datastore.createQuery("User").filter("__key__", "=", entKey); 

datastore.runQuery(query).then(([entities]) => {
    entities.forEach((entity) => {
        console.log(entity.firstname) // prints “Foo” which is the ‘firstname’ in my entity
    });
}).catch((err) => {
    console.log(err);
});

Something else that could be a cause is the JS number limit, and in the documentation, it’s mentioned that you would need to wrap your auto-generated ID inside datastore.int(“<YOUR_ID>”) for large numbers. If you’d like to see more sample code, there are a lot of snippets in the Datastore Github repository. Let me know if this was useful.

user_169298940
Related