Possible bug with A.C. Data formatter?

Wappler General Need Help
1

v5.8.2 (Updated the 16 components)
w10
php
mysql

I don’t know if this is a bug:
I have a bootstrap table from serverconnect1.data.query1 (1, 2, 3 ,4), with a button inside a cell.
Want to show that button when the repeat.id is in the serverconnect4.data.query2 (1, 2).
[On A.C. as the table needs to show all the records (from query1) like:]

image
image872×235 3.17 KB

I’ve done this dozens of times (included a few days ago before I updated all the 16 files) and now I can’t achieve it.
But I’ve found some strange behavour on the data formatter depending the format I choose:

ScreenRecorderProject19

Does it have something to do with my result? Or I’m missing something?

1 Like
2

This still being an issue, replicated on 6.0.2 Stable channel (w10)

Tasos and Jon posted this:

How to recreate:

  1. Add something like reverse
    image

  2. Having reverse (or any other option) there:
    image

  3. Now you have more options

    image
    image363×621 22.2 KB

This apply for exactly their case:

image

image

3

What exactly you bug report means?
Your video shows some random clicking in the formatter dialog. What do your screenshots show?
Sorry but i don’t understand what your issue is.

4

Yes, the video can confuse.

But the point is that the menu on the formatter changes after adding options, for example, recreating this I can use the option “contains” instead changing the input from array to text.

The point is the menu is not the same adding options to the formatter, don’t know if that’s ok, that’s why the title “possible bug”

5

The formatters displayed in the menu depend on the data type returned.

6

I know that, just trying to understand if it’s ok:

  1. Format an Array
  2. Add some option to the formatter
  3. The type stills the same (array)
  4. The menu changes

I’m not trying to create any tipe of confussion here, just want to express that the menu changes depending on what you add to the format tree (the data type never changes)

7

To add a little more clarification to this… I have a json field in my database table which contains an array like this:

[2,5,11]

However, when trying to use the contain option, it doesn’t appear in the formatters list:

Screenshot 2023-12-06 at 18.07.23

I know the formatters change based on the field type but it looks like a json field isn’t picked up as having the options like contain when it should.

8

This is still a thing on v7 Beta 28:
Not an issue at all, but strange

This is the menu on serverconnect1.data.query:
image

Now add some random stuff:
image

Now again menu on serverconnect1.data.query:
image

9

The inArray function is what you need, search the forum for 'inArray' for examples