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
    • Mansi Rao
    • Technical Content Writer
    • Mansi_Rao
    • 2 yrs ago
    • Reported - view

    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
     

    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. 

    Like
Like Follow
  • Status Answered
  • 5 mths agoLast active
  • 2Replies
  • 370Views
  • 5 Following