Direct database query does not consider the current data source (queries live data in test).

MattLaro

Here I have a table with the following column "process_url_header_list", which is a list of object defined by a field key and a field value, like so :

If I fetch the row via Query all function, I get the content of "process_url_header_list", like so :

However, even using the wizard, if I do a direct query on that same column in the same environment, it returns an empty array.

I'm pretty positive this is a bug :). Any thoughts ?

NOTE : I also tried querying explicitly the column name and it gives the same result. I discovered this after writing a complex query.

MattLaro

I changed the title because I found out the problem.

I tried to change the data type of the field and still nothing showed in my query to my surprise

Thinking outside the box and remembering that both my live and test data had identical data.

1. I switched to live data.

2. I filled the field with some data in live data.

3. I switched to test data.

4. I returned to my function and run the query.

5.
Unexpected result : I saw data from my live datasource.
Expected result : Seeing data from my test datasource.