The xml returned by .do?SCHEMA is an empty xml in the table 'sys_query_index_hint'

SiddharthR69750
Tera Contributor

Screenshot 2024-09-22 at 10.24.45 AM.png

This table has some columns but when the schema is queried, it returns an empty xml. Can anyone please help me with this issue ?

1 REPLY 1

Akash4
Kilo Sage

Hi Siddharth,

This could be due to restriction in system. Try adding business rule for testing purpose:

- var grDict = new GlideRecord('sys_dictionary');
grDict.addQuery('name', 'sys_query_index_hint');
grDict.query();
while (grDict.next()) {
gs.log(grDict.element + " - " + grDict.column_label);
}

 

if the log appears on system logs, then we do have access to schema dict values, your requirement is achievable somehow (can be discussed after above results)

Happy learning!