Embed data from a List into a Form

[marcq]

Thank you Hugh,

I have updated the list.php file on my server.

I have still a problem, Data aren't grouped for the "Formation" database join Element as you can see on the following screencast :

http://www.screencast.com/t/LWQQBiMIf7J

 

[marcq]

Last update :

After updating Fabrik with the last Fabrik Github and Joomla 3.4.8, problem still remain.

http://www.screencast.com/t/XGY2nGlCLf

 

[cheesegrits]

Nope, it wasn't updated. I downloaded list.php from your site, and as you can see, the lines from the change on github aren't there ...

http://screencast.com/t/ypNsr1aEQhnI

I uploaded the github version, and it seems to work now.

-- hugh

 

[marcq]

Hi Hugh,

Thank you for you reply.

Sorry, you couldn't know that I have updated the list.php to the live server and tested there (www.gprh.ch) and not to the dev server (http://www.webamazingapps.com/projects/gprh.ch/).

The header is now populated with the training names, but same trainings are not regrouped in a single group has they should, please see the screencapture.

 

[cheesegrits]

I don't have a login for the live server. Can you replicate this on the test server.

One thing to check, do you have a "Group By" set on the list itself.

-- hugh

 

[marcq]

I don't have a login for the live server. Can you replicate this on the test server.

One thing to check, do you have a "Group By" set on the list itself.

-- hugh

Hi Hugh,

I've tried with and without a Group by set in the list.

You can login to the dev server for which you have access, I have now updated the last Fabrik Github and Joomla version.

One of the concerned list is : http://webamazingapps.com/projects/...option=com_fabrik&view=list&layout=edit&id=39

One of the concerned element is : http://webamazingapps.com/projects/...n=com_fabrik&view=element&layout=edit&id=1126

Thanks in advance, cheers, Marc

 

[cheesegrits]

I think the issue is that we use the "raw" data for the grouping, but you have data which has differing raw data (the value of the join), but the concat label is the same.

-- hugh

 

[marcq]

I think the issue is that we use the "raw" data for the grouping, but you have data which has differing raw data (the value of the join), but the concat label is the same.

-- hugh

Thank you for your feedback, I will have to find another solution.

Solution could be to create a new element in the form and each time a new training is created/saved to use the PHP plugin to save the name of the training into the new element table field. Then to unpublish (Show list) the "choix_formation" element and to publish (Show list) the new element. So the Group by would work...

 

[marcq]

Hi Hugh,

Despite my problem with the databasejoin field, which I can solve as explained earlier, I still have issues with grouping data in lists:

In this list : http://webamazingapps.com/projects/...formations-sa/inscriptions/formation-acceptee, dates are grouped correctly.

In this list : http://webamazingapps.com/projects/...rmations-sa/inscriptions/formation-en-attente, dates are not grouped correctly. The group header is repeated constantly for same dates.

First part list where grouping is working | Second list where grouping is not working
http://www.screencast.com/t/vKRPX3Ix

Important to note is that I have cloned this two list/form and elements have the same parameter (I just changed the access, since the initially parent list/form is intended for public access.

I would appreciate, if you could have a look.

Thanks in advance.

Cheers, Marc

 

[cheesegrits]

I think that's because the time part of the date field is different for each row. A similar problem to the last issue, because we group by the "raw" value.

I'm testing a new option, "Group by raw", on the settings so you can select whether you want to group by the raw or the formatted data. Which in this case would fix it, if your date's list format doesn't include a time part.

I'll commit it when I've tested some more.

-- hugh

 

[marcq]

I think that's because the time part of the date field is different for each row. A similar problem to the last issue, because we group by the "raw" value.

I'm testing a new option, "Group by raw", on the settings so you can select whether you want to group by the raw or the formatted data. Which in this case would fix it, if your date's list format doesn't include a time part.

I'll commit it when I've tested some more.

-- hugh

Thank you Hugh