Developer forum

Forum » Development » Where to find user-defined fieldvalues for News v2 fieldgroups.

Where to find user-defined fieldvalues for News v2 fieldgroups.

E-mail notifications
Allan Iversen
Reply
Posted on 04/07/2013 12:15:04

Hi,

 

I am looking for the user-defined fieldvalues for News v2 items. I have a set of fieldgroups. I am not able to find these values in either News, CustomField or AccessCustomFieldValue tables.
 

 

- Allan

 


Replies

 
Morten Bengtson
Posted on 05/07/2013 18:10:29
Reply
This post has been marked as an answer

NewsV2 fields and values

  • AccessCustomField table contains the field definitions.
  • AccessCustomFieldRow table contains the values related to each news article (CustomFieldRowItemID).

To get the field values for a specific article (NewsID = 1) you can use this SQL:

SELECT Field.AccessCustomFieldContext Context, Field.AccessCustomFieldSystemName SystemName, FieldValue.CustomFieldRowValue Value 
FROM AccessCustomField Field
JOIN AccessCustomFieldRow FieldValue ON Field.AccessCustomFieldID = FieldValue.CustomFieldRowFieldID AND Field.AccessCustomFieldContext IN ('NewsV2_general','NewsV2_specific')
WHERE FieldValue.CustomFieldRowItemID = 1

 

Votes for this answer: 1

 

You must be logged in to post in the forum