I'm using the MSSQL Coreflux asset to do a Select instruction but I'm not getting the correct results. I'm following the Coreflux documentation https://docs.coreflux.org/flux-assets/connectors/ms_sql/#tags and I can't find a Select instruction example.
The first issue is I'm doing a basic query "SELECT Fastlane FROM FastLaneRef WHERE BarcodeID = 1234567890" where I expect to get a int value on the FeedbackTopic but it allways returns an empty value.
Steps to Reproduce 🔄
Create the dataBase and Install the MSSQL Asset
Put some data in the Dtabase
do a Select instruction to return only one specific value
Expected Behavior ✅
When doing a Select instruction I would expect to have in the specified topic the correspondent value from the data base
Bug Description 🐞
I'm using the MSSQL Coreflux asset to do a Select instruction but I'm not getting the correct results. I'm following the Coreflux documentation https://docs.coreflux.org/flux-assets/connectors/ms_sql/#tags and I can't find a Select instruction example. The first issue is I'm doing a basic query "SELECT Fastlane FROM FastLaneRef WHERE BarcodeID = 1234567890" where I expect to get a int value on the FeedbackTopic but it allways returns an empty value.
Steps to Reproduce 🔄
Expected Behavior ✅
When doing a Select instruction I would expect to have in the specified topic the correspondent value from the data base
Environment 🌐
Windows 10
Asset Type 🧩
MS SQL
Additional Information ➕
No response
Terms of Service