Why are translations for my last few version not visible in table transl_nav?

Hi Johan,

Can you inspect the get_gui_transl_nav procedure in your IAM and SF database? Last time I check there was an exception built in to only allow NL translations to be returned.

Hi Mark,

Yes, Here it is and it seems correct:
 

ALTER procedure [dbo].[get_gui_transl_nav]
(
   @usr_id         usr_id         ,
   @gui_appl_id    id             ,
   @platform       platform       ,
   @appl_lang_id   appl_lang_id   
)
as
begin

  -- Do not count affected rows for performance
  SET NOCOUNT ON


    --control_proc_id:     sf_gui_proc_get_gui_procedures
    --template_id:         declare_local
    --prog_object_item_id: get_gui_transl_nav_declare_local
    --template_desc:       

    declare @local_usr_id         usr_id          = @usr_id
    declare @local_gui_appl_id    id              = @gui_appl_id
    declare @local_platform       platform        = @platform
    declare @local_appl_lang_id   appl_lang_id    = @appl_lang_id


    --control_proc_id:     sf_gui_proc_get_gui_procedures
    --template_id:         sf_proc_get_gui_procedures_select
    --prog_object_item_id: get_gui_transl_nav_select
    --template_desc:       Control procedure for generating all get gui procedures

    select
        t1.platform,
        t1.appl_lang_id,
        t1.type_of_object,
        t1.transl_object_id,
        t1.transl_form,
        t1.transl_grid,
        t1.transl,
        t1.transl_plural,
        t1.tooltip_text,
        t1.help_text
    from gui_transl_nav t1


    --control_proc_id:     sf_gui_proc_get_gui_procedures
    --template_id:         sf_proc_get_gui_procedures_where
    --prog_object_item_id: get_gui_transl_nav_where
    --template_desc:       Control procedure for generating all get gui procedures

    where
          (t1.usr_id = @local_usr_id)
      and (t1.gui_appl_id = @local_gui_appl_id)
      and (t1.platform = @local_platform)
      and (t1.appl_lang_id = @local_appl_lang_id)


    --control_proc_id:     sf_gui_proc_get_gui_procedures
    --template_id:         sf_proc_get_gui_procedures_order_by
    --prog_object_item_id: get_gui_transl_nav_order
    --template_desc:       Control procedure for generating all get gui procedures

    order by
       t1.project_id
      ,t1.project_vrs_id
      ,t1.platform
      ,t1.appl_lang_id
      ,t1.type_of_object
      ,t1.transl_object_id


end

The debugging of this will probably take some effort. Last thing I can think of that the gui_transl_nav view may be altered. Could you double check that one too?

If that also looks okay, then I suggest creating a ticket for this.

Hi, I checked the view in IAM and TSF and they both have same definition. But what I also see is that I have different definition for this view in MOD database. Let me share both below:

TSF and IAM:
 

/* Create view gui_transl_nav. */

create view [dbo].[gui_transl_nav]
(
   "usr_id",
   "project_id",
   "project_vrs_id",
   "gui_appl_id",
   "platform",
   "appl_lang_id",
   "type_of_object",
   "transl_object_id",
   "transl_form",
   "transl_grid",
   "transl",
   "transl_plural",
   "tooltip_text",
   "help_text"
)
as


    --control_proc_id:     sf_gui_view_get_gui_views
    --template_id:         without_rights
    --prog_object_item_id: body_gui_transl_nav
    --template_desc:       Get-gui view without role tables to check the rights

    select
       u.usr_id   
      ,v.project_id
      ,v.project_vrs_id                     
      ,v.gui_appl_id
      ,t2.platform
      ,t.appl_lang_id
      ,t.type_of_object
      ,t.transl_object_id
      ,t.transl_form
      ,t.transl_grid
      ,t.transl
      ,t.transl_plural
      ,t.tooltip_text
      ,case when t2.platform = 2 then null else t.help_text end
    from usr u cross join gui_appl v

    -- model table 
    join transl_nav t 
        on t.project_id         = v.project_id
       and t.project_vrs_id     = v.project_vrs_id
       and exists (select 1
                  from usr_role ur
                  where ur.project_id       = t.project_id
                  and ur.project_vrs_id     = t.project_vrs_id
                  and ur.gui_appl_id        = v.gui_appl_id
                  and ur.usr_id             = u.usr_id)


    --control_proc_id:     sf_gui_view_get_gui_views
    --template_id:         join_platform
    --prog_object_item_id: join_platform_gui_transl_nav
    --template_desc:       Join platform

    join platform t2
      on t2.project_id = t.project_id
     and t2.project_vrs_id = t.project_vrs_id
