1
Bugs and Issues / Re: Generate Document Unicode-encodes Umlauts but only in Requirement-Notes-Fields
« on: October 17, 2024, 11:34:32 pm »
Thank you alot! Thats it. Works.

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
select CASE
WHEN id.value is null THEN '--'
ELSE id.value END as reqid, req.note as reqnote, req.name as reqname
from (((t_object as uc
left join t_connector as rcon on rcon.Connector_Type ='realisation' and rcon.end_object_id = uc.object_id)
inner join t_object as req on req.object_id = rcon.start_object_id)
left join t_objectproperties as id on id.object_id = req.object_id and id.property ='Customer_UID')
where uc.object_type = 'usecase'
and uc.object_id = #OBJECTID#
order by reqid desc