Last connection of item's creator

More
5 years 9 months ago #75931 by micker
maybe you can do a select field with an sql request like this (its an exemple need to adapt to your bdd)
Code:
SELECT id, name AS text, lastvisitDate AS value FROM #__user WHERE id = item->create_by
if it works you can use this by defaut, and hide in form

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago #75973 by templar
Hello,

After some tries, the solution of Micker is working, but there is still a problem.
The field is not dynamic, it is recorded during the creation or the modification of an item and stay "as is" until further modification.
Second problem, the process is not transparent for the user of the website, as they are forced to select manually the field.

So here ara my two questions :
- How to show the last visit date dynamically ?
- How to autmatically fill the field and hide it from the creation/.modification form ?

Thank you guys, your extension is awesome !

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago #75975 by micker
hello
you can add defaut value with option to autofill (not empty without save)
after you can hide field in form

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago #75976 by templar
Ok, so I need the pro version ?

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago - 5 years 9 months ago #75977 by micker
no its basic option in field configuration

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]
Last edit: 5 years 9 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago #75978 by templar
Je suis vraiment désolé, mais ça ne marche pas. J'ai essayé avec une valeur quelconque "pour tester" et aucune des trois options :afficher pour les nouveaux contenus, afficher pour tous les ocntenus, ou toujours afficher plutôt qu'une valeur vierge) ne fonctionne.
Par ailleurs, ce champs sert à mettre une valeur fixe, je n'ai pas l'impression qu'il permets d'intégrer une formule avec requête SQL.

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.370 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline