Firstly, I have never been able to get even the most simple cross connections to even finish.
Cross Connection query in ONE environment, returns instantly. Join that query to a small table in a 2nd Environment and limit it in the where clause to a SINGLE value and it never returns. I never wait beyond 30 minutes for it to finish that is. End of story for me.
I want to query and retrieve a list of IDs in Environment A and then query by those IDs in Environment B.
I am not able to import data into Production environment B so I can’t create my own tables.
Is there a way using automation to pass a list of values to be used in a query without having to connect outside Environment B?
variables will store only a single value correct?
T.D.P. v4.3 PRO