[
(contains(@Status,$Param1)or(string-length($Param1)=0)) and
(contains(@OperatorName,$Param2)or(string-length($Param2)=0)) and
(contains(@Month,$Param3)or(string-length($Param3)=0)) and
(contains(@Year,$Param5)) and
(contains(@Purpose_x0020_of_x0020_Data,$Param4)or(string-length($Param4)=0))
]
[((number(ddwrt:FormatDateTime(ddwrt:FormatDate(string(@TrainedOn),1033,1),1033,'yyyyMMdd'))>=number(ddwrt:FormatDateTime(ddwrt:FormatDate(string($Param1),1033,1),1033,'yyyyMMdd'))) or (string-length($Param1)=0)) and
((number(ddwrt:FormatDateTime(ddwrt:FormatDate(string(@TrainedOn),1033,1),1033,'yyyyMMdd'))<number(ddwrt:FormatDateTime(ddwrt:FormatDate(string($Param2),1033,1),1033,'yyyyMMdd'))) or (string-length($Param2)=0)) and
(contains(@User,$Param3)or(string-length($Param3)=0)) and
(contains(@User,$Param4)or(string-length($Param4)=0)) and
(contains(@TrainedOn,$Param5)or(string-length($Param5)=0))]
(contains(@Status,$Param1)or(string-length($Param1)=0)) and
(contains(@OperatorName,$Param2)or(string-length($Param2)=0)) and
(contains(@Month,$Param3)or(string-length($Param3)=0)) and
(contains(@Year,$Param5)) and
(contains(@Purpose_x0020_of_x0020_Data,$Param4)or(string-length($Param4)=0))
]
[((number(ddwrt:FormatDateTime(ddwrt:FormatDate(string(@TrainedOn),1033,1),1033,'yyyyMMdd'))>=number(ddwrt:FormatDateTime(ddwrt:FormatDate(string($Param1),1033,1),1033,'yyyyMMdd'))) or (string-length($Param1)=0)) and
((number(ddwrt:FormatDateTime(ddwrt:FormatDate(string(@TrainedOn),1033,1),1033,'yyyyMMdd'))<number(ddwrt:FormatDateTime(ddwrt:FormatDate(string($Param2),1033,1),1033,'yyyyMMdd'))) or (string-length($Param2)=0)) and
(contains(@User,$Param3)or(string-length($Param3)=0)) and
(contains(@User,$Param4)or(string-length($Param4)=0)) and
(contains(@TrainedOn,$Param5)or(string-length($Param5)=0))]
No comments:
Post a Comment