Forum | Appery.io

Hi folks,
I am trying to implement a where service using 2 lsv.
I am working with a selectmenu which has a 4 locations as label and the letter "y" as value of all 4.
When selectmenu value changes they are saved in localstorage, this is the collection in the db

this where service needs to return all entries that have a "y" in the particular column
here are the values in localstorage

How can I combine the column name and value and get the required result.

thank you

Hello!

You would need to add JS in mapping http://devcenter.appery.io/documentat...

Im sorry,
I just not getting this,I have tried a few variations but no success
this is the last one, but not correct

Is there a sample available

codefunction(value, areaselectmenu) {
var areaselectmenu = element.val();
var areaselectmenu = Apperyio("areaselectmenu").val();

return '{"$and": [{"category": "'+category+'"}]}';

}/code

thanks

hi Evgene,
any chance for a clue here or a sample of how to address this issue,

if I only needed the value of selectmenu I can do that,

but this is trying to ensure the correct column is queried for the selectmenu value, without knowing which item has been selected from the selectmenu

cheers

Hello Michael,

Could you please try to change
prevar areaselectmenu = Apperyio("areaselectmenu").val();/pre
with
prevar areaselectmenu = Apperyio(areaselectmenu).val();/pre

hanks for that,
i tried that and got errors 1 and 2

below is the screenshot

errror 1, missing name in function declaration
errror 2, 'areaselectmenu is already defined'

Hi Michael,

Here is a code without these errors:

pre

function someFunctionName(value, element) {
var areaselectmenu = element.val();
areaselectmenu = Apperyio("areaselectmenu").val();

return '{"$and": [{"category": "'+category+'"}]}'; 

}

/pre

Regards.

thanks Yurii

Hi Maryna
I have used Yurii code and the service runs, but it not working correctly.
its returning all collections and not the 2 values on the selectmenu

let me explain,
in the collection there are 5 area columns
westlothian,falkirk,dunfermline,stirling and east_central_scotland(left blank for testing)
the only data in these columns are "y" and "n"
my get service should only return those enteries which have a "y" in the column selected with selectmenu
it seems to be returning everything
if I select east central scotland for example it still returns all listings even though there are no values at all in this column
whatever I select from the selectmenu the results are the same (all records are returned)
the screenshot shows a search for east central scotland and it should return nothing
no errors in console

here are some screenshots

Hi Yurii,
can you look at my last post, I don't Maryna is talking to me