Stack Overflow
Stack Overflow

Questions tagged [gqlquery]

129 questions
1
vote
1 answer

Using localtime in a where clause for GqlQuery

I'm trying to understand how I can use the local server time to quickly filter results on google appengine. It seems to me that there should be a simple way of doing this using DATETIME(time.localtime()). For example (where 'timestamp' is of type…
Greg
  • 2,559
  • 4
  • 28
  • 46
1
vote
3 answers

GAE Datastore Viewer by GQL WHERE query for a String does not seem to work

Here is my data: ID/Name createdTime customerName itemName price quantity status user_orderid id=5681726336532480 2013-10-12 05:07:47.794000 "joe" "Nexus 5" 349.00 1 "pending" "1" Running either of these two queries gives…
Splaktar
  • 5,506
  • 5
  • 43
  • 74
1
vote
1 answer

How to filter against a StringListProperty that does not contain an item?

I have the following model of Users and I want to get all the users that like 'yellow', but don't like 'red'. class User(db.Model): name = db.StringProperty(required=True) favorite_colors = db.StringListProperty(required=True) This works…
jbochi
  • 28,816
  • 16
  • 73
  • 90
1
vote
2 answers

GQL error reports property is not indexed on dev_appserver?

Must be missing something really dumb here. This GQL query: q_count = Questions.gql('WHERE questionnaire = :1 AND deleted = False AND required = True', q).count(1000) generated following error: ERROR 2012-12-21 11:19:51,760 _webapp25.py:468]…
HorseloverFat
  • 3,290
  • 5
  • 22
  • 32
1
vote
2 answers

GqlQuery Results Only for Session?

My app, Datastore, webapp2, and form-specific "responses" are all working :) but I need the page to load without displaying previous visitor's query results. I need query results only for current form-submitter, after they submit form. Is this a…
p1nesap
  • 179
  • 1
  • 3
  • 13
0
votes
2 answers

GQL does not work for GET paramters for keys

I am trying to compare the key to filter results in GQL in Python but the direct comparison nor typecasting to int works. Therefore, I am forced to make a work around as mentioned in the uncommented lines below. Any clues? row =…
dhaval
  • 2,368
  • 9
  • 35
  • 60
0
votes
0 answers

How can I exclude non-matching records from a graphql using the gql library in python?

I am running a query against a graphql server, but the query is returning more records than can be handled and the query is timing out. I can't figure out how to get pagination to work properly, but really I only need a subset of all of the records…
Brad Davis
  • 1,063
  • 3
  • 18
  • 38
0
votes
0 answers

Convert gql-object back to string

I have a user.gql - file with some queries, mutations, inputs etc. I get content of user.gql, using gql(), then filter an document.definition to find needed a query. After filter document.definitions .filter(item => item.kind ===…
McLotos
  • 474
  • 1
  • 6
  • 15
0
votes
1 answer

GqlQuery from GoogleAppEngine returns empty list

Here is my query: currentID = 7 deck = range(0,3) similarIDs = db.GqlQuery('SELECT * FROM itemSet WHERE jokeID=:1 AND position IN :2', currentID, deck[:3]).fetch(100) Here is my model: class itemSet(db.Model): jokeID = db.IntegerProperty() jokeID2…
Kex
  • 776
  • 10
  • 22
0
votes
1 answer

Function to extract API queries results and output them as list or dictionary

I need a list of the results of an API call using gql for a dictionary of IDs. Let's say I have a dictionary of locations, ex: {"tokyo": "111", "rio": "112", "LA": "113"}, and I need to query on an API the info for each location, ex: transport =…
Julia R.
  • 15
  • 2
0
votes
1 answer

The code below shows the extracting data from graph db using node js. the data is extracting fine but when I use filter (where) it gives empty result

g.v() .has('label','Event') .not(has('active',false)).as('Event').order().by('createdTimestamp', decr) .project('label','event', 'user') .by(constant('Livestream')) .by( __.select('Event') .project('id', 'label', 'name',…
Junaid Ahmad
  • 17
  • 3
0
votes
2 answers

How to find path to a field in a graphql query

I am very new to graphql. I have a following graphql query for an example: query pets { breed(some arguments) { name items { owner(some arguments) { items { ID ownerSnumber …
Gurbaz Pooran
  • 41
  • 1
  • 7
0
votes
1 answer

How to apply validation in graphQL schema using graphql-constraint-directive

import { ApolloServer, makeExecutableSchema } from 'apollo-server-express'; const { constraintDirective, constraintDirectiveTypeDefs } = require('graphql-constraint-directive'); schema: mergeSchemas({ schemas: [ makeExecutableSchema({ …
Hemendra
  • 23
  • 3
0
votes
1 answer

How to randomise qraphql query results?

I'm trying to develop filters by passing a query string in the below productFetch() function and want to show only 28 products on the screen returned from the query below. How to make graphql query return random 28 products instead of the first 28? …
Huma
  • 31
  • 4
0
votes
3 answers

Select Objects with null values

How can I select only objects with null values in GQL. I have a object that for a new version of my software I include a LastUpdate fields, and I want to update only the oldest updated object, but when I made the query using " ORDER BY LastUpdate…
Victor
  • 8,309
  • 14
  • 80
  • 129
1 2 3
…
8 9