Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
 
Unanswered
← Loan-Payments example not working

It appears that the dbplan did not get run. It is possible that it is either not picking up everything quite correctly, or you just need to run q2 run_db_plan.

0
Posted 4 years ago
pic
⠿More
Trey Teter
124 × 2 Administrator
0

I tried running q2 run_db_plan but I'm still getting the same error.

— David Maksimov   4 years ago
0

Are you getting an error when you run q2 run_db_plan. I have been trying to figure out what exactly you are doing wrong.

— Trey Teter   4 years ago
0

Everything is fine when I run q2 run_db_plan and go through all the setup. The error shows up when I run q2 run and try to load the extension in the sandbox dashboard

— David Maksimov   4 years ago
0

Hmm, the error specifically says that the Stored Procedure isn't installed in the database. That doesn't get installed by default. So either the dbplan is missing something or the CLI command you are running isn't picking it up properly.

— Trey Teter   4 years ago
0

It looks like it might be missing altogether.

— Trey Teter   4 years ago
Show more results postcomments
Report
60 Views
0 Answers
4 years ago
4 years ago