QueryBuildRange class to filter with never date in AX 2012 or D365
Hi, qbdsHcmPositionDetail.addRange(fieldnum(HcmPositionDetail,ValidTo)).value(date2str(dateMax(), 321, DateDay::Digits2, DateSeparator::Hyphen, DateMonth::Digits2, DateSeparator::Hyphen, DateYear::Digits4));This is used for Valid Time State Tables particularly. Regards,
Greater than or euqal to / Less than or equal to (=) in Query class in AX 2012 or D365
Hi, Greater than or equal to:queryBuildDataSource.addRange(fieldNum(HcmPositionWorkerAssignment,ValidTo)); queryBuildRange.value(SysQuery::range(today(), dateMax())); or queryBuildDataSource.addRange(fieldNum(HcmPositionWorkerAssignment,ValidTo)); queryBuildRange.value((queryRange(today(), dateMax())); Less than or equal to: queryBuildDataSource.addRange(fieldNum(HcmPositionWorkerAssignment,ValidTo)); queryBuildRange.value(SysQuery::range( dateNull(), today())); or queryBuildDataSource.addRange(fieldNum(HcmPositionWorkerAssignment,ValidTo)); queryBuildRange.value((queryRange(dateNull(), today())); Regards,