Querying a Parse database to get the data from one single column within a Parse data Class

Question

Hello
I'm playing around with Parse, I've managed to create a cloud database with two classes/tables, Users and Posts, I'm able to register and login users and allow them to make posts to the database.
I'm now trying to work out how to query the database and get the data that has been posted, my Posts class/table is made up of four columns: | ObjectID | text | user | createdAt |.
I would like to be able to select and display in my app, all of the data held in the 'text' column. I have very little database experience so sorry if this is a stupid question.

Code so far:

    ParseQuery<ParseObject> query = ParseQuery.getQuery("Posts");
    query.findInBackground(new FindCallback<ParseObject>() {

        @Override
        public void done(List<ParseObject> text, ParseException e) {

            if (e == null) {


                 Toast.makeText(MainActivity.this, text.toString(), Toast.LENGTH_LONG).show();

            }

            else {

                Toast.makeText(MainActivity.this, "query error: " + e, Toast.LENGTH_LONG).show();
            }

        }
    });

I know that I need to constrain the query to only data from the 'text' column so I'm obviously missing a line of code between line 1 and 2.

Any help would be appreciated. Thanks.

Palak · Accepted Answer · 2016-03-01 11:36:40Z

5

From the Parse API

You can restrict the fields returned by calling selectKeys with a collection of keys. To retrieve documents that contain only the score and playerName fields (and also special built-in fields such as objectId, createdAt, and updatedAt):
   ParseQuery<ParseObject> query = ParseQuery.getQuery("GameScore");
   query.selectKeys(Arrays.asList("playerName", "score"));
   List<ParseObject> results = query.find();

So to just retrieve the Text field, all you have to do is:

ParseQuery<ParseObject> query = ParseQuery.getQuery("Posts");
query.selectKeys(Arrays.asList("text"));
    query.findInBackground(new FindCallback<ParseObject>() {

        @Override
        public void done(List<ParseObject> posts, ParseException e) {

            if (e == null) {
                List<String> postTexts = new ArrayList<String>();
                for(ParseObject post : posts){
                   postTexts.add(post.getString("text"));
                }
                Toast.makeText(MainActivity.this, postTexts.toString(), Toast.LENGTH_LONG).show();
            }

            else {
                Toast.makeText(MainActivity.this, "query error: " + e, Toast.LENGTH_LONG).show();

            }

        }
    });

API reference

Doc reference (Just before the heading 'Queries on Array values)

edited Mar 1, 2016 at 11:36

Palak

1,2884 gold badges17 silver badges24 bronze badges

answered Mar 16, 2015 at 10:51

Bart de Ruijter

96210 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Paul Alexander Over a year ago

Thanks, thanks really helpful! One more question, when I execute this code, it seems to be returning the data's ID's/Keys, how do I get the actual string of text??

Bart de Ruijter Over a year ago

Something like this? String text = text.getString("text"); (I'll update answer aswell)

Paul Alexander Over a year ago

no worries, got it: String s = text.get(0).getString("text"); this returns the string thats in position 0 of the list of data. thanks

Collectives™ on Stack Overflow

Querying a Parse database to get the data from one single column within a Parse data Class

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related