Skip to content

    • Cards, Dashboards, Stories

    Cards, Dashboards, Stories

    How do I construct my desired query?

    Member
    in Cards, Dashboards, Stories

    I am creating a card in DOMO, and I am trying to query from my dataset. I want to query in such a way so that I first query the dataset only for its column names, then I use the column names to query all the data in the dataset. This is what I have so far:

    Query1.png

    I am getting the following error, however: "Uncaught TypeError: Cannot read properties of undefined (reading 'join')
    at <anonymous>:410:56
    at CodeService.ts:90:29" Furthermore, my "console.log(fields1)" statement prints undefined. Does anyone know how I can accomplish my desired query?

    Tagged:

    Best Answer

    • Coach
      Answer ✓

      The issue is that your metadata variable is undefined and you need to handle the Promise. I'd try to do something like:

      1. domo.get(metadataQuery, {format: 'array-of-arrays' }).then(function proces_metadata(metadata) {
      2.   fields1 = metadata.columns
      3.   …
      4.   domo.get(query1).then(…)
      5. }
      6.  
      7. )
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      Answer ✓

      The issue is that your metadata variable is undefined and you need to handle the Promise. I'd try to do something like:

      1. domo.get(metadataQuery, {format: 'array-of-arrays' }).then(function proces_metadata(metadata) {
      2.   fields1 = metadata.columns
      3.   …
      4.   domo.get(query1).then(…)
      5. }
      6.  
      7. )
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories