SPIP
Article validated
The article « {fusion_supprimer}
({fusion_supprimer} - SPIP) » was validated by
[ar]جورج[fr]George [en]George.
{fusion_supprimer}
Thursday 19 August 2021 , by jack
`
{fusion_supprimer}
: this criterion removes from the sql query the
GROUP BYcondition that is present there, at this stage of compilation. This can be useful to get rid of a
GROUP BY` added by default by the SPIP compiler during a join and
which gets in the way. It is then possible to add the criterion for a
desired merge. (cf #3209 (https://core.spip.net/issues/3209))
Example
In the following loop it is necessary to add `
{fusion_supprimer}
to get the merge on dates, because by default the compiler adds automatically a
GOUP BY id_article` for the join of the table ARTICLES
with the table MOTS:
<BOUCLE_facette_annee
(ARTICLES)
{id_mot=27}
{fusion_supprimer}
{fusion YEAR(date)}
>
[
(
#DATE
|annee
)
]
</BOUCLE_facette_annee>
This criterion was previously defined by the SPIP-Bonux plugin, and has
been integrated into SPIP 4.0.
— Sent by SPIP (https://www.spip.net/)