Sequential number, order number

  • Resolved Alph

    (@alpph)


    5 years ago

    Hello All,

    I display on a site with WP and Pods the same data I have in a Access database. In Access I have a list of published rececettes (recipes) extracted with the following SQL query :

    SELECT (SELECT  COUNT(Nom) FROM TabRecettesPréparation AS TabRecettesPréparation_Alias  WHERE (((TabRecettesPréparation_Alias.Publiée)=[Formulaires]![ForPréparationRecettesPubliéesOuNon]![Publiée])) and TabRecettesPréparation_Alias.Nom <  TabRecettesPréparation.Nom)+1 AS Ordre, TabRecettesPréparation.N°, TabRecettesPréparation.Nom, TabRecettesPréparation.Sous_titre, TabRecettesPréparation.Région, TabRecettesPréparation.Publiée
FROM TabRecettesPréparation
WHERE (((TabRecettesPréparation.Publiée)=[Formulaires]![ForPréparationRecettesPubliéesOuNon]![Publiée]))
ORDER BY TabRecettesPréparation.Nom, TabRecettesPréparation.Sous_titre;

    The output data have a dynamically generated sequential number called Ordre.

    With Pods I have build a page that list all the Recette on the site. I do that with

    <bold><hr></bold>
{@post_title} - {@sous_titre} <br>

    How can I add a sequential number as I can do in Access ?

    Thanks

    Alphonse PHILIPPE

Viewing 16 replies (of 16 total)
  • Thread Starter Alph

    (@alpph)

    HI,

    To clarify the contect :
    – my site use only one Custom Post Type (i.e. PODS) : Recettes
    – Recettes has 9 fields, not relevant for this discussion
    – I define 3 Custom Taxonomy (with no Fields) : Nature Type (nature_type), Ingrédient principal (ingredient_principal), Région (region)
    – Recettes has 3 Built-in Taxonomies : Nature Type, Ingrédient principal, Région
    – the 3 Custom Taxonomies are associated with the Custom Post Types : Recettes

    Unlike you, I do not use links (connection) between 2 Pods.

    That can explain the difficulties you have with my code.

    In addition : I manage only one site and are not involved in any other developpement process using PODS. As consequence I can not help you with links beetwen Custom Post Types.

    A. PHILIPPE

Viewing 16 replies (of 16 total)
  • The topic ‘Sequential number, order number’ is closed to new replies.