Skip to main content
Question

What is IFS database table for Help Description in Context pane


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 comments

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+16
  • Superhero (Partner)
  • 401 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?

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings