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
84614members
353913posts

Embedded list format

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

IgorSivakov
Lieutenant
Lieutenant
0 Likes
10
1336

Embedded list format

I have an Embedded List object, wich displays plants names and some addinional data. Is there a way to fix column width and display results in multy-string format? Can I change color of the cell, based on querry results? Can I hide some columns?

10 Replies 10
AdamWoodland
Commander Commander
Commander
0 Likes
9
1331

Re: Embedded list format

I don't believe you can set the column width, but you could probably do some trickery with the header through an alias with a long name or some blank spaces to give it a minimum width.

 

Regarding the colours, details in the help. Check out https://tprojects.schneider-electric.com/GeoSCADAHelp/Geo%20SCADA%202019/Default.htm#ListsGuide/List...

 

For hiding a column, you can alias it to something beginning with an underscore, e.g. SELECT Fullname AS "_F", Name FROM CDBObject ORDER BY "_F" should show one column, the Name. 

IgorSivakov
Lieutenant
Lieutenant
0 Likes
8
1326

Re: Embedded list format

Unfortunately, I need to set maximum widgh, because plants names can be pretty long. I gues, I just have to make my own table, but it will be a pain (especially scroll mechanism).

BevanWeiss
Spock
Spock
0 Likes
0
1293

Re: Embedded list format

This is probably an example of something where a Feature Request is a good idea.

 

The forum where you can propose such features is here:

https://community.exchange.se.com/t5/Geo-SCADA-Expert-Ideas/idb-p/geo-scada-expert-ideas

 

It doesn't guarantee that your request will be implemented, but it gives others the opportunity to 'like' the idea, showing Schneider how much community interest there is in the feature.  That can improve the chances of it being eventually implemented.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
AdamWoodland
Commander Commander
Commander
0 Likes
6
1290

Re: Embedded list format

Can probably use the SUBSTRING function to limit the text length rather than limit the column width, check out https://tprojects.schneider-electric.com/GeoSCADAHelp/Geo%20SCADA%202019/Default.htm#SQLGuide/String... for the details but I would imagine something like (I haven't tested):

 

SELECT SUBSTRING(FullName FROM 1 FOR 20) FROM CDBObject

IgorSivakov
Lieutenant
Lieutenant
0 Likes
5
1280

Re: Embedded list format

This also does not solve my problem. I need to display this names at full lengs. It can be achieved only if multi-string output is possible.

BevanWeiss
Spock
Spock
0 Likes
4
1272

Re: Embedded list format

I'm not sure what you ultimately want here, perhaps you could provide an example image from somewhere matching what you're after...

 

Your first request is that you want to force the column width to be some maximum width.  This would mean all characters beyond this maximum would not be visible.  Since they would not be displayed within the column.

Adam then suggested that you could use SUBSTRING to do the same (to clip the number of characters).  But you say that this isn't suitable, and that you need to see the whole string.  But your original desire (forcing column to be a width less than the length of the string) would also not show you the whole string...

 

Also not sure what you mean by 'multi-string output'.

I can't remember if it works, but you could try to replace the space character with a new line character.. that would give you like a line wrapping (maybe)


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
AdamWoodland
Commander Commander
Commander
0 Likes
0
1269

Re: Embedded list format

A really small font could be what they're after but you can't dynamically control the font size per row/column/cell

 

I don't believe you can do newlines in cells either, for example the NoteText gets made into a single line. Newline in a column header is possible but wouldn't help.

 

As suggested, we're probably going to need to see example data and how you want think it would look best to you.

IgorSivakov
Lieutenant
Lieutenant
0 Likes
2
1263

Re: Embedded list format

Yeah, I should provide an example earlier, sorry for that. So, first image shows what my client demands (on the left side). Fonts big enough to read the text from afar, names displays at full length. As you can see, firs plant has pretty long name. Also you can see my handmade scroll bar, witch works terribly slow. 

Second image - embedded list, wich works perfectly, but it doesn't mach my client demands in part of appearance

disp_1.JPGdisp_2.JPG

BevanWeiss
Spock
Spock
0 Likes
1
1244

Re: Embedded list format

How did you implement the scroll bar?

 

You likely already did this, but Indirect Animations are probably the best way to handle this part.

If you did each row as an embedded mimic then you'd really need to make sure that you had your 'Share with other embedded mimics' configured correctly, and I can't remember off the top of my head the best way to get a per-client animation variable... I think it was to essentially have an object on the mimic that would hold the value.. and then use Mimic.Layer(x).Item(y).Text to reference it... (but it's been a long time since I've done this kind of tricks).

 

I'd definitely still suggest raising the GeoSCADA 'Idea' for embedded lists to support New Line (and potentially fixed column widths and line wrapping).  They would be really good quality of life improvements.

 

You would likely also want to add some ability to customise the per column font  and font style.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
IgorSivakov
Lieutenant
Lieutenant
0 Likes
0
1171

Re: Embedded list format

I used indirect tags. "Scroll" is just a rectangle with animates position and height and serves only to mark current position on list. My solution is quite slow but it does the job.

Thanks for advices and sorry for my poor english )