retrieving data from collection

[Michael4771079]

Cheers Marina,
I tried that in test, here is the result, successful but no entries, there are over fifty companies in "newcastle upon tyne"

also cant use the above with select menu

[Michael4771079]

[Maryna Brodina]

1) Are you sure that there is a record NEWCASLTE UPON TYNE in DB in field Town?
Make a request with empty "where" parameter and check response. As we can see from the screenshot there is ALNWICK record in Town field. Try to send request with where code{"Town": "ALNWICK"}/code
Does this request work?

2) To use selected value in Select add JS in mapping codereturn '{"Town": "' + value + '"}';/code

[Michael4771079]

Thank you Marina

{"Town": "ALNWICK"} works in test, but selectmenu will not allow entry of

{"Town": "ALNWICK"}

[Maryna Brodina]

In value should be ALNWICK and this code codereturn '{"Town": "' + value + '"}';/code add in JS in mapping to request parameter where

[Michael4771079]

As always Marina,
thx very much, works great!