Problems Querying data with InWithStringValue

[Elie]

Hello everyone,

I have the following code:
csharp
KiiBucket bucket = Kii.Bucket("mydata");
string [] ids = {"1","5","9"};
KiiQuery query = new KiiQuery(KiiClause.InWithStringValue("id",ids));
try
{
KiiQueryResult<KiiObject> result = bucket.Query(query);
foreach (KiiObject obj in result)
{
print(obj["id"]+" "+obj["name"]+" "+obj["address"]);
}
}
catch (Exception e)
{
print("Woops something went wrong !");
}

For some reason I am not receiving any data when the query executes.

The data stored in my bucket is similar to: "id":"1","name":"John","Address":"Street1"

Am I missing something here?

EDIT: If I query for all the objects in the bucket, the result is as expected. I tried using other types of queries such as a simple OR but still no luck.

[ochtea]

Hi, Elie

I tried with following code, it works well.

• Object data sample (key name is lower-case)

{"id":"1","name":"John","address":"street1"}

• Code

KiiBucket bucket = Kii.Bucket("mydata");
string [] ids = {"1","5","9"};
KiiQuery query = new KiiQuery(KiiClause.InWithStringValue("id", ids));
try
{
    KiiQueryResult<KiiObject> result = bucket.Query(query);
    foreach (KiiObject obj in result)
    {
        print(obj["id"] + " " + obj["name"] + " " + obj["address"]);
    }
}
catch (Exception e) 
{
    print("Exception type : " + e.GetType().FullName + " / Message : " + e.Message );
}

• Output

1 John street1

Would you check what type exception or error is thrown in your code with e.GetType().FullName?

I guess you may catch "KiiCorp.Cloud.Storage.IllegalKiiBaseObjectFormatException" in your code when getting a value from KiiObject, due to specify key which does not exist in object or not match case.

Best,

[Elie]

Hello ochtea,

The strange part is that it is not throwing an exception. If I print result.count , it returns 0 objects which means that it is not matching any values although I'm sure they exist.

Are there any prerequisites for me being able to query my bucket ? As mentioned, if I try to query all objects, it successfully returns the objects.

regards,

[Elie]

I managed to get it to work. For some reason my IDs were uploaded as Strings. Once I converted them to integers, I was able to match using InWithIntValue.

I am not quite sure what the drawbacks are when querying using InWithStringValue and how unexpected the results can be.

I hope someone can shed some light on the best practices when it comes to matching InWithStringValue.

Thank you

[ramneet]

i'm new in ios,
plz refine this code for objective-c where i want to match email id and password in my bucket .

my bucket name "userRegisteration"
{
"password": "123456",
"fullname": "ramneet",
"weChatId": "ramneet@w.com",
"email": "ramneet@gmail.com",
"cpassword": "123456",
"lastname": "singh"
}

[harpreet]

hiiii
can you write this code for objective c ?
thanks.