[SOLVED] TV - Multi-select documents from a container

Not sure how i should go about this - I want to have a listbox that generates all the document titles from a specified document container

for instance, if you could have a document that contains x number of items that are selected from a list where all the items belong to a container

i tried @Chunk dittoCall_chk , and from the chunk tried a ditto call that would return [+title+]==[+id+] || - but no luck. bit lost now!

There is a snippet in the repository that does this: http://modxcms.com/DropDownTree-1669.html

You could also do this with ditto but you would need to run the ditto snippet using the runSnippet() api and the @eval binder (like described in the snippet above). Or I think you could also use the @select binder and run a query.

cheers for the reply dev i might have a look at that snippet, but i managed to solve this using a simple SELECT query in the input option values:



a pretty n00b topic in the first place hehe. hopefully this’ll help some other n00bs

The @SELECT binding solution you described should work perfectly provided that your document tree doesn’t go any deeper. Are there any directories (i.e. containers) that have 6 as a parent? If so, do they need to show up in your list? If that were a strong concern, you could write a more complicated SELECT query to go deeper down the tree... that’d probably end up joining the table onto itself, and man, that stuff makes my head hurt. I think you found an elegant and functional solution.

for what i need to do, one level deep is perfect.. but im dreading a future project where ill have to deal with something more complex! im sure its possible.. ive just got to study up on my mysql queries

A few sources of MySQL tutorials...

http://sqlcourse2.com/
http://www.databasejournal.com/features/article.php/3593441
http://www.avengex.com/tutorials/category/1/PHP+and+MySQL/

nice one, cheers susan

How would I exclude the current parent from the query results?

Quote from: dev_cw at Aug 18, 2008, 05:54 AM

How would I exclude the current parent from the query results?

current parent being, say 6 like in my example? well if the query is looking for all documents with a parent of 6, then 6 itself wont be included in the results. though maybe im misunderstanding your question

If I generate this menu on a child page, and want to generate a list of documents that are in the same level as the current parent. If I run the query as-is I get all the parents including the current one.

-1
-2
--Child of 2 <- You are here <-
-3
-4

The options should only be 1,3,4 and 2, which is the current parent, should be excluded.