Thanks!
I am now trying to link all the search menus, so that each search box filters the results in conjunction with one another. I have referred to the links provided by Tal (above) although due to the fact that I’m just starting out with code, I’m having trouble understanding the examples and determining what code is relevant to me and what is not.
Essentially I want to create a job search that works together to refine and filter results from my table. I would like it to filter results such as the example below. Any help would be much appreciated! I’ve spent so much time on this so far!
I have named my elements as follows:-
Search bar = ‘#input1’
Location drop down = ‘#location1’
Classification drop down = ‘#classification’
Table = ‘#table1’
Dataset = ‘#dataset2’
Database = ‘careers’
So far my search bar and drop downs work independently of one another. Can anyone show me where I am going wrong? Many thanks!!!
My code so far is :-
import wixData from ‘wix-data’;
$w.onReady(function () {
//TODO: import wixData from ‘wix-data’;
});
export function input1_keyPress_1() {
wixData.query(‘careers’)
.contains(‘title’, $w(‘#input1’).value)
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
});
}
export function location1_change_1(event, $w) {
wixData.query(‘careers’)
.contains(‘location’, $w(‘#location1’).value)
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
$w(‘#table1’).show();
});
}
export function input1_viewportEnter(event, $w) {
wixData.query(‘careers’)
.contains(‘location’, $w(‘#location1’).value)
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
$w(‘#table1’).show();
});
}
export function classification_change() {
wixData.query(‘careers’)
.contains(‘category’, $w(‘#classification’).value)
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
$w(‘#table1’).show();
});
}