Filtering the recrods with NULL Value using Power Prompts

[vinay17in]

We are using PowerPrompts for our report which has catalog folder as 'MyReport'. The report has field named as 'Position' which can have null values. And we need to filter our recrods where Report Field 'Position' is null. We have tried out following options without any sucess:

GetQuery().AndFilterBy('[\MyReport\Position] is null');

GetQuery().AndFilterBy('[\MyReport\Position] is Null');

GetQuery().AndFilterBy('[\MyReport\Position] is '+'');

Please suggest us the correct way to filter the recrods which has null values.

Regards,

 

[vinay17in]

We have to do this as shown here
GetQuery().AndFilterBy("[\MyReport\Position]ismissing"
Regards,