How to find out on which form VIEW a field is present?

[Suggy]

On a table, there are 15 VIEWS created. I need to seach for a field say 'ABC'.

How to know in which of the 15 views this field 'ABC' is avaialble.

I checked form views, sections, elements etc etc.. but couldnt find a way 😞

Appreciate if you can help 🙂

[Dr Atul G- LNG]

Hi @Suggy 

I think OOTB , there is no option to get that. 

[Mark Manders · Accepted solution]

This may get you started, but please, check all the variables.

var viewGR = new GlideRecord('sys_ui_view');
viewGR.addQuery('name', 'my_table');
viewGR.query();
while (viewGR.next()) {
    var sectionGR = new GlideRecord('sys_ui_section');
    sectionGR.addQuery('view', viewGR.sys_id);
    sectionGR.query();
    while (sectionGR.next()) {
        var elementGR = new GlideRecord('sys_ui_element');
        elementGR.addQuery('section', sectionGR.sys_id);
        elementGR.addQuery('element', 'my_field');
        elementGR.query();
        if (elementGR.next()) {
            gs.print('View "' + viewGR.getValue('name') + '" contains "my_field".');
        }
    }
}

[Suggy]

So there is no easy way? One should use a script for that 😞

[Danish Bhairag2]

Hi @Suggy ,

If u are not comfortable with the script then u can better check each view manually by opening from the record or u can open form designer n from there u can change views of the form n check manually.

Thanks,

Danish