Using dynamic request parameters for server code requests

[samwiltshire]

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

[Igor]

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

/pre

[samwiltshire]

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!

[Maryna Brodina]

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

[samwiltshire]

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'?

[Kateryna Grynko]

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".

[samwiltshire]

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

[maxkatz]

Add 'where' parameter to existing service.