How do I call a method in sync inside a query? I tried multiple ways to get to run in sync, it is not working.
When I run getEvent I see:
#: 13
EventOrders #0: custom-53e9b71b9d2625f9, R1
getFldNm: custom-53e9b71b9d2625f9
EventOrders #1: email, TEST@yahoo.com
getFldNm: email
EventOrders #2: custom, G1
– for all entries
I do not see output from second method.
I tried calling two ways, gives same result:
getCusFldNm ( inpNm );
getFldNm ( inpNm )
Here is the code:
export function getEvent ( eventId )
{
wixData . query ( “EventOrders” ). eq ( “eventId” , eventId ). find (). then ( ( ordRes ) => {
console . log ( "#: " + ordRes . length );
if ( ordRes . items . length > 0 ) {
for ( var i = 0 ; i < ordRes . items . length ; i ++)
{
var inpNm = ordRes . items [ i ]. inputName ;
console . log ( “EventOrders #” + i + ": " + inpNm + ", " + ordRes . items [ i ]. inputValue );
//Directly call a method
getCusFldNm ( inpNm );
//Use promise
getFldNm ( inpNm ). then ( ( fieldNm ) => {
console . log ( "inpNm " + fieldNm );
}). catch ( ( error ) => {
let errorMsg = error . message ;
let code = error . code ;
insertLog ( "calling getFldNm error: " + errorMsg );
} );
}
}
} )
. **catch** ( ( error ) => {
**let** errorMsg = error . message ;
**let** code = error . code ;
insertLog ( "wixData.res query error: " + errorMsg );
} );
}
export function getCusFldNm ( inpNm )
{
console . log ( “getFldNm: " + inpNm );
wixData . query ( “EventCustomFields” ). eq ( “fieldId” , inpNm ). find (). then ( ( res ) => {
console . log ( " From query EventCustomFields” );
if ( res . items . length > 0 ) {
for ( var i = 0 ; i < res . items . length ; i ++)
{
console . log ( " getFldNm #" + i + ": " + res . items [ i ]. title );
}
}
**else** {
console . log ( " Could not find EventCustomFields for " + inpNm );
}
} ). **catch** ( ( error ) => {
**let** errorMsg = error . message ;
**let** code = error . code ;
} );
}
let getFldNm = function ( inpNm )
{
return new Promise ( function ( resolve , reject )
{
console . log ( “getFldNm: " + inpNm );
wixData . query ( “EventCustomFields” ). eq ( “fieldId” , inpNm ). find (). then ( ( res ) => {
console . log ( " From query EventCustomFields” );
if ( res . items . length > 0 ) {
for ( var i = 0 ; i < res . items . length ; i ++)
{
console . log ( " getFldNm #" + i + ": " + res . items [ i ]. title );
resolve ( res . items [ i ]. title );
}
}
**else** {
console . log ( " Could not find EventCustomFields for " + inpNm );
resolve ( "Not Found" );
}
} ). **catch** ( ( error ) => {
**let** errorMsg = error . message ;
**let** code = error . code ;
reject ( "EventCustomFields query error: " + errorMsg );
} );
});
}