The xml returned by .do?SCHEMA is an empty xml in the table 'sys_query_index_hint'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2024 10:00 PM
This table has some columns but when the schema is queried, it returns an empty xml. Can anyone please help me with this issue ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2024 02:21 PM
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!