Making custom SQL queries to the Contour database tables?
Hi!
Today I wanted to get a list of all the distinct values of a certain field in my contour database. When I opened up the Umbraco database in SQL Server Management Studio, the table structure was a bit too complex for me to understand how to write my SQL query.
What I wanted to do was something along the lines of:
SELECT DISTINCT formFieldName FROM formTable
Is there a database diagram that shows how the Umbraco Contour tables are connected? Any other tools/resources that could help me if I wanted to make custom queries? If not, I could always export the data to Excel and try to do my data queries there, but I was hoping I could skip that extra step.
Making custom SQL queries to the Contour database tables?
Hi!
Today I wanted to get a list of all the distinct values of a certain field in my contour database. When I opened up the Umbraco database in SQL Server Management Studio, the table structure was a bit too complex for me to understand how to write my SQL query.
What I wanted to do was something along the lines of:
SELECT DISTINCT formFieldName FROM formTable
Is there a database diagram that shows how the Umbraco Contour tables are connected? Any other tools/resources that could help me if I wanted to make custom queries? If not, I could always export the data to Excel and try to do my data queries there, but I was hoping I could skip that extra step.
Thanks in advance!
/Thomas
is working on a reply...