Premium App Builder Cannot read properties of null (reading ‘toLocaleLower

I am using problems using the Premium App Builder.

TEST 1:
create view g_test_vw as
select t.tour_id , tm.member_id,1 sequ
from g_tournament t
join g_teams_vw tm on tm.member_id = ‘163’
where t.active_now=’A’ and t.tour_id = ‘2024-08’

UNION
select t.tour_id , tm.member_id,2 sequ
from g_tournament t
join g_teams_vw tm on tm.member_id = ‘163’
where t.active_now=’A’ and t.tour_id = ‘2024-08’
;

when I run the view:
select * from g_test_vw i get the following results:

tour_id member_id sequ
2024-08 163 1
2024-08 163 2

           

I have build this into an APP using : Premium App Builder
         
I then click on "Run & Build APP".
         and get the following results:

         tour_id  member_id   sequ
         2024-08   163         1
         2024-08   163         2

         Perfect.

TEST 2:
I change my view to “LEFT JOIN” my table “g_teams_vw”:
alter view g_test_vw as
select t.tour_id , tm.member_id,1 sequ
from g_tournament t
LEFT join g_teams_vw tm on tm.member_id = ‘163’
where t.active_now=’A’ and t.tour_id = ‘2024-08’

UNION
select t.tour_id , tm.member_id,2 sequ
from g_tournament t
LEFT join g_teams_vw tm on tm.member_id = ‘163’
where t.active_now=’A’ and t.tour_id = ‘2024-08’

when I run the view:
select * from g_test_vw, I get the following results:

tour_id member_id sequ
2024-08 163 1
2024-08 163 2

I then click on “Run & Build APP”.
and get the following results:

Premium App Builder
Error
Cannot read properties of null (reading ‘toLocaleLowerCase’)

TEST 3:
I change my view and take out “LEFT” in the join with my table “g_teams_vw”:
I then click on “Run & Build APP”.
and get the following results:

         tour_id  member_id   sequ
         2024-08   163         1
         2024-08   163         2

         Perfect again.

TEST 4:

I change my view :

select t.tour_id , at.member_id,tm.team_id,1 sequ
from g_tournament t
left join g_teams tm on tm.team_id = ‘JHS’
left join g_team_members at on at.member_id = ‘JHS’
where t.active_now=’A’ and t.tour_id = ‘2024-08’

when I run the view:
select * from g_test_vw I get the following results:

tour_id member_id team_id sequ
2024-08 NULL NULL 1
Perfect

I have then refresh the app table and columns using : Premium App Builder

I then click on “Run & Build APP”.
and get the following results:

tour_id member_id team_id sequ
2024-08 NULL NULL 1

Again Perfect.

TEST 5:

I then introduce a UNION ALL:

Alter view g_test_vw as
select t.tour_id , at.member_id,tm.team_id,1 sequ
from g_tournament t
left join g_teams tm on tm.team_id = ‘JHS’
left join g_team_members at on at.member_id = ‘JHS’
where t.active_now=’A’ and t.tour_id = ‘2024-08’
UNION ALL
select t.tour_id , at.member_id, tm.team_id,2 sequ
from g_tournament t
left join g_teams tm on tm.team_id = ‘JHS’
left join g_team_members at on at.member_id = ‘JHS’
where t.active_now=’A’ and t.tour_id = ‘2024-08’

I have then refresh the app table and columns using : Premium App Builder

I then click on “Run & Build APP”.
and get the following results:
Premium App Builder
Error
Cannot read properties of null (reading ‘toLocaleLowerCase’)

TEST 6:

 
I then took out the LEFT in the joins

  Alter view   g_test_vw as
                    select   t.tour_id , at.member_id,tm.team_id,1 sequ
                    from   g_tournament t 
                      join  g_teams  tm on tm.team_id = 'JHS'  
                      join  g_team_members  at on at.member_id = 'JHS' 
                    where  t.active_now='A'  and t.tour_id = '2024-08'
  UNION ALL
                    select   t.tour_id , at.member_id, tm.team_id,2 sequ
                    from   g_tournament t  
                      join  g_teams  tm   on tm.team_id = 'JHS'  
                      join  g_team_members  at on at.member_id = 'JHS' 
                    where  t.active_now='A'  and t.tour_id = '2024-08'

I have then refresh the app table and columns using : Premium App Builder
         
I then click on "Run & Build APP".
         and get the following results:

         tour_id       member_id   team_id       sequ
           
Again perfect.

• This topic was modified 3 months, 3 weeks ago by sagolfer.