Skip to main content
Question

What is IFS database table for Help Description in Context pane

  • March 9, 2022
  • 5 replies
  • 291 views

Forum|alt.badge.img+3

What is the underlying IFS database table for help description in context pane below?
 

 

This topic has been closed for replies.

5 replies

Kelum Pradeep Kumara
Superhero (Employee)
Forum|alt.badge.img+18

Hi @techifs 
 

As I Know, there is no direct table connected with this help pane as other windows/table windows. Information fetched to this window is saved in language_attribute_tab Table

 

 


Forum|alt.badge.img+17
  • Superhero (Partner)
  • 514 replies
  • March 9, 2022

Hi

 

As the @Kelum Pradeep Kumara pointed this is stored in language_attribute_tab.long_prog_text column with additional format settings. View language_translation_exp might help you to identify filed by path which contains window name, column name, etc


Forum|alt.badge.img+3
  • Author
  • Do Gooder
  • 3 replies
  • March 10, 2022

Hi,

 

I have done a search for below fields with given info.

However , I haven't get the expected result.
Anyone knows what's wrong here?


select lc.context_id,lc.module, lc.path, la.prog_text,la.prog_text_short
  from language_context lc, language_attribute la
 where lc.module = 'ORDER'
   and lc.main_type_db = 'LU'
   and lc.path like 'CustomerOrder%'
   and lc.context_id = la.context_id 
   and la.prog_text like '%automatically displayed%';

 


 

 

 


Kelum Pradeep Kumara
Superhero (Employee)
Forum|alt.badge.img+18

Hi @techifs 
Please try the below query
select lc.context_id,lc.module, lc.path, la.prog_text,la.prog_text_short,la.long_prog_text
  from language_context_tab lc, language_attribute_tab la
 where lc.module = 'ORDER'
   --and lc.main_type_db = 'LU'
   AND lc.path like '%CustomerOrder%'
   and lc.context_id = la.context_id 
   and la.long_prog_text like '%The site is automatically displayed %';


Forum|alt.badge.img+3
  • Author
  • Do Gooder
  • 3 replies
  • March 14, 2022

Hi @Kelum Pradeep Kumara 

Im not getting result for this query either.
Seems data stored in different way?