Retrieve Objects Uploaded By a specific user

Android
1

Hi, i have a table called offers
and lot of users registered
I want to fetch offers uploaded by a specific user by its “name” column which i made in BackendlessUser Table,
how can i achieve that, thanks in advance
@mark-piller
@vladimir-upirov

2

Hi Mohammed,

Just to confirm, the BackendlessUser table has a relation column pointing to the Offer table? Is it a one to many relationship?

Regards,
Mark

3

@mark-piller there no relation between the tables

4

Then how are the offers correlated to the users?

5

each user have an account and can upload offers by him self i want to show to every user the offers he uploaded not another people’s offers

6

@mark-piller i have made a column called “user name” in BackendlessUser table
i want to filter offers like for example whereClause "username = ‘john’ "

7

@mark-piller

8

It is not clear to me how the offers correlate to users at the database level. Normally it is done through relation columns, but you said there is no relation column.

9

@mark-piller in Users Table i created a column called “username”
so, every user has name, what i want to do is i want to filter offers from offers table by the username in BackendlessUser table
like if value of column username in BackendlessUser table is “A” then show objects from offers table that are only uploaded by “A”
is it possible or not?

10

Do you already have objects in both tables?

11

Of course

12

Do the Offer records have a value in the ownerId column?

13

Yep

14

One option is to load offers with the following where clause

ownerId = ‘objectId value of the user’

15

that is a good solution, thanks mark