Table search

Yes @av-promotional . i decide just search in enter but how to show the result in box like below

$w.onReady(function () {
$w(‘#ifullname’).onKeyPress((event)=>{
let key = event.key;
if (key === “Enter” || key === “Tab”) {
$w(‘#ifullname’).blur()
filter()
}
} )

$w(‘#icompetent’).onKeyPress((event)=>{
let key = event.key;
if (key === “Enter” || key === “Tab”) {
$w(‘#icompetent’).blur()
filter()
}
} )

$w(‘#ilocation’).onKeyPress((event)=>{
let key = event.key;
if (key === “Enter” || key === “Tab”) {
$w(‘#ilocation’).blur()
filter()
}
} )

$w(‘#ifullname’).value = null
$w(‘#icompetent’).value = null
$w(‘#ilocation’).value = null
$w(“#dataset1”).refresh()

} )

})

let filter;
export function filter() {
filter = wixData.filter();
if ($w(‘#ifullname’).value !== undefined && $w(‘#ifullname’).value !== null && $w(‘#ifullname’).value !== “”) {
filter = filter.contains(“ifullname”, $w(‘#ifullname’).value);
}
if ($w(‘#icompetent’).value !== undefined && $w(‘#icompetent’).value !== null && $w(‘#icompetent’).value !== “”) {
filter = filter.contains(“icompetent”, $w(‘#icompetent’).value);
}
if ($w(‘#ilocation’).value !== undefined && $w(‘#ilocation’).value !== null && $w(‘#ilocation’).value !== “”) {
filter = filter.contains(“ilocation”, $w(‘#ilocation’).value);
}

$w("#dataset1").setFilter(filter); 

}


import wixData from ‘wix-data’;

export function button1_click(event) {
wixData.query(“data”).eq(“id”, $w(“#input1”).value).find()
.then((result)=>{
$w(“#text1”).text = result.items[0].results;
});
}


import wixData from ‘wix-data’;

export function button58_click(event) {
wixData.query(“competentperson”).eq(“ifullname”, $w(“#input1”).value).find()
.then((result)=>{
$w(“#text1”).text = result.items[0].results;
});
}