I am starting my first MODx project and trying to "think" in MODx terms. I starting to catch on, slowly.
My project needs less blog tools and more framework. I am creating a community site, to allow people to collaborate and share info. I am afraid to use TV’s and documents, because it may get too large. Would that be a problem? Is there a limit to the number of documents? I am mostly concerned with the admin display taking a long time to render the tree. I would hope to have 1,000’s of participants and each of them sharing a dozen projects with dozens of objects. If I made each "object" a document, and each "project" a document. Each user could hundreds of authored documents.
So I thought it would be best to create a custom table to store the contant outside of the MODx document model. I wanted to display the list in the datagrid widget (which worked great), but I could not make a dynamic url [see below]
@SELECT CONCAT ('<a href="?project=', project_id, '">',name, '</a>') AS projectURL, user_id, name, description FROM `modx_projects` WHERE public = 0
But that query doesn’t seem to work with CONCAT.
I would like to use a much of the standard snippets as possible, because the code is so much better than anything I could cobble together. I tried using Ditto, but I could only get it to work with documents, and not a custom db table. Am I using the right tools for the job? Should I just use a custom snippet for everything? I welcome any suggestions.
