Filtrage par rapport à la date du jour

More
9 years 5 months ago - 9 years 5 months ago #55109 by clicart
Bonjour, utilisateur novice de flexicontent (derniere version), mon objectif est le suivant:
avec l'utilisation du module caroussel, je souhaite afficher exclusivement les item qui ont (champ : "datevenement") une date égale ou postérieure à la date d'aujourd'hui.
Après lecture dans les forum et différents tutos, je pense être sur la bonne piste, mais le résultat à l'affichage est, soit un message d'erreur, soit avec l'intégralité des items...

En fait, je me suis borné à utiliser filtrage expert sur le champ concerné (cf copie d'écran)... je me trompe quelque part, mais ou? quelqu'un pourrait-il m'aider ?
Merci par avance.

ok, je liste:Filtrage expert
Dates
Comportements dynamiques: Comparer à la date serveur ou à l'élément courant
Dynamic, (initialiser à 'statique' pour désactiver) Comportement (***) decalage personnalisé (ajouté aux données de date)
veuillez lire la description
Méthode inclure

Champ date
datevenement
Comparer avec
données de la date du serveur
Du (date) 0 d
Au (date)

Portée du champ personnalisé
Statique, (initialiser à 'TOUS' pour désactiver)
Méthode statique
Dynamic, (initialiser à 'statique' pour désactiver)
Comportement (**)
Last edit: 9 years 5 months ago by clicart.

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

More
9 years 5 months ago - 9 years 5 months ago #55141 by ggppdk
Hello

ok
1. you have enabled DATE scope
2. you have selected "custom date field" and then selected the custom date field

also do in parameters:
FROM date: CURDATE()
FROM date is: SQL Expression

but note that: ALL item with EMPTY date field will also be included

(maybe we need a parameter for this)

[update]
There is a parameter, please set:
Empty/NULL dates: Exclude


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...
Last edit: 9 years 5 months ago by ggppdk.

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

More
9 years 5 months ago #55160 by clicart
Firstable, excuse my very bad english
Thank oyu for your message.
Unfortunatly, it dosn't work... (every item appears). Could you tell me where is the mistake, please ?
See below what i did:
-Filtrage expert
Dates
Comportements dynamiques: Comparer à la date serveur ou à l'élément courant
Dynamic, (initialiser à 'statique' pour désactiver)
Comportement (***) : décalage personnalisé (ajouté aux donnes de date)
Méthode Inclure
DONNEES de date champ date
Champ date datevenement [datevenement]
Null / empty dates Exclure
Comparer avec Date serveur courante
Custom offsets added to DATE DATA, e.g. -5 d (minus 5 days)
Compare to specific dates (YYYY-MM-DD) e.g. 2015-01-23
Du (date) CURDATE()
Au (date)

Portée du champ personnalisé
Statique, (initialiser à 'TOUS' pour désactiver)
Méthode statique TOUS
Dynamic, (initialiser à 'statique' pour désactiver)
Comportement (**) Statique: Filter en utilisatn les valeurs de champ spécifique

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

More
9 years 5 months ago #55161 by ggppdk
Hello

what do you mean it does not work ?
do you get an SQL error ?

- make sure that you have not selected / enabled other SCOPEs (enable them later)

- please switch Backend User Interface and post a picture of DATE SCOPE (all parameters of it being show)


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...
The following user(s) said Thank You: clicart

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

More
9 years 5 months ago - 9 years 5 months ago #55166 by clicart
Yesss ! I've got it, this point is OK, many thanks !
... May I ask you another question ?
I have two different types, and want to link them:
Type 1 : "evenement"
3 fields : Title of film "titrevenement", image of film "affichevenement", kind of film "genre"
Type 2 : "programme"
2 fields: date of event "datevenement", hour of event "heurevenement", title of programme "titrevenement"
Firstable:
when viewing the carousel-type "programme", I would like to display the poster of the event ("affichevenement"), together with the title (titrevenement), date (datevenement) and time of the event ("heurevenement"). ....title, date and schedules are displayed, but I can't display the poster (affichevenement) !
I know it's easy to do, but even watching the tutorials (recipe book, or looking for an author from books, etc ...) I am not able yet

Secondly:
When I create a new item in type "programme", i would like to see a list of all the titles of film (titrevenement) and
pick one out of the total (the title of the item programme will be the same of the event)

Could you guide me, please? ... and thank you again for your answers.

For information, when I try to put an attachment on this



forum, the program refuses, and put me a "500" error ... (I tried with jpg or pdf, it systematically refuses ...)
Last edit: 9 years 5 months ago by clicart.

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

More
9 years 5 months ago #55167 by micker
tu dois utiliser le champ de mise en relation entre des items=> tu auras une petite zone pour créer le rendu coté template

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.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.437 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