How to add a CUSTOM field to the ODATA stream

Would it make more sense to add it to the Project Assessment Dimension?  That dimension contains the Overall Status details.  We have some custom fields for status reports and that is where we added them

I have added a custom long text field to my Project Dimension and it is is similar to this one.

,(select STRING_AGG(CONVERT(NVARCHAR(max),line_text), '') within group (order by isnull(line_number, 1) asc)
from ip.long_text
where key1 = 'overall_stat_comm' and key2 = pv.ppl_code) as [Overall Status Commentary]

What error do you receive?

Thanks ​@Mario.munoz . that worked when I added it to the Project Assessment Dimension.  I agree with ​@Thbutler that this makes more sense but not sure why it didn’t work for the Project Dimension. Also, the only change I had to make was to add the underscores Overall_Status_Commentary

Cheers

Ok, I’m back again. this time I’m trying to add a CUSTOM long_text field to CRI Dimension in the ODATA feed.

I’ve tried this sql (copied from an existing line), with no success:

, (select ip.pfn_grs_scrub_nvarchar_html(line_text)

  from ip.long_text

  where key2=cri.cri_code and key1='issue_comments' and isNull(line_number, 1)=1) as [Issue_Comments]

When I test the query I get the message:

Conversion failed when converting date and/or time from character string.

Any assistance from a non-beginner would be appreciated.

thanks ​@Mario.munoz I was not going to work that by myself in a million years. 😆