How to use Database Select?

0
Dear, I need to check the database rows with values but I don't know how! What I want is: Select * From GuideYou Where (Longitude = "52.0232935" AND Latitude = "4.5784158") OR ShowRoute = "True"
asked
4 answers
1

Select * From Module$GuideYou Where (Longitude = "52.0232935" AND Latitude = "4.5784158") OR ShowRoute = "True"

answered
0

Where can I type it in?

answered
0

Niels, I think perhaps you're just looking to do a database retrieve in a microflow. You want a "Retrieve" activity in your microflow. Select "retrieve from database", then you're looking for the XPath constraints:

[(Longitude = 52.0232935 and Latitude = 4.5784158)
 or ShowRoute
]
answered
0

Eric, isn there not another way to do it? like in a real database standard like MS/Oracle SQL Server?

answered