retrieve followers

Hi,
I’m stuck at something and I’m asking for help understanding the right way to do it.
trying to get status messages (it’s a list) from users (obviously another list) I’m following. the following is a one to many field in the users list.
my code runs but doesn’t retrieve anything, can you tell me where I’ve gone wrong:

 StringBuilder whereClause = new StringBuilder();
 whereClause.append( "Statuses");
 whereClause.append( "Statuses.owner like '").append( user.getProperty("following") ).append("'");
 BackendlessDataQuery dataQuery = new BackendlessDataQuery();
 dataQuery.setWhereClause(whereClause.toString());
 Backendless.Persistence.of(Statuses.class).find( dataQuery, new AsyncCallback<BackendlessCollection<Statuses>> () {

Hi Gil,

“private” messages are reserved only for users on paid support. I can change this post to public, or you can resubmit it publicly. Another option is to purchase a support plan.

Regards,
Mark

Ok let’s change it to public.
Can you please help out dear Mark?

Could you post screenshots of the schema for each table related to this question? I need to see how the relations are defined. Make sure you post SCHEMA (not the data) screenshots.

Thanks,
Mark

thanks Mark!

keeping the other fields hidden because it will reveal the purpose of the app:

http://support.backendless.com/public/attachments/eedc987357f53253fe6cfe887a01ad2a.jpg</img>http://support.backendless.com/public/attachments/8674526e15b449e6a7bacade31e56222.jpg</img>

Hi Gil,

Please take a look at the response here: http://support.backendless.com/t/tabe-joins#comment-9182

It is very similar to your use-case, the same approach should work for you to retrieve the statuses.

Regards,
Mark

Hey Mark, thanks, I read your response to that guy, will try to run in today.