#region UsrProjectTaskFilterLabor
public abstract class usrProjectTaskFilterLabor : PX.Data.BQL.BqlString.Field<usrProjectTaskFilterLabor> { }
[PXDBString]
[PXUIField(DisplayName = Messages.ProjectTask)]
[PXSelector(
typeof(Search<PMTask.taskCD,
Where<PMTask.projectID, Equal<Current<DailyFieldReport.projectId>>,
And<PMTask.status, NotEqual<ProjectTaskStatus.planned>,
And<Where<Current<DailyFieldReportExt.usrBranchIDFilterLabor>, Equal<Null>,
Or<PMTask.defaultBranchID, Equal<Current<DailyFieldReportExt.usrBranchIDFilterLabor>>>>>>>>),
typeof(PMTask.taskCD),
typeof(PMTask.description),
ValidateValue = false)]
public virtual string UsrProjectTaskFilterLabor { get; set; }
#endregion
And<Where<Current<DailyFieldReportExt.usrBranchIDFilterLabor>, Equal<Null>,
Or<PMTask.defaultBranchID, Equal<Current<DailyFieldReportExt.usrBranchIDFilterLabor>>>>»
Does not work. I have rows in database for my condition. But selector return 0 rows. When i delete
And<Where<Current<DailyFieldReportExt.usrBranchIDFilterLabor>, Equal<Null>,
Or<PMTask.defaultBranchID, Equal<Current<DailyFieldReportExt.usrBranchIDFilterLabor>>>>»
this condition its work. But i need this condition
Selector does not work correctly
Best answer by bihalivan15
#region UsrProjectTaskFilterLabor
public abstract class usrProjectTaskFilterLabor : PX.Data.BQL.BqlString.Field<usrProjectTaskFilterLabor> { }
[PXDBString]
[PXUIField(DisplayName = Messages.ProjectTask)]
[PXSelector(typeof(SearchFor<PMTask.taskCD>.
In<
SelectFrom<PMTask>.
Where<PMTask.projectID.IsEqual<DailyFieldReport.projectId.FromCurrent>.
And<PMTask.status.IsNotEqual<ProjectTaskStatus.planned>>.
And<DailyFieldReportExt.usrBranchIDFilterLabor.FromCurrent.Value.IsNull.
Or<PMTask.defaultBranchID.IsEqual<DailyFieldReportExt.usrBranchIDFilterLabor.FromCurrent>>>>>),
typeof(PMTask.taskCD),
typeof(PMTask.description),
ValidateValue = false)
]
public virtual string UsrProjectTaskFilterLabor { get; set; }
#endregion
its work for me. Use FromCurrent.Value.IsNull. and its work :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.



