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
 
← Back to post

Revisions 2

Original
pic
⠿More
Draden Gaffney
30 × 3
Transaction fields
Transaction fields
What field tells you if a transaction is a deposit or a withdrawal? WWhat is the difference between SignedTxnAmount and TxnAmount? What OfxTrnTypes are there? Just credit or debit? ![Screenshot 2023-06-28 at 10.49.50 AM.png](https://community.q2developer.com/upload/files/1687974640684_Screenshot%202023-06-28%20at%2010.49.50%20AM.png)
What field tells you if a transaction is a deposit or a withdrawal? WWhat is the difference between SignedTxnAmount and TxnAmount? What OfxTrnTypes are there? Just credit or debit? Also what do the numbers 14633 and 1042 represent in the reponse for getHistory https://docs.q2api.com/docs/q2-caliper-api/c8d410579d01e-get-history? ![Screenshot 2023-06-28 at 10.49.50 AM.png](https://community.q2developer.com/upload/files/1687974640684_Screenshot%202023-06-28%20at%2010.49.50%20AM.png) ![Screenshot 2023-06-28 at 3.13.31 PM.png](https://community.q2developer.com/upload/files/1584986590881517568_Screenshot%202023-06-28%20at%203.13.31%20PM.png)
#
#
3 years ago
pic
⠿More
Draden Gaffney
30 × 3
Transaction fields
What field tells you if a transaction is a deposit or a withdrawal? WWhat is the difference between SignedTxnAmount and TxnAmount? What OfxTrnTypes are there? Just credit or debit? Also what do the numbers 14633 and 1042 represent in the reponse for getHistory https://docs.q2api.com/docs/q2-caliper-api/c8d410579d01e-get-history? ![Screenshot 2023-06-28 at 10.49.50 AM.png](https://community.q2developer.com/upload/files/1687974640684_Screenshot%202023-06-28%20at%2010.49.50%20AM.png) ![Screenshot 2023-06-28 at 3.13.31 PM.png](https://community.q2developer.com/upload/files/1584986590881517568_Screenshot%202023-06-28%20at%203.13.31%20PM.png)
#