Question

What is IFS database table for Help Description in Context pane

  • 9 March 2022
  • 5 replies
  • 248 views
T
Rank
Userlevel 2
Badge +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
Rank
Userlevel 7
Badge +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

 

 

-Kelum Niranjana
K
Rank
Userlevel 5
Badge +15

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

Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
T
Rank
Userlevel 2
Badge +3

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
Rank
Userlevel 7
Badge +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 %';

-Kelum Niranjana
T
Rank
Userlevel 2
Badge +3

Hi @Kelum Pradeep Kumara 

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

 

 

Terms & ConditionsCookie settings