Skip to main content

hello

today i’m trying something new 

i have a boolean filter but in the Filters i need a condition like :

if the boolean is true (field is not null) and id the boolean is false the (field is null)

Hi @khairi ,

 

For the filter DAC field, you can give PXDefault(false) so that the default will be false (In this case, no need of checking for NULL condition). Below is an example for reference.

 

 #region Status
        ÂPXBool()]
        >PXDefault(false, PersistingCheck = PXPersistingCheck.Nothing)]
        bPXUIField(DisplayName = "Active")]
        public virtual bool? Status { get; set; }
        public abstract class status : BqlBool.Field<status> { }
        #endregion

 

Hope this helps!!


@Naveen B 

thank you for responding 

the request was a check box (true or false) to filter in LegalGeneralLedgerGLTran.Matching

null or not null and i need to do that with report designer 


@khairi Then you can ISNULL() function. Below is the example for reference.

Below function will work like 

if the field value is NULL then it will consider false otherwise true 

 

Ex: ISNULL(LDACField.Field1], false);

 


Reply