Need assistance on the Advance reference qualifier

[dhineshkumar]

when I selects the YES (do you know the location or not) location records should be show, if no all location records are empty. Based on the location its shows the device. Please help me with this task. Device reference table is alm_hardware. The table alm_hardware have the location field.

Thank you.

[Kavita_Bhojane]

Hi @dhineshkumar ,

You can call below function in reference qualifier:

function getLocations(know_location) {
    var strQuery = '';
    if (know_location == 'Yes') {
        strQuery = 'sys_idISNOTEMPTY';
    } else {
        strQuery = 'sys_idISEMPTY';
    }
    return strQuery;
}

Please mark my answer helpful and accept as a solution if it helped 👍✔️

Thanks,
Kavita Bhojane

[prit123]

Based on location if you want device to be displayed, in device variable Try-

javascript&colon;'location!=NULL^location='+current.variables.<locationvariablename>

If 'do you know the location or not'  is Yes, then do you want all location to be shown ? 

And If No, no records should display?

[dhineshkumar]

@prit123 

Thanks for replay. How Can I applyt he script include here. When I select the any location, based on the location the device should be shown. How we can apply this.

Thank you.

[Jaspal Singh]

Hi Dinesh,

Looking at the use case there is no need to you to complicate and call a script include. Why not leverage oob functionality for limiting records on basis of selected value from dependant field.