116 Posts
nycxav
10 years ago
8
Topic

Hi, 

I have purchased the Select Dynamic Cascade and configured it. There are only two lists, one "start" and one "end".

The start is based on categories and I use title and id as name and value. 

The end is based on categories too and I use access as both name a value and id as parent.

This is then stored as article access.

The goal is to assign the same access level to the article as the category that is assigned to it.

I managed to get it to work in the Back-End however in the Front-End the second list is never populated and my access level is left empty. 

I tried to do it being connected as Super User in the Front-End to rule out access rights level but that doesn't make a difference. 

Help appreciated. 

Thanks.


Xav.

Get a Book for SEBLOD
693 Posts
rpoy
10 years ago
1
Level 1

Hi Xav,

By Front-End are you referring to the Site Form - and not Content?  It sounds like a cache issue - have you tried clearing the cache?  Does it work in another browser?  Try removing the field and saving the form, and then moving it back and saving it again.

thanks,

Randy

116 Posts
nycxav
10 years ago
0
Level 2

Hi Randy,

Thanks for your answer, unfortunately I have tried in 3 different browsers (Firefox Crome and Internet Explorer) cleaned the cache and even tried recreating fields from scratch, no luck. 

I ended up creating a database trigger to solve my problem. I would have preferred to understand why it didn't work but I had a client deadline and the trigger solved my problem in 5 minutes. 

Still interested in knowing if anyone else has faced the same issue though. 

Regards.
Xav.

116 Posts
nycxav
10 years ago
3
Level 1

Hi, 

I have the same problem on a different site. I tried to clean the cache, removed and re-added the fields, even recreated a new set of fields. 

On the site form the "Start" field works but the "In Between" or "End" list always remain empty. The same set of fields works perfectly in the admin form. 

This time I have no workaround and I really wonder if I'm the only one who ever faced this problem.

Help appreciated. 

Thanks.

Xav. 

693 Posts
rpoy
10 years ago
2
Level 2

Hi Xav,

What tables / fields are you trying to pull the information from?  In your first post, you mentioned categories - if that's the case, are you using parent_id field?

thanks,

Randy

116 Posts
nycxav
10 years ago
1
Level 3

Hi Randy, 

I use the plugin with table linked to a content type hence #__cck_store_form_xxx and the #__users table. I have a column in my table that links to the id in the #__users table and that's what I captured in my 'parent' colum for the second field. 

In any case the fields do work perfectly in the admin form so the setup is OK. The first one works in the site form but it seems that's the second query to populate the second list never 'fires' in the site form (actually I'm sure it's never executed as I traced it). 

So to me it looks like the change of value in the first field in the site form doesn't trigger anything. Looks very much like a bug to me.

Regards.

Xav

693 Posts
rpoy
10 years ago
0
Level 4

Hi Xav,

Do you have any other fields that require scripting to run?  Does it make any difference in the position of the content type - first vs last?

thanks,

Randy

116 Posts
nycxav
10 years ago
1
Level 1

Hi Randy, 

I found the culprit a JForm Tags field that was in both admin and site forms but with Variation =  Hidden in the site form. If I unhide it (Variation = Default) it works. If I publish it in the #HIDDEN section of my template it works too. 

Any idea why?

Any way thanks for your help. 

Regards.
Xav.

693 Posts
rpoy
10 years ago
0
Level 2

Hi Xav,

Glad you found the issue!  

It sounds like a bug.  I know there have been some issues with other fields using the hidden Variation especially when calculation rules are applied.  So it is probably a related issue.  There are some entries in the Tracker.  Please feel free to add your findings to the Tracker as well.

Thanks,

Randy

Get a VIP membership