Run Queries Sequentially

Is there a way to run queries sequentially within one report?

For example, I'd like query A to run and complete before query B begins, both with the same Mode report, XYZ. 

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • If your question is related to SQL, then you can try this way..

    Sub RunMyQueryies()

    currentdb.execute "MyFIrstQueryNameHEre"
    currentdb.execute "MySecondQueryNameHEre"
    currentdb.execute "MyThridQueryNameHEre"
    'ect....

    End sub
     

    Reply Like
  • Hello Kace Layton

    We don't currently have a way to serialize queries runs from Mode's side. When a report is run, whether scheduled or manually, all the queries get executed simultaneously. 

    I've passed along this feedback to our Product team and will reach back out if this functionality becomes available in Mode. 

    Reply Like
Like Follow
  • Status Answered
  • 2 wk agoLast active
  • 2Replies
  • 346Views
  • 4 Following