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)
Best answer by Naveen Boga
View original
Userlevel 7
+17
Hi
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)]
[PXUIField(DisplayName = "Active")]
public virtual bool? Status { get; set; }
public abstract class status : BqlBool.Field<status> { }
#endregion
Hope this helps!!
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
+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);
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.