Questions tagged [gqlquery]
129 questions
0
votes
2 answers
Google app engine - Query only for a field
Note: this example is just representative of the problem, not a real use case
I would like to know if I have a certain objects for example Car and CarCategory:
Owner
- name
- age
Car
- name
- brand
- category( reference )
…
Mc-
- 3,968
- 10
- 38
- 61
0
votes
0 answers
Use information of a previous GraphQL mutation in the same query
I want to run a single query with multiple mutations, but I need to reference the data from a previous mutations is that possible?
mutation {
venue1: createVenue(data: { name: "Test Venue 1", active: true }) {
id
}
layout1: createLayout(
…
Nicolas M. Pardo
- 753
- 1
- 6
- 16
0
votes
1 answer
Composite Index in Google Cloud Datastore
I have a kind name 'Wdr'. My index.yaml file looks like this .
indexes:
-kind: Wdr
ancestor: yes
properties:
-name : wdr_id
-name : wdr_sub_id
direction: desc
I am not able to run this gql query below.
SELECT * FROM Wdr where wdr_id = '1098'…
Hsn
- 1,168
- 2
- 16
- 39
0
votes
1 answer
Querying using custom key identifier(Name/ID) in firestore(datastore mode)?
I have a datastore entity like this below
Name/ID Parent Rollen email first_name last_name
name=CidassUID Key(Tenant, 'CidassGroupID') ["user","admin"] user@email.com user…
Hsn
- 1,168
- 2
- 16
- 39
0
votes
1 answer
GQL scheme to accept multiple data structure for same key
I'm currently using GQL Modules in my app.
In the below data structure, content will have either object or array
var A = {
content: {
text: "Hello"
}
}
var B = {
content: {
banner: [{
text: "Hello"
}]
}
}
How do I make…
aw3123
- 139
- 5
- 18
0
votes
1 answer
Datastore GQL with Datetime functions
I have a Google Cloud Datastore Kind, which has the property DataTime. This property is from the type DateTime.
I want to create a GQL statement the will return all the rows before two days. For example:
SELECT * FROM `Tracing-V1` WHERE StartTime <…
No1Lives4Ever
- 6,430
- 19
- 77
- 140
0
votes
1 answer
How to update single property of multiple entities in specific kind of datastore?
I want to update one property of each entity present in one particular kind of my datastore. In traditional sql, we do something like this as -
update set = ; {where clause is optional}
Now, how can I do same thing for…
Aniruddha Dwivedi
- 91
- 1
- 2
- 13
0
votes
1 answer
Google cloud Datastore GQL - Get current datetime
Is it possible to make a google datastore GQL query with a comparison on the current DateTime?
Example:
select * from MY_KIND where created_at < DATETIME.NOW
I've seen anything about that on any post or google…
FrankyBoy
- 26
- 4
0
votes
1 answer
Is it possible to query Entities in Google Cloud Datastore that have no descendants?
Is there a way to return Entities of kind that have no descendants in Google Cloud Datastore?
Brandon
- 375
- 2
- 16
0
votes
1 answer
How to show records according to time and whose status is less than 2 in GQL
I am new in GQL and facing problem while fetching records from cloud data store. I want to show records according to time when it is saving in data store and whose status is less than 2(i.e 0 or 1). Users whose details are saved recently comes on…
Sukhpal Singh
- 525
- 1
- 9
- 29
0
votes
1 answer
Google cloud Datastore Kind unable to return all records when queried with WHERE clause ( 2 - 3 filters ) using Datastore java API's
My datastore Kind is indexed on 5 columns.
When I query the Kind with 3 indexed filters using java API's :
RunQueryRequest.Builder request = RunQueryRequest.newBuilder();
request.setPartitionId(partitionId);
GqlQuery gqlQuery=…
Nitin S. Hadpe
- 1
- 1
0
votes
2 answers
What to prefer in GQL; StringListProperty or ListProperty?
I am building an application with a many to many relationship;
An item of entity 'Picture' can be linked to any number of Galleries ('Gallery'). And of course a Gallery can hold any number of Pictures.
So, following the Google Suggestion here, I…
Hannes
- 33
- 3
0
votes
1 answer
Google Cloud Datastore query by all kinds in node.js
In Google Cloud Console using GQL I can do this.
SELECT __key__
And this will return all keys from all kinds of the current namespace. One of the use case, is to delete tenant. Tenant will not exist as soon as no records existing inside.
I can't…
Artsiom Miksiuk
- 3,896
- 9
- 33
- 49
0
votes
1 answer
GQLQuery with_cursor not working
wondering if anyone knows why using cursors with GQLQuery doesn't seem to be working properly.
I'm running the following.
query = "SELECT * FROM myTable WHERE accountId = 'agdwMnBtZXNochALEglTTkFjY291bnQYpQEM' and lastUpdated > DATETIME('0001-01-01…
savagepanda
- 857
- 12
- 25
0
votes
1 answer
google app engine GQL, How to do pagination with datetime with millisecond accuracy
Hi I have an issue on querying for subsecond accuracy queries from GQL.. Wondering if anyone had similar issues or workarounds.
The context to the problem is that I'm loading batches of many objects into the google data store at once. So thousands…
savagepanda
- 857
- 12
- 25