Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
14 days ago
Solved

Query giving values of zero

What's wrong with this query format. I have checked all the values and I should be getting values other than zero.

SumValues(GetRecords("{80.EX.'"&[Concate Distance]&"'}and{47.EX.'Shipping'}and {66.XEX.0}",[_DBID_DISTANCES]),66)

 

If I don't have the "and' filters QB gives me the error"Uh-Oh! The way this formula is built will take too long to process. Please try refining your formula."

formula query
  • Denin's avatar
    Denin
    13 days ago

    The API has good performance. You could try the same query in the API and see if you get the results you need then use AI to create a basic code page for that API query. 

    See here: 

    https://developer.quickbase.com/operation/runQuery

     

    You can just fill in the blanks and it will basically make the API query for you under code sample tab. Recommend to use Javascript ES6. 

     

3 Replies

  • Denin's avatar
    Denin
    Qrew Captain
    13 days ago

    In various webinars, I remember it's mentioned how formula queries have issues at scale. How many records do you have?

  • GeorgeBramhall2's avatar
    GeorgeBramhall2
    Qrew Cadet
    13 days ago

    2.6 million records. I guess a query is not the solution here. Unfortunately, I'll to make one more table relationship to add to my spaghetti web all just to retrieve one field value from the remote table.

    • Denin's avatar
      Denin
      Qrew Captain
      13 days ago

      The API has good performance. You could try the same query in the API and see if you get the results you need then use AI to create a basic code page for that API query. 

      See here: 

      https://developer.quickbase.com/operation/runQuery

       

      You can just fill in the blanks and it will basically make the API query for you under code sample tab. Recommend to use Javascript ES6.