Crazy table index :)

I have discovered two strange result for my "crazy" day

  • with empty cell

| Plan | Licences | Business Standard #euro | Business Premium #euro | Microsoft 365 E3 #euro | Microsoft 365 E5 #euro |
| ---- | -------- | ----------------------- | ---------------------- | ---------------------- | ---------------------- |
| 1    |          | 10.80                   | 19.10                  | 34.90                  | 55.20                  |
| 2    |          | 19.04                   | 27.76                  | -                      | -                      |
| 3    | 22       | 0                       | 0                      | 0                      | 0                      |

${query[[from index.tag "table" where page == "Library/Malys/MdTableSheet/test5" order by pos]]}

is false, because 22 is the unique value in this column

  • with ** in title of column
| Plan                    | **Business Standard** #euro | **Business Premium** #euro | **Microsoft 365 E3** #euro | **Microsoft 365 E5** #euro |
| ----------------------- | --------------------------- | -------------------------- | -------------------------- | -------------------------- |
|1   | 10.80                       | 19.10                      | 34.90                      | 55.20                      |
| 2 | 19.04                       | 27.76                      | -                          | -                          |
| 22                      | ${F("B1")}                  |                            |                            |                            |

many columns are ignored

Is it necessary to create an issue in github? @zef

Fixed in PR 1870 and it's continuation PR 1871.

1 Like

It will be included to next release ?

That's not at me but we can ask @zef whether he will release another extra minor one with this included...

Just triggered the 2.5.2 release, give it a few minutes.

${query[[from index.tag "table" where page == "Library/Malys/MdTableSheet/test5" order by pos]]}

Plan Licences Business Standard #euro Business Premium #euro Microsoft 365 E3 #euro Microsoft 365 E5 #euro
1 10.80 19.10 34.90 55.20
2 19.04 27.76 - -
3 22 0 0 0 0

Not fixed??
I have to do something? (SB 2.5.2) @mjf

I clear site data in DevTools/Aplication/Storage.
And SB reindex alll and its works.

I did "wipe client" but i will try to clean browser data like you suggest

New PR(s) on the way on main.

Ok, before I throw another release at this it would be good to get confirmation that on edge this is now fixed :wink:

Hopefully.

After browser data clear OK

but this case is not fixed

Plan Business Standard #euro Business Premium #euro Microsoft 365 E3 #euro Microsoft 365 E5 #euro
1 10.80 19.10 34.90 55.20
2 19.04 27.76 - -
22 ${F("B1")}

${query[[from index.tag "table" where page == "Library/Malys/MdTableSheet/test" order by pos]]}

Is it ok or not? I still don't see the issue...

On edge... You even don't need to put - inside the cells, empty cells should be supported correctly too (with some rules laid, if course, because of the nature of the MD tables).