---
title: "marché 01"
code: "2026-M01"
titulaire: "[[06_CONTACTS/]]"
sous-traitants:
  - "[[06_CONTACTS/]]"
duration: ""
ht_max: 1000
---

# Test

**Infos**

title: ${editor.getCurrentPageMeta().title}
code: ${editor.getCurrentPageMeta().code}
titulaire: ${_CTX.currentPage.titulaire}
sous-traitants: ${editor.getCurrentPageMeta().sous_traitants}
duration: ${editor.getCurrentPageMeta().duration}
ht_max: ${editor.getCurrentPageMeta().ht_max}
ttc_max: ${editor.getCurrentPageMeta().ht_max * 1.2}





### FACTURES

| TYPE     | BC    | PRESTA                                      | QUANTITE | PU_HT #euro | HT #euro                   | TTC #euro                        |
|----------|-------|---------------------------------------------|---------:|------------:|---------------------------:|---------------------------------:|
| #facture | BC 01 | Maitenance et développement (migration DF2) | 20       | 780         | ${F("D1","1")*F("E1","1")} | ${F("D1","1")*F("E1","1") * 1.2} |

| Header A              | Header B                  |
|-----------------------|---------------------------|
| 1.2                   | ${F("ROUND(A1,2)") * 1.2} |
| 3                     | 4                         |
| 5                     | 6                         |
| 7                     | 8                         |
| 9                     | ${F("A2","1")}            |
| ${F("CONCAT(A1,A2)")} | ${F("SUM(A1:B5)")}        |

| Header A               | Header B               | H5                         |
|------------------------|------------------------|----------------------------|
| 10                     | 20                     | 50                         |
| 30                     | 40                     | 50                         |
| 50                     | 60                     | 50                         |
| 70                     | 80                     | 50                         |
| 90                     | 100                    | 50                         |
| ${F("SUM(A1:B5)","1")} | ${F("SUM(B1:B5)","2")} | ${F("AVERAGE(C1:C5)","2")} |

${query[[from index.objects("facture")]]}

${query[[
  from o = index.objects("facture")
  select {
    TOTAL = sum(o.ht)
  }
]]}

${query[[
  from t = index.tables('facture') 
  where t.page == _CTX.currentPage.name
  select t
]]}

${query[[
  from o = index.tables('facture')
  select {
    TITULAIRE = '--',
    PRIX = sum(o.prix),
    BC = '--'
  }
]]}




table.includes(t.links, _CTX.currentPage.name)

{query[[
  from o = index.pages()
  order by o.lastModified desc
  limit 20
  select {
    PAGE = o.name,
    DATE = o.lastModified
  }
]]}

{query[[from o = index.tag "header" where table.includes(o.tags, "event") order by o.page desc limit 10 select table.select(o, 'ref', 'name')]]}

{query[[from o = index.tag "header" where table.includes(o.tags, "event") and string.find(o.name, "%[%[03_PROJETS/NPDGE%]%]") order by o.page desc limit 10 select table.select(o, 'ref', 'name')]]}

_CTX.currentPage

[[TEST/test.drawio]]

![](TEST/test.drawio)

![[07_DIAGRAMMES/dge_chatbot_schema_simplifie.webp|500]] Enseignements:
* Besoin d’être très précis sur les attendus
* Besoin de disposer d’un grand nombre de données d’entrainement (question/réponses)
* Importance de la phase de test => mesurer de la satisfaction, adapter le paramétrage

Retour sur la phase de test
* Cf. PPTX (Didier)

```drawio
url:TEST/test.drawio
height:500px
```

```excalidraw
url:test.excalidraw
height:500px
```