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
 
Answered
Best way to find data?

I am looking to find a bunch of data within the SDK and I find it a bit hard to find it in the dev environment since the data there is watered down. I'm considering creating a Sandbox extension for myself and pushing that to our Staging environment (that obviously never gets pushed to Prod) so I can just test things out to see what I can find.

I just want to see if anyone has any better suggestions? I know there is documentation, but sometimes I don't know how Q2 field names relate to what I'm being asked and it's easier to just see real data.

Thanks in advance,

  • Lisa
Posted 5 years ago
Votes Newest

Answers


Lisa, while your workflow is ceratinly doable, it seems like it would be helpful if we spent some time showing you around your DB in your test environment and working with you to identify some data.

If you would like to shoot me an email (greg.varnell@q2ebanking.com) we can get some time setup this afternoon or early next week.

Posted 5 years ago
144 Views
1 Answer
5 years ago
5 years ago
Tags