How to use script on multi select function for insight ?

[DCIM_Support]

This question was originally posted on DCIM Support by Chu Li Wei on 2017-12-18

---

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

(CID:126882940)

[DCIM_Support]

This comment was originally posted on DCIM Support by Ed Tarento on 2017-12-21

---

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

(CID:126884365)

[DCIM_Support]

This comment was originally posted on DCIM Support by Chu Li Wei on 2017-12-21

---

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 . : )

(CID:126884412)

[DCIM_Support]

This answer was originally posted on DCIM Support by Morten Harboe on 2018-01-02

---

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

(CID:126886472)

[DCIM_Support]

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