filtering a foundset - basics

Classic Servoy
1

have a table with one column that needs to be used to identify to show the data on the form.
columX has several values (OK, DE, Start, null)
I want the form to display only those records where columnX = OK and not display the others.

I have a global variable vm = ‘OK’
and have it in a relationship where it links to columnX

function showList(){	
        var validMeds = databaseManager.convertFoundSet(foundset,foundset.valid_medications);
	controller.loadRecords(databaseManager.convertToDataSet(validMeds,['medication_id']));
	foundset.sort('medication asc')
	forms.medicationsGrid.foundset.loadRecords(databaseManager.convertToDataSet(validMeds,['medication_id']));
	forms.medicationsGrid.foundset.sort('medication asc');

        elements.tabs.tabIndex=1;
}

I may be making this harder than is needs to be so any hints are appreciated.
Thanks,
Bob

2

Thank you all for the replies to this - I figured I would post the fix here so anyone else that runs across it will be able to see how to correct it also.

foundset.addFoundSetFilterParam('dataprovider','operator','value',''[nameoptional)')