Forum | Appery.io

Thanks, it has been shared with the email above and the name is Ludus247.

"filterService" doesn't return values because it requesting incorrect id.
Please try to add alert on service response and test once more.
pre

/pre

Thanks for that - I have added the alerts, however, I am still at a loss on how I am supposed to use an ID that isn't the primary ID. For example, I am tying the users to the Teams collection by the 'user id' and 'username' columns in Teams however I can't seem to work out how I can then use the corresponding row in Teams without the unique _ID.

Hope this makes sense!

Hello! Please clarify what data you store and where, what are you trying to get?

Ok, well I have a table called 'Teams' which has the columns:

• teams

• username

• user id

• _id etc

  I would like to query the database to get the data in 'teams' for the 'user id' or 'username' (I have both stored as a localStorage variable). Can you do this without the '_id'?

Hi,

Create request service with "where" parameter, map "user_id" to it and add the following JavaScript code for "where" parameter:
codereturn '{"user id": "' + value + '" }'/code
Please check the spelling of the field name: "user_id" or "user id".

Sorry, do you mean create a brand new service? Or to add a request parameter, 'where' on my existing, 'filterServerCode' service?

Add 'where' parameter to existing service.