Dynamic Cascade

9 Posts
dodenau
11 years ago
2
Topic

Hello seb-team,
some questions:
1. In your example at step three, shouldn't it read table: cities instead of counties?
2. My use-case, and I predict many others too, needs to have a DISTINCT list in the name List. I use the SQL-Query for that. It would be nice, if there were a check-up for that in the Construction area too.
3. Is it necessary to have different tables for the D. Cascade? Then I would alter the db-structure. I can't get it to work yet, if the fields are located in the same table.
Regards
Hans-Georg

Get a VIP membership
11 years ago
1
Level 1

Hello dodenau,

thank for your comment.


1. you have good eyes! thank, it's corrected

2. I advise you to post your request in the tracker, please.

3. No, it was simply for the example. For a new example, you can work only with the Joomla categories table for all select or any other table. You simply have to make the good request.


Best regards.

Lionel

9 Posts
dodenau
11 years ago
0
Level 2

Thank you Lionel,
but after trying the whole weekend to get it to work, I couldn't...
Given: Only one table (#__cck_store_form_kfz3); in it: id, brand, model, and of course other fields
In that table: field "brand" has not unique values and field "model" has not unique values too.
All I could get was under "construction mode": Start: OName=brand; OValue=id 
and End: OName=model; OValue=id; Parent=id
a select in the search form with multiple entries of the same brand and the associated model to that brand record I choose out of the list of same entries.
That's of course not what I needed but even there, I got no result of the search, saying "There is no result".
Question one: This Dynamic Cascade is Part of a "Select-Dynamic" which gathered after the cascade other Select-Simples to find the proper selection. Is this possible (using CCK(Select-Dynamic) of core as first field)? Or is the Cascade only working alone?
Question two: With free Query: 
SELECT DISTINCT brand AS text
FROM #__cck_store_form_kfz3
ORDER BY brand ASC; 
and OValue=id
I get a unique list of brands but loosing the chain to field "model".
I think, I have tried all the combinations by try and error changing ON, OV and Parent with no better result.  
Regards
Hans-Georg


Get a VIP membership