Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84597members
353864posts

How to use script on multi select function for insight ?

EcoStruxure IT forum

A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.

DCIM_Support
Picard
Picard
0 Likes
4
228

How to use script on multi select function for insight ?

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)

4 Replies 4
DCIM_Support
Picard
Picard
0 Likes
0
228

Re: How to use script on multi select function for insight ?

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
Picard
Picard
0 Likes
0
228

Re: How to use script on multi select function for insight ?

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
Picard
Picard
0 Likes
0
228

Re: How to use script on multi select function for insight ?

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
Picard
Picard
0 Likes
0
228

🔒 Closed

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