•  
     
    story #44821 Include linked artifacts to XLSX export
Summary
Empty
Include linked artifacts to XLSX export
Empty

The XLSX export will be aligned with what is already done in "Cross tracker XLSX export": each level of sub artifact link will lead to a duplication of lines.

Given the following structure

2815-image.png

This will lead to this kind of table (without the colors)

2816-image.png

The example .xlsx is here.

Business rules

  • A block of field is the list of fields defined in the SELECT part of the TQL query

  • Each expanded level of artifacts will lead to one block of fields

  • Given an artifact at level N that have M links at level N-1, there will be M duplication of N block.

    • Example 1:

      • 1 root artifact "dense unit" (level 0)

      • has 2 links (level 1)

        • unreasonable circular

        • straight possession

      • This gives 2 lines in XLSX

        • dense unit - unreasonable circular

        • dense unit - straight possession

    • Example 2:

      • 1 root artifact "dense unit" (level 0)

      • has 2 links (level 1)

        • unreasonable circular

        • straight possession

      • "straight possession" has two links

        • maximum license

        • shocked bike

      • This gives 3 lines

        • dense unit - unreasonable circular

        • dense unit - straight possession - maximum license

        • dense unit - straight possession - shocked bike

Empty
Status
Cross tracker search
On going
Development
  • [ ] Does it involves User Interface? 
  • [ ] Are there any mockups?
  • [ ] Are permissions checked?
  • [ ] Does it need Javascript development?
  • [ ] Does it need a forge upgrade bucket?
  • [ ] Does it need to execute things in system events?
  • [ ] Does it impact project creation (templates)?
  • [ ] Is it exploratory?
Empty
Details
#44821
Manuel Vacelet (vaceletm)
2025-10-07 17:49
2025-09-12 15:55
45795

References
Referencing story #44821

Git commit

tuleap/tuleap/stable

refacto: extract filtering of already seen parents for readability 9c59dbc37d
refacto: introduce UUID for each artifact row in XTS widget 23da48bcea
refacto: move row direction into ArtifactRow in XTS widget e5f125d385
Introduce data model for artifact link export 65597a8ad8
refactor(cross-tracker-search): Extract RowCollectionStore from SelectableTable ab7551d25b
refacto(cross-tracker-search): extract ArrowDataStore from SelectableTable 0b690eef2d
chore: prepare cross tracker xlsx export 16982bfa03
refactor(cross-tracker-search): Rework RowCollectionStore into TableDataStore 03abebc342
refactor(cross-tracker-search): Order the row collection and remove listeners of TableDataStore 3799c589ed
feat(XTS): Add an information modal when there are more than one page of result 81ec344c33
feat: Be able to export XLSX with links in XTS f5759511ad
refactor(cross-tracker-search): Introduce TableDataOrchestrator a0c24d9e58
Covers the "unknown" fields by e2e tests fff829b7b7
Support @link_type column in XLSX report 2b2d09f889

Follow-ups

User avatar
  • Acceptance criteria
    Something went wrong, the follow up content couldn't be loaded
    Only formatting have been changed, you should switch to markup to see the changes
User avatar
  • Acceptance criteria
    Something went wrong, the follow up content couldn't be loaded
    Only formatting have been changed, you should switch to markup to see the changes
User avatar
  • Status changed from Ready (hot) to Selected
  • Permissions set to
  • Category set to Cross tracker search