Table content

Ask the community
,
1

Hello everyone, I am trying to get the information from the database in order to view it on table and allow user to download a document. So, I used filtering method by acquiring the user email and id from session so as to view rows that is equivalent to user email and id. However, All I can see is empty table. What could be the problem?
Please find below the code:
#tablecontent #downloadtable

// For full API documentation, including code examples, visit http://wix.to/94BuAAs
import wixData from 'wix-data';
import wixUsers from 'wix-users';
import {session} from 'wix-storage';
import {local} from 'wix-storage';
import wixLocation from 'wix-location';

let filteredEmailvle;
let filteredIDvle;
let EmailFilter;
let IDFilter;

$w.onReady(function () {
 //TODO: write your page related code here...
  trans_email();
  EmailFilter = wixData.filter("AttendeeDB").eq("email",filteredEmailvle);
  IDFilter = wixData.filter("AttendeeDB").eq("attendeeId",filteredIDvle);
  $w("#dataset1").onReady(() => 
  {
         console.log(filteredEmailvle, "here is the email being sent to filter");
         console.log(filteredIDvle, "here is the ID being sent to filter");
         $w("#dataset1").setFilter(EmailFilter.and(IDFilter)).then(() => 
         {
 //$w("#dataset1").setFilter(wixData.filter().eq("attendeeId", filteredIDvle)).then(() => 
 //{
         console.log("Dataset is now filtered");
         console.log(filteredEmailvle, "here is the email being sent to filter");
         console.log(filteredIDvle, "here is the ID being sent to filter");
         }).catch( (err) => 
         {   
         console.log(err); 
         });    
      });
  })

export function table1_rowSelect(event, $w)
{
  tableDownload(event, $w);
  $w("#dataset1").refresh();
}

function tableDownload(event, $w)
{
  $w('#table1').onRowSelect(()=>
  {
 let rowData = event.rowData;
  });

  $w("#dataset1").onCurrentIndexChanged(()=>
  {
 let itemData = $w("#dataset1").getCurrentItem();
 let name = itemData.title;
 let file = itemData.file;
 let url = file.split("/")[3];
    wixLocation.to(`https://docs.wixstatic.com/ugd/${url}?dn=${name}.pdf`);
  });
}

export function trans_email(event, $w)
{
 //let Email = session.getItem('userEmail'); //Where result will be a string.
 let transEmailses = session.getItem('transEmail'); //Where result will be a string.
 let transIDses = session.getItem('transID'); //Where result will be a string.
 //let transEmaillcl = local.getItem('transEmail'); //Where result will be a string.
 let filteredEmailses = transEmailses;
 let filteredIDses = transIDses;
 //let filteredEmaillcl = transEmaillcl;
  console.log(filteredEmailses, "here is the email being sent to filter (session)");
  console.log(filteredIDses, "here is the email being sent to filter (session)");
 //console.log(filteredEmaillcl, "here is the email being sent to filter (local)");
  console.log("Dataset is now filtered");
  filteredEmailvle = transEmailses;
  filteredIDvle = transIDses;
  console.log(filteredEmailvle, "here is the email being sent to filter1");
}

export function button3_click(event) {
 //Add your code for this event here:
  session.removeItem("transEmail");
  session.clear();
  session.removeItem("transID");
  session.clear();
  session.removeItem("forgotEmail");
  session.clear();
  session.removeItem("forgotID");
  session.clear();
 //local.removeItem("transEmail");
 //local.clear();
  wixLocation.to(`/login`);
}