package requestservice

const (
	getEdgeOSVersionQuery = `
	SELECT value FROM watched_field_objects
	INNER JOIN watched_field_values
		ON watched_field_values.object_id = watched_field_objects.object_id
	INNER JOIN terminals
		ON watched_field_objects.cluster_edge_id = terminals.cluster_edge_id
	WHERE watched_field_objects.cluster_edge_id = $1
		AND kind = 'Node'
		AND terminals.terminal_id = $2
		AND jsonpath = '$.metadata.labels["feature.node.kubernetes.io/ien-version"]'
		AND deleted IS NOT true
	ORDER BY watched_at DESC
	LIMIT 1
	;`
)