I am trying to sort some Elements based on the last four digits in the element name, which is also the same as the View.Site ID Property.
Example Element Names:
Priority Controller DB8009 120D 4312
Priority Controller DB8009 120D 4312
Priority Controller DB8008 130D 4000
Priority Controller DB8008 110D 4222
Priority Controller DB8008 120D 3000
Priority Controller DB8009 120D 2000
Priority Controller DB8009 110D 6003
I tried ChildrenSort: Property|View.SiteID, but realised that probably doesn't work because it is a property of the View associated with the Element, not an actual Element Property.
I also tried
ChildrenSort:RegExReplace:(.+D )\d{4},Name,]
This RegexReplace matches anything before the four digit number at the end and replaces it with nothing, hence leaving just the four digit ID for the sort, however I suspect ChildrenSort whilst allowing for Name doesn't allow for a Regex on the Name in this field.
Is there any trickery I am missing to achieve the desired sort, or am I trying to do something beyond what is achievable?
Great use case Sam.
I personally can't think of a way either, save from storing that piece of info somewhere where the childrensort can support it (element property probably). For this you could leverage scripting to make it easier for you to fill out the properties.
Feel free to make a feature suggestion for this if that doesn't work.
Thanks Toon!
That’s nice to know I didn’t miss anything this time and reached the limitations.
I had thought of making fields in the custom properties, but wanted to avoid replicating data into a second field that was already available elsewhere.
I’ll pop a feature suggestion in.