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. 😆

Has anyone added custom Logbook fields to the ODATA feed?  I can’t see anywhere to do this. ​@Mario.munoz  ​@Thbutler  

For anyone stumbling on this question I raised. I have resolved this issue with the help of our Power BI experts.  All the custom attributes that are created using Logbook are automatically included in the ODATA feed and the data will be present in the dashboard tables after a successful refresh.  You will need to do some Power BI work however to get the custom attributes to appear in the LogItems table (which is what I was wanting to do). if anyone needs more info then reach out.

That is good to know.  We’ve not implemented Logbook yet and was curious how we would pull this data into the reporting.  I’ve made considerable customizations to our Power BI and backend queries.  Is this data stored in existing tables or in new ones?

The logbook data is stored in new tables (outside of Portfolios) and you’ll see them all once you download and open the pbit file that has the logbook tables in addition to the existing dashboard tables.