Can anyone help me work out how to get the data from a content picker document type in SQL?
I have a document type with alias Class and a document type with alias ClassTime.
ClassTime has a content picker that allows you to select a Class document type.
In SQL I can find the ClassTime data but how do I join the Class data into this? I thought I could maybe use the GUID for the ClassTime document type but I haven't had much success.
Getting nested content datatype content from SQL
Can anyone help me work out how to get the data from a content picker document type in SQL?
I have a document type with alias Class and a document type with alias ClassTime.
ClassTime has a content picker that allows you to select a Class document type.
In SQL I can find the ClassTime data but how do I join the Class data into this? I thought I could maybe use the GUID for the ClassTime document type but I haven't had much success.
I'm on Umbraco v8.10.3
Thanks!
is working on a reply...