topic TRACE Command in QlikView

TRACE Command

marco_puccetti — Mon, 08 Jun 2015 10:47:40 GMT

Hello I've used the Trace command to trace some statement like this:

trace "YOUTUBE_Media: " & $(vQVSourceBaseUrl)/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId)&query=$(site);

On the log is reported this:

"YOUTUBE_Media: " & http://localhost:5555/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId)&query=$(site)

Why some variables aren't evaluated?

Thanks

Marco

Re: TRACE Command

swuehl — Mon, 08 Jun 2015 16:59:47 GMT

Is this only a logging issue, i.e. have you checked the actual value of the variables?

Which version are you running?

Re: TRACE Command

rwunderlich — Mon, 08 Jun 2015 17:17:08 GMT

I can't recreate the problem of variables not being substituted. Is that the exact trace command you are using?

Note that trace argument is not evaluated an expression, so the quotes and & are not doing anything.

-Rob

Re: TRACE Command

Clever_Anjos — Mon, 08 Jun 2015 17:27:13 GMT

Same issue here

SET vQVSourceBaseUrl=http://localhost:5555;
SET vQVSourceAppId=1234567;
SET site=one site ;


trace YOUTUBE_Media: $(vQVSourceBaseUrl)/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId) &quey $(site);

Re: TRACE Command

swuehl — Mon, 08 Jun 2015 17:59:43 GMT

I am also able to reproduce this issue on two different machines.

Looks like the double slash breaks the dollar sign expansion. Interestingly, if you enclose the URL in single quotes, it's working again.

And it looks like not a TRACE issue, trying to assign the string to a variable also fails.

Re: TRACE Command

Clever_Anjos — Mon, 08 Jun 2015 18:08:25 GMT

SET vQVSourceBaseUrl=http://localhost:5555;
SET vQVSourceAppId=1234567;
SET site=one site ;

LET str = 'YOUTUBE_Media: $(vQVSourceBaseUrl)/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId) &query= $(site)';

trace OOPS : YOUTUBE_Media: $(vQVSourceBaseUrl)/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId)&query= $(site);
trace 'Fine:YOUTUBE_Media: $(vQVSourceBaseUrl)/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId)&query= $(site)';
trace Fine Too:$(str);

SLEEP 5000;

Re: TRACE Command

rwunderlich — Mon, 08 Jun 2015 18:27:24 GMT

It appears "//" is seen as commenting out the rest of the statement when not enclosed in quotes?

Forget what I said about leaving the quotes off TRACE

-Rob

Re: TRACE Command

marco_puccetti — Tue, 09 Jun 2015 07:50:19 GMT

With single quote it should works.

Thanks to all

Marco