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.
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
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 . : )
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.
Discuss challenges in energy and automation with 30,000+ experts and peers.
Find answers in 10,000+ support articles to help solve your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!