Here I have created a sql query and I'm using that data into same query transformer to perform some operation on that. But on the reload of page the main Query is taking time that why the transformer throwing "null data read".
can someone guide me on how to ensure that query transformer runs only after data has been from the sql query part.
Thank you
In this case your query channel
called your MainQuery
which is likely too early. Its most likely a dependency issue. I find when there are a number of dependent queries its best to ONLY set your queries to only fire when specifically called. This can be a pain to layout but ensures the best performance and least number of errors.
So figure out which query fires first on page load and set that to fire on page load. And then set your other queries based on the success of the query that provides it data (either via directly or via a transform variable etc.)
So in this case:
- Ensure
MainQuery
is set to :
- In the Query that provides data to
MainQuery
in theSuccess
event add a call toMainQuery
to ensure it only fires AFTER success of the dependent query.
Hope this helps.
1 Like
Hi @Shagun_Agrawal Did you sort out your transformer already? If not, could you share the full code of the transformer?