How do I construct my desired query?

Jazeppi
Jazeppi 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

  • GrantSmith
    GrantSmith 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:

    domo.get(metadataQuery, {format: 'array-of-arrays' }).then(function proces_metadata(metadata) {
  fields1 = metadata.columns
  …
  domo.get(query1).then(…)
}

)
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith 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:

    domo.get(metadataQuery, {format: 'array-of-arrays' }).then(function proces_metadata(metadata) {
  fields1 = metadata.columns
  …
  domo.get(query1).then(…)
}

)
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories