Included objects in model

[aBuder]

Hi, is there an example available, where I have an Pointer object included in an response?

[phillwiggins]

Hey Sorry we haven't added that feature just yet. It would be the case of doing a double query at the moment from the pointer objects ID. Hopefully we will get this feature in shortly.

…

On Sun, 23 Dec 2018, 15:37 Alexander Buder ***@***.*** wrote: Hi, is there an example available, where I have an Pointer object included in an response? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#10>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AHgn3k1ms2RJOA_CLzXY2ox-FfH3cwSCks5u76M7gaJpZM4Zf4sZ> .

[aBuder]

Should you need help? Hole long I have to wait for feature?

[phillwiggins]

Any help would be gratefully appreciated. Obviously with the time of year it's going to be a bit of a break then straight back to it January. As the SDK is very immature at the moment, please do pick something your comfortable with and jump aboard.

…

On Sun, 23 Dec 2018, 20:52 Alexander Buder ***@***.*** wrote: Should you need help? Hole long I have to wait for feature? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#10 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AHgn3pJpOAX2W2nEGmeUPPLgT9juIDjiks5u7-0NgaJpZM4Zf4sZ> .

[phillwiggins]

Hey, should be able to work with this now?

[ghost]

For me, it's actually not working but from the REST API Guide, it seems that it could be easier than doing double queries.

For example, if we have Diet_Plans objects with GameScore pointer, we can retrieve complete GameScore object with one include.

curl -X GET \
  -H "X-Parse-Application-Id: APPLICATION_ID" \
  -H "X-Parse-REST-API-Key: ${REST_API_KEY}" \
  -G \
  --data-urlencode 'include=["gameScore"]' \
https://parseapi.back4app.com/classes/Diet_Plans

Update

Ok after, I saw that include was possible in the SDK but I test it and it doesn't work.

void query() async {
    var queryBuilder = QueryBuilder<DietPlan>(DietPlan());

    queryBuilder.include("gameScore");

    var response = await queryBuilder.query();

    //...
  }

[phillwiggins]

That's not the correct implementation of it...

include should be added to a query... i.e. queryBuilder.greaterThan(DietPlan.keyFat, 20);

void query() async {
    var response = await QueryBuilder<DietPlan>(DietPlan());
    ..greaterThan(DietPlan.FAT, 20)
    ..include("gameScore")
    .query();
}

Try something like that? I'm not sure if the syntax is correct but the include statement simple tells the api to include the full object, rather than just a pointer reference.

[ghost]

I tried many times and your syntax isn't correct :/

[phillwiggins]

Would this work? There was a semi colon added incorrectly. Regardless, build a query that will actually return an object that contains another object.

void query() async {
var response = await QueryBuilder(DietPlan())
..greaterThan(DietPlan.FAT, 20)
..include("gameScore")
..query();
}

[ghost]

No, there is en error for the line '..include("gameScore")'

The expression here has a type of 'void', and therefore cannot be used.

[phillwiggins]

This isn't related to the library. Please review the edited comment above. This is Dart syntax issues over library issues.

[ghost]

I test your code

void query() async {
var response = await QueryBuilder(DietPlan())
..greaterThan(DietPlan.FAT, 20)
..include("gameScore")
..query();
}

It's strange because your response variable is not a response (ParseResponse) but it's a QueryBuilder so I don't know how can I print the list of DietPlan for example. Do you have an idea ?

[phillwiggins]

Apologies, I'm not in front of a computer most times I am responding to you. Have you tried building the query as per the documentation.. i.e.

void query() async {
     var queryBuilder = await QueryBuilder(DietPlan())
     ..greaterThan(DietPlan.FAT, 20)
     ..include("gameScore");
     var response = await queryBuilder.query();
}

That should work?

[ghost]

I have a response but the include doesn't work, I don't have the complete gameScore object.

[phillwiggins]

Does your DietPlan table have a reference to an object called 'gameScore'? Please can you screenshot your Parse Dashboard with the table DietPlan on screen. Thanks

[ghost]

https://image.noelshack.com/fichiers/2019/03/3/1547631106-capture-d-ecran-2019-01-16-a-10-30-54.png

And the result:

