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

[SiddharthR69750]

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

[Akash4]

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!