GO

MOD:
 

/* Create view gui_transl_nav. */

create view [dbo].[gui_transl_nav]
(
   "project_id",
   "project_vrs_id",
   "appl_lang_id",
   "type_of_object",
   "transl_object_id",
   "transl_form",
   "transl_grid",
   "transl",
   "transl_plural",
   "tooltip_text",
   "help_text"
)
as


    --control_proc_id:     sf_view_get_gui_views
    --template_id:         sf_view_get_gui_views_gui_transl_nav
    --prog_object_item_id: project_vrs_data
    --template_desc:       Control procedure die alle get_gui views maakt

    select
      t1.project_id, -- project_id,
      t1.project_vrs_id, -- project_vrs_id,
      t1.appl_lang_id, -- appl_lang_id,
      t1.type_of_object, -- type_of_object,
      t1.transl_object_id, -- transl_object_id,  
      t1.transl_form, -- transl_form,
      t1.transl_grid, -- transl_grid,
      t1.transl, -- transl,
      t1.transl_plural, -- transl_plural,
      t1.tooltip_text, -- tooltip_text,
      t1.help_text -- help_text
    from transl_object_transl t1


    --control_proc_id:     sf_view_get_gui_views
    --template_id:         sf_view_get_gui_views_gui_transl_nav_where
    --prog_object_item_id: project_vrs_data_where
    --template_desc:       Control procedure die alle get_gui views maakt

    where t1.type_of_object in ( 6,  -- module_grp
                                12,  -- list_bar
                                13,  -- gui_object
                                87, -- tile_grp
                                294) -- menu
      or t1.type_of_object = 0
        and (
              exists (
                select 1
                from list_bar_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.tab_id      = t1.transl_object_id)
              or exists (
                select 1
                from module_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.tab_id      = t1.transl_object_id)
              or exists (
                select 1
                from tile i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.tab_id      = t1.transl_object_id)
            )

      or t1.type_of_object = 8
        and (
              exists (
                select 1 
                from list_bar_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.process_id  = t1.transl_object_id)
              or exists (
                select 1
                from module_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.process_id  = t1.transl_object_id)
              or exists (
                select 1
                from tile i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.process_id      = t1.transl_object_id)
            )

      or t1.type_of_object = 10
        and (
              exists (
                select 1
                from list_bar_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.report_id   = t1.transl_object_id)
              or exists (
                select 1
                from module_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.report_id   = t1.transl_object_id)
              or exists (
                select 1
                from tile i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.report_id      = t1.transl_object_id)
            )

      or t1.type_of_object = 11
        and (
              exists (
                select 1
                from list_bar_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.task_id     = t1.transl_object_id)
              or exists (
                select 1
                from module_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.task_id     = t1.transl_object_id)
              or exists (
                select 1
                from tile i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.task_id      = t1.transl_object_id)
            )
      or t1.type_of_object = 281
        and (
              exists (
                select 1
                from list_bar_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.tab_variant_id      = t1.transl_object_id)
              or exists (
                select 1
                from module_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.tab_variant_id      = t1.transl_object_id)
              or exists (
                select 1
                from tile i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.tab_variant_id      = t1.transl_object_id)
            )

      or t1.type_of_object = 278
        and (
              exists (
                select 1
                from list_bar_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.report_variant_id   = t1.transl_object_id)
              or exists (
                select 1
                from module_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.report_variant_id   = t1.transl_object_id)
              or exists (
                select 1
                from tile i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.report_variant_id      = t1.transl_object_id)
            )

      or t1.type_of_object = 291
        and (
              exists (
                select 1
                from list_bar_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.task_variant_id     = t1.transl_object_id)
              or exists (
                select 1
                from module_item i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.task_variant_id     = t1.transl_object_id)
              or exists (
                select 1
                from tile i  
                where i.project_id      = t1.project_id
                  and i.project_vrs_id  = t1.project_vrs_id
                  and i.task_variant_id      = t1.transl_object_id)
            )


GO

I don’t know if it helps but another thing that I found is that when I run the below script in IAM or TSF database then I see no results but when I run it on MOD database then it gives me correct result:
 

select * from gui_transl_nav where project_vrs_id='7.0' and transl_object_id = 'projectbeheer'