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
 
Profile picture
Ash Mitchell
Moderator
0 Questions, 2 Answers
Active since 23 December 2025
  Last activity 5 months ago

Reputation

50

Badges 1

  Disciplined
0 Missing Navigation Nodes

Hi Jenny,

As confirmed with Paden Rose, after aproximately release v2.277 of the SDK, navigation nodes in your sandbox environment work as follows:

ParentNavigationNodeID in the Q2_NavigationNode table determines where a node appears in the heirarchy of the navigation tree. This means that if ParentNavigationNodeID is Null it will appear as a top level node.

Next, the Route attribute also in the Q2_NavigationNode table is what determines where that navigation node routes to.

  • If ...
9 months ago
2 Is there a table i can use instead of a vault to store a small-sized json data?

Happy New Year!

For your use case (small, not user specific, non-sensitive data, changes 1-2x/year), I might recommended WEDGE_ADDRESS_CONFIGS.

WEDGE_ADDRESS_CONFIGS stores configuration data in the Q2 database (WedgeAddress table) and is specifically designed for configuration data that may change occasionally. You can define default values in your extension code, and then update them later via the Configuration Editor on Q2Developer.com (available under Self Service) without requirin...

9 months ago