data disappears in business table

[yosiasz]

when initially setting this up, data shows up in business table. you come back to it later on and the data disappears from business table.

grafana v11.5.1
business-table 2.2.0

data source: Mixed

data1: mysql

select 1 as id, '[email protected]' as email, 'Joseph David' as name, phone= '+189945306000',
title= 'Medical Doctor (MD)', cert_path= 'certs/9/Medical Doctor (MD).jpeg', issue_date='11/07/2024',
expiry_date = '05/26/2025', approved_status='PENDING'  union
select 2 as id, '[email protected]' as email, 'Jedi Nurse' as name, phone= '+189945306000',
title= 'Sith Hospital', cert_path= 'Saber.jpeg', issue_date='11/07/2024',
expiry_date = '05/26/2025', approved_status='PENDING'  

data2: infinity

[{"id":1,"cert_url":"https://firebaseCDN/certs/joseph-david"},
{"id":2,"cert_url":"https://firebaseCDN/certs/jedi-nurse"}]

Join by field transformation

Business table setup

[vitPinchuk]

@yosiasz thank you for your question.

I can reproduce the issue. I have tried different DS, and also tried infinity in the backend and default parser types the data in the table does not disappear.

Example ( TimeScale + Infinity )