Get data

Ask the community
,
1

Bonjour à tous,
Pouvez-vous me dire pourquoi mon code ne fonctionne pas ?
Pas d’erreur, mais pas de résultat.

Hello everyone,
Can you tell me why my code is not working?
No error, but no result.

import wixData from ‘wix-data’ ;
$w . onReady ( function () {
// text box on the page
let NomAuteur = $w ( ‘#nom’ ). text ;
let collection = “Team” ;

wixData . get ( collection , NomAuteur )
. then ( ( results ) => {
if ( results . items . length > 0 ) {
const items = results . items ;
console . log ( items [ 0 ]. title );
} else {
// handle case where no matching items found
console . log ( “longueur < 0” );
}
})
. catch ( ( err ) => {
let errorMsg = err ;
});
});

Thank you for your help

2

Use more your CONSOLE to investigate and analyse the given RESULTS on every STEP of your CODE!

import wixData from 'wix-data';

$w.onReady(function(){
    //Qu'est-ce que dans mon TEXT-BOX?
    console.log("Dans mon TEXT-BOX est: ", $w('#nom').text);
    //commencer ma function....
    myFunction();    
});


function myFunction() {console.log("My-Function running...");
    wixData.get("Team", $w('#nom').text)
    .then((res)=>{console.log(res);
        if (res.items.length > 0) {console.log("Trouver quelque data, tres bien!");
            const items = res.items;  console.log("ITEMS: ", items);
            const firstTitle = items[0].title; console.log(firstTitle);
        } else {console.log("Pas trouver du data! Data n'existe pas!");}
    }).catch((err)=>{console.log("Merde! J'ai un ERREUER!: ",+err);});
}
3

Hello, thank you for your help,
I try this code :
import wixData from ‘wix-data’ ;
$w . onReady ( function () {

// Contenu du champ Nom à rechercher
console . log ( "Clé primaire à rechercher : " , $w ( ‘#nom’ ). text );
myFunction ();
});

function myFunction () { console . log ( “My-Function running…” );
wixData . get ( “Team” , $w ( ‘#nom’ ). text )
. then (( res )=>{ console . log ( res );
if ( res . items . length > 0 ) { console . log ( “Trouver quelque data, tres bien!” );
const items = res . items ; console . log ( "ITEMS: " , items );
const firstTitle = items [ 0 ]. title ; console . log ( firstTitle );
} else { console . log ( “Pas trouver du data! Data n’existe pas!” );}
}). catch (( err )=>{ console . log ( "Merde! J’ai un ERREUR!: " ,+ err );});
}
And I get this result !?

Identifiant à rechercher : Altieri Antoine
My-Function running…
null
Merde! J’ai un ERREUR!: NaN

Je précise que le champ “nom” est bien une clé primaire de la table des données.
I specify that the name field is indeed a primary key in the data table

(“res” et “results” are synonyms?)

4

When I use the code below it’s ok

function myFunction () { console . log ( “My-Function running…” );
wixData . get ( “Team” , $w ( ‘#IdAuteur’ ). text )
. then ( ( results ) => {
let item = results ; //see item below
console . log ( 'Item trouvé = ’ , item );
// console.log('Title trouvé = ',item.title);
// console.log('Website trouvé = ',item.Website);
} )
. catch ( ( err ) => {
let errorMsg = err ;
console . log ( 'Erreur : ’ , errorMsg );
} );
}

Merci encore pour votre aide

5

@lesmirons

(“res” et “results” are synonyms?)

Qui! C’est correct!

Merde! J’ai un ERREUR!: NaN

Ok, le code trouve pas le data.

Do you have a screenshot of an excerpt of your related DATABASE ?
Especialy the

Ce serait mieux, si tu voudrais fait du → SCREENSHOT ← des tous ton → RESULTATS.
Par example… (des resultats ferme)…


…des resultats ouvert…

848×371 48.7 KB

…des articles ouvert des chaques resultats-data…

844×466 24.5 KB

…qu’est-ce que je veux dire?

→ the more informations you give me, the more i can help you.

But wait, you are not working with Item-ID! I was just writing this one…
https://www.wix.com/velo/reference/wix-data/get

The get-Method expects an ID as INPUT. This is why your function did not work.

EXACTEMENT!

function myFunction() {console.log("My-Function running...");
    wixData.get("Team",  $w('#IdAuteur').text)
    .then( (results) => {
        let item = results; //see item below
        console.log('Item trouvé = ',item);
        //  console.log('Title trouvé = ',item.title);
        //  console.log('Website trouvé = ',item.Website);
    })
    .catch( (err) => {
        let errorMsg = err;
        console.log('Erreur : ',errorMsg);
    });
}

You could also do a query and filter for → $w(‘#nom’).text ← (le nom).
But you already have found your solution → on your own ← well done!

6

@russian-dima

Thank you very much for your help

7

Another little help please
Now that I have found my data, I want to display a button linked to the website field which contains a URL. If this field is empty I want to hide the button:
Initially the button is “hidden”

if ( liencv !== null && liencv !== ‘’ ) {
$w ( ‘#btnliencv’ ). show ();
}
else {
$w ( ‘#btnliencv’ ). hide ();
}
But I still see the button?
Whoops ! what is my mistake?

8

instead of …

if(liencv!==null&&liencv!==''){.....

…you also can write this one…

if(!liencv) {.....
9

Ok thank you for this clarification