Trend color is stored in Editordisplay column in standard displays table. For reference you can check view_displays view in PI Vision display for information related to displays where trend color is applied.TraceSettings for trend in Editor display column tell you about the colour used in the trend. Would recommend to query only in development region by restoring production database .
Note : Not recommend update on SQL database directly but you can query view_displays to understand where different colours are used in trend.
Lal Babu Shaik,
I can't find the value for the tracesettings anywhere. Where in the database structure is the setting? I've looked under tables and views but I can't find anything. I'm looking in the PIVISION database - is that the correct place?? Can you give me a route to the setting e.g. PIVISION -> Tables -> dbo.xxxxxx so I can get to the correct setting?
Let me explain with an example :
Dragged and dropped 4 attributes by selecting trend :
Using StandardDisplays Table : Filtered using display id.
Editor Display column text : TraceSettings property
Modified sinuoid colors in the trend : (Red and Green)
Editor Display column text :
View Details : view_displays
Thanks for the example. Where are the default colours set/stored? I noticed that in the first SQL result you get TraceSettings:Null, but in the second result you get the colours, so I assume that there are default colours which are set somewhere.
Perfect! - just what I was looking for. Thanks for all the help