Hi

I just purchased the 1.1.0 SELECT DYNAMIC CASCADE (http://www.seblod.com/products/2997) and now the free SQL query works but I don't know how I can use the PARENT parameter in the WHERE statement of the  free SQL query.

Can Octopoos give an example please?

thanks

cyril

Hi Cyril,

Here is an example:

Thanks SAba, it's better, thanks !

for a more complex SQL query such as

select CONTENT.id as id, CONTENT.title as text  from #__content AS CONTENT inner join #__cck_store_form_table AS TABLE  TABLE.id = CONTENT.id  where TABLE.linkingfield = [parent]

the PARENT field should be set to linkingfield

now it's working!

thanks for your help

cyril

Thank you, thank you, thank you cyril for this hint!!!! This saved my day! 

This 'manual' query seems to be necessary if your data is in #__content table.

Just notised a missing ON. The following query worked for me:

SELECT c.id AS value, c.title AS text FROM #__content AS c INNER JOIN #__cck_store_form_mytable AS t ON (t.id=c.id) WHERE t.linkingfield = [parent]

Hey, Seblod-Team. Could you add this information on SQL query for #__content to the documentation of the Select Dynamic Cascade Plugin. Please!

Help Please!

I'm just trying to do this with the Dynamic cascading fields: 

 Only one flat table, :  [id] [make] [model] [year] [price]

I want to populate the first field with make, the second with model  (models of the selected make )

I used the following as my for the first (make) field:

SELECT DISTINCT make AS text, make AS value FROM #__cck_store_form_mcars

I could use the construct for the second field (model)  with make as the parent and it works but gives duplicates.

I tried:

SELECT DISTINCT model AS text, model AS value FROM #__cck_store_form_mcars WHERE make=[parent]

for the second, but it did not populate with the models. 

What would be the correct syntax for the free sql statement?

Managed to find a work-around using the Construction method. 

To eliminate duplicates I entered this in the WHERE field:

1 GROUP BY model

The code apparently always adds an "AND" where there is something in the WHERE field.  In order to get around that, I added the "1" (constructs "WHERE  [...] AND 1 ") then used GROUP BY to eliminate the duplicates.  

Hi shoshanaz,

In your SQL query you can modify "WHERE make=[parent]" by "WHERE make = #parent_id#".

Regards,
Mehdi