Boolean filter

  • 9 March 2021
  • 3 replies



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)


Best answer by Naveen Boga 9 March 2021, 20:05

View original

3 replies

Userlevel 7
Badge +17

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
        [PXDefault(false, PersistingCheck = PXPersistingCheck.Nothing)]
        [PXUIField(DisplayName = "Active")]
        public virtual bool? Status { get; set; }
        public abstract class status : BqlBool.Field<status> { }


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 

Userlevel 7
Badge +17

@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([DACField.Field1], false);



About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved