Questions tagged [querying]
516 questions
1
vote
2 answers
database primary key dynamoDB or other
I am using DynamoDB for my Alexa skill. In the documentation for dynamoDB, it says that the primary key (and any secondary indexes) has to be one of three types: binary, string, number. I was wondering if there was a way to search the database using…
An Ignorant Wanderer
- 1,322
- 1
- 10
- 23
1
vote
2 answers
LDAP: Query syntax
I've basically forgotten everything I ever learned about querying AD, and now I have a need to retrieve the list of users in one particular dept (DAAS). I've determined that there is an Organizational Unit called DAAS. I just can't figure out how to…
DaveInAZ
- 172
- 1
- 10
1
vote
0 answers
querying solr for count: omit fields when rows = 0?
I am optimizing queries for fetching from a solr backend and was asking myself:
If i query only for a facet for counting expected results, i query for 0 rows to be returned, because i just need the amount.
Does it additionally help (regarding…
ndo
- 96
- 7
1
vote
2 answers
MongoDB finding a speciffic document?
I'm struggling to find a specific document, as most tutorials are outdated, and my MongoDB version (the latest) does not have BasicDBObject.
I'm using BSON, here is my attempt,
public Document getPlayer(UUID uuid) {
Document toFind = new…
Archie
- 153
- 12
1
vote
1 answer
Mongo Aggregate query - combine two AND queries
I have following collection in my database
{
"_id" : ObjectId("5bdba3101efdd9172de0b52f"),
"year" : "2018",
"identifier" : "2Z00CInO",
"firstid" : "markt1995",
"secondid" : "ninee87"
},
{
"_id" :…
KrystianK
- 117
- 11
1
vote
1 answer
Swift Firestore Search for users
I've had already implemented a function to search for users using the FirebaseDatabase like that:
REF_USERS.queryOrdered(byChild: "username_lowercase").queryEnding(atValue: text+"\u{f8ff}").queryLimited(toFirst: 25).queryStarting(atValue:…
Marie.K
- 37
- 8
1
vote
1 answer
Javascript Querying on Elasticsearch does not work on Child Elements
I am trying to display searchresults on a elasticsearch database in my reactjs-app. Nevertheless I can only access the upper layer of key value pairs and am unable to reach the children.
The structure of my elasticsearch-objects is as…
Jones1220
- 786
- 2
- 11
- 22
1
vote
1 answer
Django querying on model which is involved in generic relation
Here I have 2 models, Company and UserSupervision. Company is related as a foreign key with generic relation model UserSupervision.
I want to have a query as following:
Company.objects.filter(**{'usersupervision__content_type': Company,
…
Bedilbek
- 849
- 7
- 17
1
vote
1 answer
Manually limiting Graql query results iterator
If I take a simple query, such as match $x isa dog; limit 5; get; then no matter how many dogs are stored in Grakn, I get 5 results back. This is fine, but what if I don't know how many dogs I want when I make the query and want to limit the number…
James Fletcher
- 920
- 11
- 13
1
vote
2 answers
is Passing query from react front end to feathers service good practice?
I am using rematch(https://github.com/rematch/rematch) to in React JS, and for backend Its Feathers. If I want to fetch the records from database with certain conditions, I am able to pass the query from in API call in React code.
Ex.
const empData…
Gaurav Bhusare
- 195
- 1
- 17
1
vote
1 answer
Searching for users by their username in Firebase database?
I am trying to make a search function that queries user by their username from Firebase database, but I want my the function to only return the users with the exact username(letters) that is typed in to the search bar. so lets say if I type Mike…
user8922356
1
vote
1 answer
couchbase cbc failed to bootstrap instance
running below command
cbc n1ql 'SELECT * FROM `travel-sample`'
Throws exception below
Failed to bootstrap instance. libcouchbase error: Authentication failed. You may have provided an invalid username/password combination (0x2)
I am referring to…
NoName
- 11
- 1
1
vote
2 answers
I want to sync user contacts to firebase firestore in one go
I am building chat application somewhat like whatsapp. I want to show registered app users list from user's device contact list while creating new group. Now in order to do that I have to compare each and every contact number with firebase firestore…
Sagar Khatri
- 1,004
- 8
- 23
1
vote
1 answer
django recurrent model lookup
I have a recurrent Category model (each category could have a parent Category), I also have Product model with ForeignKey to "core category" as below. Is there any possibility to query all Products within top level categories (not core)?
For…
moszoro
- 13
- 4
1
vote
1 answer
Querying a .csv file with conditions using Pandas and .shift
I'm having trouble querying a simple .csv file of trade data with conditions. The .csv file has 5 columns - [open, high, low, close, volume] with a time-series index, of minute by minute trades.
What I want to do is build a script that
(1) tells…
A. Blackmagic
- 233
- 1
- 3
- 9