Perspective equipment schedule scheduledEvents style

Ignition
1

Hi, I have an equipment schedule and the scheduledEvents are bound to a SQL query. The events are showing in the schedule as expected, so I am now trying to apply some style to the events.

I have created a style class for each type of event. I assumed that the way to do it would be to add a column named 'style' which contained the path to the required style class. this didn't work. I looked in the documentation and seen that the style requires an object rather than a value.

schedule style
schedule style1245×65 24.8 KB

I have tried a few different ways of doing this, but I can't get it working.

Can anyone point me in the right direction with this please?

Thanks,
Leigh

2

How did you wrote it?

Never tried, but based on component style, I would say:

style = { 'classes': 'yourClass' }
3

Thanks for your reply calimero.

I am running a select query in a script off a button. The query returns the following dataset which is saved to a custom session property, which in turn is bound to the scheduledEvents of the equipment schedule.

image
image1014×492 80.4 KB

I've tried different variations of the text returned in the style column, but none of them work. I get the following error:

15:30:10.537 [Browser Thread: e3dbea70-bdc3-4484-8643-fed213210794] ERROR Perspective.Designer.Workspace - level: LEVEL_ERROR
message: "TypeError: Failed to set an indexed property on \'CSSStyleDeclaration\': Indexed property setter is not supported."
line_number: 125
source: "http://pappapp046-08gb:8088/res/perspective/js/react-dom-16.14.0.js"

Not sure what to try next. I think I have seen something about transforms, but I've never used this before so not sure how that would work either.

4

You are already in style column, so remove "style = " from the value
image

5

I've tried a few different variations, with braces, without, different quotes. None seem to work.

style attempts

I think today, I will remove the style column and have a go at a script transform.

6

Got it done with a script transform. Changing the dataset to json format and adding style based on the value of the label.

def transform(self, value, quality, timestamp):
	#set styles
	daysStyle = {"classes":"calendarEventStyles/dayShift"}
	holidayStyle = {"classes":"calendarEventStyles/holiday"}
	berStyle = {"classes":"calendarEventStyles/bereavement"}
	dbStyle = {"classes":"calendarEventStyles/darkBlue"}
	lbStyle = {"classes":"calendarEventStyles/lightBlue"}
	offWithPayStyle = {"classes":"calendarEventStyles/offWithPay"}
	trainingStyle = {"classes":"calendarEventStyles/training"}
	yellowStyle = {"classes":"calendarEventStyles/yellow"}
	defaultStyle = {"classes":"calendarEventStyles/default"}
	
	# create empty json
	outputJson = []
	
	# loop through dataset rows
	for row in range(value.getRowCount()):
		# define object
		rowObject = {}
		rowStyle = {}
		
		# loop through columns and add to rowObject
		for col in range(value.getColumnCount()):
			colName = value.getColumnName(col)
			colVal = value.getValueAt(row,col)
			rowObject[colName] = colVal
			
			#check value in label column and use it to set style
			if value.getColumnName(col) == 'label':
				if value.getValueAt(row,col) in ("H4","H6","H8","H12","BH"):
					rowStyle = holidayStyle
				elif value.getValueAt(row,col) in ("SC(12-18)","SC(14-18)","SC(14-22)","SC(6-18)"):
					rowStyle = yellowStyle
				elif value.getValueAt(row,col) in ("SC(18-6)","SC(22-2)","SC(22-6)"):
					rowStyle = dbStyle
				elif value.getValueAt(row,col) in ("SC(6-14)","SC(6-12)","SC(6-10)"):
					rowStyle = lbStyle
				elif value.getValueAt(row,col) in ("BER"):
					rowStyle = berStyle
				elif value.getValueAt(row,col) in ("DOP"):
					rowStyle = offWithPayStyle
				elif value.getValueAt(row,col) in ("T/C"):
					rowStyle = trainingStyle
				elif value.getValueAt(row,col) in ("DAYS"):
					rowStyle = daysStyle
				else:
					rowStyle = defaultStyle
			
			# set the style
			rowObject['style'] = rowStyle
			
		#add row to json
		outputJson.append(rowObject)
	
	return outputJson
1 Like