Here i am working on typescript mysql rest api, i am looped values are storing in object.assign.if i console give inside loop data is come but i need inside loop values return to otside function. Here i attachecd my code.
let s = async() => {
return sqlQuery.forEach(async(outer:any)=>{
let k1 = outer.keyword1.replace("[","").replace("]","") ;
let k2 = outer.keyword1.replace("[","").replace("]","") ;
let k3 = outer.keyword1.replace("[","").replace("]","") ;
let k4 = outer.keyword1.replace("[","").replace("]","") ;
let k5 = outer.keyword1.replace("[","").replace("]","") ;
let k6 = outer.keyword1.replace("[","").replace("]","") ;
let k7 = outer.keyword1.replace("[","").replace("]","") ;
var district:any = `select slug from foa_section_content where foa_section_content_id IN (${k1})`;
var comune:any = `select slug from foa_section_content where foa_section_content_id IN (${k2})`;
var professional:any = `select slug from foa_section_content where foa_section_content_id IN (${k3})`;
var branch:any = `select slug from foa_section_content where foa_section_content_id IN (${k4})`;
var employment:any = `select slug from foa_section_content where foa_section_content_id IN (${k5})`;
var position:any = `select slug from foa_section_content where foa_section_content_id IN (${k6})`;
var benefits:any = `select slug from foa_section_content where foa_section_content_id IN (${k7})`;
var [district1]: any = await connection.execute(district) ;
var [comune1]: any = await connection.execute(comune) ;
var [professional1]: any = await connection.execute(professional) ;
var [branch1]: any = await connection.execute(branch) ;
var [employment1]: any = await connection.execute(employment) ;
var [position1]: any = await connection.execute(position) ;
var [benefits1]: any = await connection.execute(benefits) ;
return await Object.assign(outer,{district1},{comune1},{professional1},{branch1},{employment1},{position1},{benefits1})
})
}
var jjj= s();
console.log(jjj);