CODEWITHSUNDEEP
sqlkentico
ADB
ADB

Reputation: 3

Accessing pages field in Kentico database

I have a pages field inside a page called PageDetail that i want to access in the database. When i go to the table PageDetail I can see the column but its always null.

I need to acces these values for an integration.

Thankyou in advance,

Arne

Upvotes: 0

Views: 265

Answers (1)

mnield
mnield

Reputation: 1869

The simplest answer is that Pages field values are not stored on the page types underlying table. They create an ad-hoc relationship name to store the data that you select, so the actual value is stored elsewhere.

If you take a look in the two tables CMS_RelationshipName and CMS_Relationship, you should find the data that you're looking for. If you look at View_CMS_RelationshipJoined, you should be able to work out the query that you need to pull out the data for your integration.

Upvotes: 1

Related Questions