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)
Answer
Boolean filter
Best answer by Naveen Boga
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!!
+19Hi
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
+19@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);
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.