Link query using javascript

[john_xagiber]

Hi

When creating links with a query condition there is a separat tab which allows you to use javascript.

I have not been able to use this. Could someone post an example of how to specify a "link query" with javascript which returns some values?

Thanks in advance :-)



/John

[tommy]

In the query field specify a variable like $query

In the javascript do one of 2 things:

1: pass the query with return in the javascript and call the script like this

system.vars.$query=scriptlibrary.function(paramete rs);

2: set the variable inside the javascript

system.vars.$query="the query you have built"

[john_xagiber]

Thank you. I have not been able to test this yet.

If I write an sql query in the javascript, e.g. "id>234", which returns many values - will this work and will all the values be displayed in a list for the user?

[tommy]

It should yes.

[john_xagiber]

Hi

Thank you for your help, but I have not been able to accomplish this yet.

Under the javascript tab i have written a query:

var fDevice = new SCFile("device");
var myLogicalName = "ACME Phone 0001";
var sql = "logical.name=\"" + myLogicalName + "\"";

if (fDevice.doSelect(sql) == RC_SUCCESS ) {
system.vars.$query=fDevice;
} else {
system.vars.$query=NULL;
}

But this query does not seem to trigger as the result returned is all devices. If I remove the javascript, the same result is returned.

I have specified query in the "Add Query Column".

Thanks.

/John

[glg]

you're passing the device record to the query, that's not what you want. You want to pass the query you used, so pass the variable sql to $query.

[john_xagiber]

I am struggeling...

I have the following in the javascript section of the link:

var myLogicalName = "ACME Phone 0001";
system.vars.$query="logical.name=\"" + myLogicalName + "\"";

Still all records are returned - it looks like SM does not care about the javascript statement.

Please see attached image.

/John

[tommy]

Try a print statement to see if the javascript is executed.

[john_xagiber]

I have tried with a print statement in both post javascript and in the javascript section, but nothing is printed. Why does not the javascript trigger?