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")
Escaping: Escape characters +-&|!(){}[]^"~*?:\ with \, 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
Jacques Marais
Moderator
2 Questions, 2 Answers
  Active since 19 November 2020
  Last activity 4 years ago

Reputation

59 + 59 this April 5 1

Badges 1

Editor
0 Votes
0 Answers
121 Views
0 Votes 0 Answers 121 Views
I have multiple SQL scripts that need to be executed during deployment. I've packaged them with my app in the "sql-scripts" folder. In my case the order in w...
4 years ago
0 Votes
0 Answers
137 Views
0 Votes 0 Answers 137 Views
Does Helium (DSL) support Jasper sub-reports and if so how do I include a sub-report?
4 years ago
3 Cleaning up my messy map

Sounds like you might be interested in marker clustering. It's easy to enable for your map in the xml. Just set the "markerClustering" attribute to have a value of "enabled".

<map latitudeAttribute="latitude" longituteAttribute="longitude" markerClustering="enabled">
.
.
</map>

The clustering is done by grouping markers located in fixed grids on the map and is implemented using a default Google Map API clusterer.
It is actually described in the official documentation too:
[...

4 years ago
1 Helium SQL Query limit

There's actually a very good reason for the limit.
Whereas selectors page their results from the db ensuring that there are never more than a few records in memory at one time the native SQL does not.
So the native SQL is typically much faster because of that but can have a massive memory footprint if there is no limit on the number of records that are loaded into memory.
Also since Helium is a multi-tenant system (hosting many different apps) if one app causes memory to run out on the se...

4 years ago