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 3

Unable to connect to sandbox DB
Unable to connect to sandbox DB
Hello, I'm trying to connect to my sandbox DB. In vscode I run the following command in the terminal... is that the right place? and am able to login successfully ``` ssh sdk-shared-dev.q2devstack.com -l dradeng@finitloyalty.com -L 1433:localhost:1433 ``` When I go to add the connection though I get the following warning and when I click on Trust Enable Server it then tells me it is unable to connect. If I just hit cancel as well the connection fails ![Screenshot 2023-06-27 at 6.44.14 PM.png](https://community.q2developer.com/upload/files/1687916773478_Screenshot%202023-06-27%20at%206.44.14%20PM.png) ![Screenshot 2023-06-27 at 6.44.01 PM.png](https://community.q2developer.com/upload/files/1687916773475_Screenshot%202023-06-27%20at%206.44.01%20PM.png) I put in the following info: localhost,1433 Q2DB_sdk_finitloyalty Then select SQL login dradeng@finitloyalty.com ****** for my password
Hello, I'm trying to connect to my sandbox DB. In vscode I run the following command in the terminal... is that the right place? and am able to login successfully ``` ssh sdk-shared-dev.q2devstack.com -l dradeng@finitloyalty.com -L 1433:localhost:1433 ``` When I go to add the connection though I get the following warning and when I click on Trust Enable Server it then tells me it is unable to connect. If I just hit cancel as well the connection fails I put in the following info: localhost,1433 Q2DB_sdk_finitloyalty Then select SQL login dradeng@finitloyalty.com ****** for my password (https://community.q2developer.com/upload/files/1687916773475_Screenshot%202023-06-27%20at%206.44.01%20PM.png) ![Screenshot 2023-06-27 at 6.44.14 PM.png](https://community.q2developer.com/upload/files/1687916773478_Screenshot%202023-06-27%20at%206.44.14%20PM.png) ![Screenshot 2023-06-27 at 6.44.01 PM.png]
#
#
Hello, I'm trying to connect to my sandbox DB. In vscode I run the following command in the terminal... is that the right place? and am able to login successfully ``` ssh sdk-shared-dev.q2devstack.com -l dradeng@finitloyalty.com -L 1433:localhost:1433 ``` When I go to add the connection though I get the following warning and when I click on Trust Enable Server it then tells me it is unable to connect. If I just hit cancel as well the connection fails I put in the following info: localhost,1433 Q2DB_sdk_finitloyalty Then select SQL login dradeng@finitloyalty.com ****** for my password (https://community.q2developer.com/upload/files/1687916773475_Screenshot%202023-06-27%20at%206.44.01%20PM.png) ![Screenshot 2023-06-27 at 6.44.14 PM.png](https://community.q2developer.com/upload/files/1687916773478_Screenshot%202023-06-27%20at%206.44.14%20PM.png) ![Screenshot 2023-06-27 at 6.44.01 PM.png]
Hello, I'm trying to connect to my sandbox DB. In vscode I run the following command in the terminal... is that the right place? and am able to login successfully ``` ssh sdk-shared-dev.q2devstack.com -l dradeng@finitloyalty.com -L 1433:localhost:1433 ``` When I go to add the connection though I get the following warning and when I click on Trust Enable Server it then tells me it is unable to connect. If I just hit cancel as well the connection fails I put in the following info: localhost,1433 Q2DB_sdk_finitloyalty Then select SQL login dradeng@finitloyalty.com ****** for my password ![Screenshot 2023-06-27 at 6.44.01 PM.png](https://community.q2developer.com/upload/files/1687916773475_Screenshot%202023-06-27%20at%206.44.01%20PM.png) ![Screenshot 2023-06-27 at 6.44.14 PM.png](https://community.q2developer.com/upload/files/1687916773478_Screenshot%202023-06-27%20at%206.44.14%20PM.png)
Unable to connect to sandbox DB

Hello, I'm trying to connect to my sandbox DB. In vscode I run the following command in the terminal... is that the right place? and am able to login successfully ``` ssh sdk-shared-dev.q2devstack.com -l dradeng@finitloyalty.com -L 1433:localhost:1433 ``` When I go to add the connection though I get the following warning and when I click on Trust Enable Server it then tells me it is unable to connect. If I just hit cancel as well the connection fails I put in the following info: localhost,1433 Q2DB_sdk_finitloyalty Then select SQL login dradeng@finitloyalty.com ****** for my password ![Screenshot 2023-06-27 at 6.44.01 PM.png](https://community.q2developer.com/upload/files/1687916773475_Screenshot%202023-06-27%20at%206.44.01%20PM.png) ![Screenshot 2023-06-27 at 6.44.14 PM.png](https://community.q2developer.com/upload/files/1687916773478_Screenshot%202023-06-27%20at%206.44.14%20PM.png)
#