Result: [{"className":"Diet_Plans","objectId":"U4FyTrkpBH","createdAt":"2019-01-11T10:40:08.121Z","updatedAt":"2019-01-16T09:28:51.569Z","Name":"Test1","Fat":666,"gameScore":"{'__type': 'Pointer', className: GameScore, objectId: ebqAUbJrKw}"}, {"className":"Diet_Plans","objectId":"TrcvvdZEiU","createdAt":"2019-01-16T09:20:17.727Z","updatedAt":"2019-01-16T09:30:21.996Z","Fat":30,"Name":"Test2","gameScore":"{'__type': 'Pointer', className: GameScore, objectId: ebqAUbJrKw}"}]

[phillwiggins]

Confirmed... This does look like a bug. I'll try and add a fix for 1.0.6.

Thanks for letting me know.

[phillwiggins]

Can we test this again? The code looks identical to other SDK's and should be working? I've added support for query encoding that might potentially work better...

[ghost]

I test but I doesn't work, I don't have the full object GameScore in my response

My code :

void query() async {
    var queryBuilder = QueryBuilder(DietPlan())
      ..includeObject(["gameScore"]);

    var response = await queryBuilder.query();

    if (response.success && response.result != null) {
      print(
          "Result: ${((response.result as List<dynamic>).first as DietPlan).toString()}");
    } else {
      print("Result: ${response.error.message}");
    }
  }

My console :

Result: {"className":"Diet_Plans","objectId":"U4FyTrkpBH","createdAt":"2019-01-11T10:40:08.121Z","updatedAt":"2019-01-18T15:02:55.869Z","Name":"Test1","Fat":666,"gameScore":"{'__type': 'Pointer', className: GameScore, objectId: ebqAUbJrKw}","image":"https://picsum.photos/52"}

[phillwiggins]

I have tested this and it does work. I have a Pointer object in my Parse table, with a mock object in there. A reference to another row in a different table, all works.

[ghost]

Mmm, can you copy/paste your 2 Model classes please ? Maybe I did something wrong.

[phillwiggins]

Sent via slack

[MungaraJay]

I was using parse server sdk in my app for database.

I have three class in my Back4App Dashboard which are "_User", "Office", "Office_Members".

In Office_Members class it has following columns,

1. user_id (Pointer to _User)
2. office_id (Pointer to Office)
3. count

To fetch the data including Pointer to _User as well from Office_Members, I am using following code,

QueryBuilder parseQuery = QueryBuilder(ParseObject("Office_Members"))
..whereEqualTo("office_id", ParseResponse_OfficeObject)
..includeObject(["user_id "]);

ParseResponse apiResponse = await parseQuery.query();

Output :

Payload : [{"className":"Office_Members","objectId":"twpDY51PUK","createdAt":"2020-08-14T09:58:59.775Z","updatedAt":"2020-08-14T09:58:59.775Z","office_id":{"__type":"Pointer","className":"Office","objectId":"4dkfSMrwBI"},"user_id":{"__type":"Pointer","className":"_User","objectId":"Hx5xJ5ABxG"},"count":1}]

In my payload response i am not getting whole user_id pointer response. I have followed the parse sdk server documentation throughout to fire parse queries.

@phillwiggins @scaneat @aBuder So can you help me that what i might be doing wrong?

Thanks.

[aniket453]

@MungaraJay @phillwiggins @scaneat Did you have any luck with this issue.

I am also getting same kind of issue. I am trying to fetch the values from my "Office" class and in my office class "user_id" column is the Pointer to my User class. So i also want to include user object. I am trying following code

QueryBuilder<ParseObject> parseQuery =
QueryBuilder<ParseObject>(ParseObject("Language"));
parseQuery.includeObject(['user_id']);

ParseResponse parseResponse = await parseQuery.query();

Output i am getting is :

[{"className":" Language ","objectId":"w3U0iHfhkh","createdAt":"2020-08-16T10:23:15.961Z","updatedAt":"2020-08-16T10:23:15.961Z","name":"Lang2199","address":"Address1521","user_id":{"__type":"Pointer","className":"_User","objectId":"zbhsxhpr9x"}}]

Update this thread if anyone finds a solution.

Thanks.

[RodrigoSMarques]

@aniket453
Which version of the plugin are you using?

This works correctly in version 1.0.26