I`m using DB Import based on the guide and I could get the values from fields whose type are numeric. However, when I tried to query string fields, I could not find correct “Channel Type” in “Input channels” page. The “Format” column could be assigned “ASCII TEXT”,but it seems only a few characters is obtained, not the whole string value.
Is there any ways to achieve this purporse?
Another problem is bothering me.
I am trying to query a batch of values from mysql.
For example,In “The Data Retrieval page”,I am using the sql statement, something like this “select id from table”. Actually this statement would get a result set,but only the first record is shown, the following records are missing.
I figure out this could be solved if more devices are configured,with specified sql statements are written. But this does not seem elegant,somehow