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