How to use script on multi select function for insight ?

DCIM_Support · ‎2020-07-04

Hello Everyone ,

About our insight tools , we can enable the multi select function , Please refer as below ,

How to use script on multi select function like select * from name in( 'n1' , 'n2' , 'n3') ?

Kindly advise ,thank you.

Best Regards

DCIM_Support · ‎2020-07-04

Hello, I'm keen to dog into your question but this is a very busy time of year for me so I though I'd let you know of my interest but lack of time. Sorry that doesn't help you much. If its not too urgent I can check in next few weeks

Kind regards

Ed

DCIM_Support · ‎2020-07-04

Hello Ed ,

Thank you for kindly response , this case is not too urgent and we are pleasure to see your check when you are available , thank you . : )

DCIM_Support · ‎2020-07-04

Hello Chu Li Wei,

Basically you need to script your data set. What I would do is to add a unique identifier to your query in the data set like this:

select * from table where field in ('SomeUniqueString')

Then in your data set script in the before open option I would add:

this.queryText = this.queryText.replace("SomeUniqueString", params["p_name"].value.join(" ',' "));

This should replace the "SomeUniqueString" string with the multiple values from your parameters and insert them in your query.

If your parameter is of type Integer and not string (p_name indicates its a string), then you need to remove the ' ' from the query and the script.

Hope this helps.

Morten

DCIM_Support · ‎2020-07-04

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.