Value not appeared in list & not exported

[dimoss]

Hi

I face a very strange problem with a field where its value is not appeared in the list and not exported in the csv as it should be.
The list brings the records from a MySQL view and in phpmyadmin all are shown correctly.
I tried to debug and I see a small difference in this field compared to the others in table data:

[0] => stdClass Object
                (
                    [vw_xdoubles___id] => 3
                    [vw_xdoubles___id_raw] => 3
                    [vw_xdoubles___tour_id] => 21
                    [vw_xdoubles___tour_id_raw] => 21
                    [vw_xdoubles___tournament] => 2018 Seamaster ITTF World Tour China Open
                    [vw_xdoubles___tournament_raw] => 2018 Seamaster ITTF World Tour China Open
                    [vw_xdoubles___pid1] => 106814
                    [vw_xdoubles___pid1_raw] => 106814
                    [vw_xdoubles___name1] => NUYTINCK Cedric
                    [vw_xdoubles___name1_raw] => NUYTINCK Cedric
                    [vw_xdoubles___assoc1] => BEL
                    [vw_xdoubles___assoc1_raw] => BEL
                    [vw_xdoubles___pid2] => 120777
                    [vw_xdoubles___pid2_raw] => 120777
                    [vw_xdoubles___name2] => LUNG Lisa
                    [vw_xdoubles___name2_raw] => LUNG Lisa
                    [vw_xdoubles___assoc2] => BEL
                    [vw_xdoubles___assoc2_raw] => BEL
                    [vw_xdoubles___mix_raw] => 1
                    [vw_xdoubles___seeded] => 0
                    [vw_xdoubles___seeded_raw] => 0
                    [vw_xdoubles___position] => 0
                    [vw_xdoubles___position_raw] => 0
                    [slug] => 3
                    [__pk_val] => 3
                    [fabrik_select] =>
                    [fabrik_view_url] => /index.php?option=com_fabrik&view=details&formid=25&rowid=3&Itemid=143
                    [fabrik_edit_url] => /index.php?option=com_fabrik&view=form&Itemid=143&formid=25&rowid=3&listid=25
                    [fabrik_view] =>
                    [fabrik_edit] =>
                    [fabrik_actions] =>
                )

As it shown all the fields has two values (normal and raw). However the 'vw_xdoubles___mix' has only the raw. I don't know how this happens and I have looked all the element settings which are correct.

Here is the listGetData:

SELECT SQL_CALC_FOUND_ROWS DISTINCT `vw_xdoubles`.`id` AS `vw_xdoubles___id`, `vw_xdoubles`.`id` AS `vw_xdoubles___id_raw`, `vw_xdoubles`.`tour_id` AS `vw_xdoubles___tour_id`, `vw_xdoubles`.`tour_id` AS `vw_xdoubles___tour_id_raw`, `vw_xdoubles`.`tournament` AS `vw_xdoubles___tournament`, `vw_xdoubles`.`tournament` AS `vw_xdoubles___tournament_raw`, `vw_xdoubles`.`pid1` AS `vw_xdoubles___pid1`, `vw_xdoubles`.`pid1` AS `vw_xdoubles___pid1_raw`, `vw_xdoubles`.`name1` AS `vw_xdoubles___name1`, `vw_xdoubles`.`name1` AS `vw_xdoubles___name1_raw`, `vw_xdoubles`.`assoc1` AS `vw_xdoubles___assoc1`, `vw_xdoubles`.`assoc1` AS `vw_xdoubles___assoc1_raw`, `vw_xdoubles`.`pid2` AS `vw_xdoubles___pid2`, `vw_xdoubles`.`pid2` AS `vw_xdoubles___pid2_raw`, `vw_xdoubles`.`name2` AS `vw_xdoubles___name2`, `vw_xdoubles`.`name2` AS `vw_xdoubles___name2_raw`, `vw_xdoubles`.`assoc2` AS `vw_xdoubles___assoc2`, `vw_xdoubles`.`assoc2` AS `vw_xdoubles___assoc2_raw`, `vw_xdoubles`.`mix` AS `vw_xdoubles___mix`, `vw_xdoubles`.`mix` AS `vw_xdoubles___mix_raw`, `vw_xdoubles`.`seeded` AS `vw_xdoubles___seeded`, `vw_xdoubles`.`seeded` AS `vw_xdoubles___seeded_raw`, `vw_xdoubles`.`position` AS `vw_xdoubles___position`, `vw_xdoubles`.`position` AS `vw_xdoubles___position_raw`, `vw_xdoubles`.`id` AS slug , `vw_xdoubles`.`id` AS `__pk_val` FROM `vw_xdoubles` WHERE ( `vw_xdoubles`.`tournament` = '2018 Seamaster ITTF World Tour LION Japan Open' ) ORDER BY `vw_xdoubles`.`id` ASC

Any idea?

Thanks.

 

[troester]

in liGetData it's doing ...`vw_xdoubles`.`mix` AS `vw_xdoubles___mix`, `vw_xdoubles`.`mix` AS `vw_xdoubles___mix_raw`,....
so this looks ok.
Which element type is mix?

 

[dimoss]

in liGetData it's doing ...`vw_xdoubles`.`mix` AS `vw_xdoubles___mix`, `vw_xdoubles`.`mix` AS `vw_xdoubles___mix_raw`,....
so this looks ok.
Which element type is mix?

It's a simple field type.
For your info the mysql view 'vw_xdoubles' is:

select
fab_xdoubles.id AS id,
fab_xdoubles.tournament AS tour_id,
fab_tournaments.tournament AS tournament,
fab_xdoubles.player1_id AS pid1,
p1.name AS name1,
fab_xdoubles.assoc_a AS assoc1,
fab_xdoubles.player2_id AS pid2,
p2.name AS name2,
fab_xdoubles.assoc_b AS assoc2,
1 AS mix,
fab_xdoubles.seeded AS seeded,
fab_xdoubles.position AS position
from fab_xdoubles
join fab_players p1 on p1.player_id = fab_xdoubles.player1_id
join fab_players p2 on p2.player_id = fab_xdoubles.player2_id
join fab_tournaments on fab_tournaments.id = fab_xdoubles.tournament
where fab_tournaments.activation = 'Yes' and fab_tournaments.xd = 'Yes'