to display all the books (joomla articles) /1 editor

herve , March 29 2021, 12:51
H
herve 28
March 29 2021, 12:51 #105
Hello Marco
For each joomla article of a resource centre, I select its corresponding editor/joomla contact using a custom field .
I then display this custom field (editor) in the overload of an article (book). OK
Now I want to do the opposite on the page of a joomla editor/contact, I want to display all the books (joomla articles) that are attached to it
Is it possible to do this simply with a nice layout like with an exposer module.
It would be necessary for the module to retrieve the id of the contact page displayed in an sql query to be able to perform this operation
Regards
marco 129
March 29 2021, 13:07 #106
Hi Hervé
If I understand you correctly, you are looking for a "dynamic" solution.
So you have several "articles" and now you want to display the articles of this editor on the corresponding page of the editor?

These are Joomla! contacts but not the "creator" of the article, correct?

Currently this is neither possible in Exposer nor in the WidgetsBox. The content is loaded statically based on the module settings.
However, in principle this could be integrated into Exposer - I still have to think about it a bit
kind regards
Marco
---------

Rate us on JED: https://extensions.joomla.org/profile/profile/details/379934

---------
H
herve 28
March 29 2021, 13:20 #108
Hi
Ok great if you understood me.In the module if it was possible, it could be a raw sql field instead of select "category" ,
If I can well at this place get the id of the contact (editor) of the articles (books) of this contact!
Regards
marco 129
April 01 2021, 16:04 #109
Hi Hervé
Unfortunately it's not "that easy" to give the admins the possibility to add SQL statements - its a security risk in general when you save SQL statements (even parts of it) in the database. I know there are extensions out there that do those things and i will have alook for that in the future to understand "how they keep it safe". In the meantime i have created a HUGE update for Exposer that is not quite finished yet (needs a bit to be polished on some places) but i will give you the Opportunity to test the whole thing while I work on it. So for this reason i have added Exposer Version 1.5.0 to the Download Center. It's a my third release candidate and in my tests everything worked fine.
With Version 1.5.x you are able to define CUSTOMFIELDS that holds the information for filter. In Short: Define a Key value (maybe the id) In the Container Element (Article or Contact) and set the Value also as customfield in the articles that should be displayed.

A First steps tutorial can be found here: https://nx-designs.ch/support/manuals/?nxlib=123&article=187#nx-article-library-123
Please not that Exposer 1.5.0 is not yet available via Updater, Checkout the Downloads in your Cockpit here on nx-designs to download the latest Release Candidate.
---------

Rate us on JED: https://extensions.joomla.org/profile/profile/details/379934

---------
H
herve 28
April 07 2021, 13:31 #118
Hello Marco,
Ok I managed to regenerate the password. But contrary to the screen it did not accept the email but the username. I couldn't remember!

I understand about the sql. Thanks for the long answer, I was just wondering why but I respect your choice.
But I don't think you answered my main suggestion, but maybe I didn't explain myself well, my bad English. If you say no it's no.

The idea is to automatically retrieve the id of the contact (from the url of the display of the contact page) to display the joomla articles corresponding to this contact (in the exposer module which would be under this contact page). See image.

Other choice than the category:
In the module I will just check a box: "automatic link if url of a joomla contact page".
In this case there is no sql query as I have stored the contact id in the custom field of the article; Example "115".
You do your conventional query to retrieve joomla articles from this id, rather than on the category. See image

Your solution requires you to create additional fields to make this link while not maintaining uniqueness if there is an error on the name of a contact

In any case, thank you for taking the time. I will renew the subscription as your module is the most advanced and complete today.

If you want to explore my suggestion, there is no urgency either but it seems elegant unless I forgot a technical problem!

Regards
Hervé
suggestion-mod-exposer.jpg
Screenshot_2021-04-07_Alter_-_Module_Livres_mod_nx_exposer.png
Attachments
suggestion-mod-exposer.jpg
(92.23 KiB)
9 Downloads/Views
marco 129
April 09 2021, 07:28 #119
Hi Hervé
thank you very much for your trust.
My Version 1.5 has (partly) solved this rquirement --> You can set a dynamic Filter by ID (which means the article or contact ID) but you have always to "link" the articles (books) in your case to a contact via a customfield that has to be setted up in the "Book-Article"
So in fact, you can use the Dynamic filter upon ID mode (do not set any other filters like cat and so) and all you have to do is to store the related ID in a customfield in the books.
I will add another Tut this weekend about this scenario - maybe it helps you.
---------

Rate us on JED: https://extensions.joomla.org/profile/profile/details/379934

---------
H
herve 28
April 09 2021, 10:19 #120
Hi Marco
I don't understand, I think that this ... works!
I did not put the module in the contact form (multiplied by dozens of contacts, it is not desirable). I used the architecture of my image

I put (a bit randomly) the parameters of my attached image

Can you tell me if there is a parameter to optimize because I find the display of the list of books a little long!
I don't put the images and it will be possible that a book editor has hundreds of books in his catalogue.

How to optimize the display time?
https://www.alterweb.info/fr/editeurs-medias/editions-libre-solidaire
Regards
Screenshot_2021-04-09_Alter_-_Module_Ressources_en_rapport_mod_nx_exposer_.png
marco 129
April 10 2021, 14:29 #121
Hi Hervé
Nice - glad to hear (and see) that its working!
ahm yes as i can see you have selected the Grid Layout - thats fine for desktops because you have then multiple columns... For Mobiles i would recommend to enable the "Simple on Mobile" Option would help to decrease the size on mobiles - another option could be to select List UIkit 3 as template but yeah its up to you...
Other things you could do is to decrease the font sizes for titles and texts and minimize the padding. All can be done by Custom CSS. When doing this you could reach a point where you can use 4cols layout in Grid Mode...
kind regards
Marco
---------

Rate us on JED: https://extensions.joomla.org/profile/profile/details/379934

---------