Table search

  1. -------- Certainly you do not insert such characters in the code snippet.
  2. import wixData from ‘wix-data’; Only once at the top of the page
    Try the code below.
    I did not understand what you’re trying to do in this code snippet:
    export function button58_click (event) {
    wixData.query (“competentperson”). eq (“ifullname”, $ w (“# input1”). value) .find ()
    .then ((result) => {
    $ w (“# text1”). text = result.items [0] .results;
    });
    }

import wixData from ‘wix-data’ ;

$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 () 

    } 

}) 

})

let filter1 ;

export function filter ( ) {

filter1  =  wixData . filter (); 

**if**  ( $w ( '#ifullname' ). value  !==  **undefined**  &&  $w ( '#ifullname' ). value  !==  **null**  &&  $w ( '#ifullname' ). value  !==  "" ) { 

    filter1  =  filter1 . contains ( "ifullname" ,  $w ( '#ifullname' ). value ); 

} 

**if**  ( $w ( '#icompetent' ). value  !==  **undefined**  &&  $w ( '#icompetent' ). value  !==  **null**  &&  $w ( '#icompetent' ). value  !==  "" ) { 

    filter1  =  filter1 . contains ( "icompetent" ,  $w ( '#icompetent' ). value ); 

} 

**if**  ( $w ( '#ilocation' ). value  !==  **undefined**  &&  $w ( '#ilocation' ). value  !==  **null**  &&  $w ( '#ilocation' ). value  !==  "" ) { 

    filter1  =  filter1 . contains ( "ilocation" ,  $w ( '#ilocation' ). value ); 

} 

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

}

export function button1_click ( event ) {

wixData . query ( "data" ). eq ( "id" ,  $w ( "#input1" ). value ). find () 

    . then (( result ) => { 

        $w ( "#text1" ). text  =  result . items [ 0 ]. results ; 

    }); 

}
export function button58_click ( event ) {

wixData . query ( "competentperson" ). eq ( "ifullname" ,  $w ( "#input1" ). value ). find () 

    . then (( result ) => { 

        $w ( "#text1" ). text  =  result . items [ 0 ]. results ; 

    }); 

}