Hello, I wonder how to put space with letter for column name on custom report. (i.e. Business Owner, not Business_owner)
Could you please help me to solve the problem? I put my query on the board.
select
obj.Name as Name,
bo.Value as "Business_Owner",
boe.Value as "Business_Owner_Email",
comp.Value as "Component",
ces.Value as "Core_Enterprise_Shared"
from
t_object obj
inner join
t_objectproperties bo
on
(obj.Object_ID = bo.Object_ID
and
bo.Property = 'Business Owner')
inner join
t_objectproperties boe
on
(obj.Object_ID = boe.Object_ID
and
boe.Property = 'Business Owner Email')
inner join
t_objectproperties comp
on
(obj.Object_ID = comp.Object_ID
and
comp.Property = 'Component')
inner join
t_objectproperties ces
on
(obj.Object_ID = ces.Object_ID
and
ces.Property = 'Core / Enterprise Shared')
