# Report definition condition

**URL:** <https://forums.pega.com/t/report-definition-condition/2484>\
**Category:** User Experience\
**Tags:** reporting, user-experience, pega-platform\
**Created:** [April 12, 2022, 9:24am UTC](https://forums.pega.com/t/report-definition-condition/2484 "2022-04-12T09:24:10Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![kumars57](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumars57](https://forums.pega.com/u/kumars57)\
**Post date:** [April 12, 2022, 9:24am UTC](https://forums.pega.com/t/report-definition-condition/2484/1 "2022-04-12T09:24:10Z")

</div>

How to add filter condition in report so that it can fetch only those data for particular operator which is created after some particular date? Before data it cannot fetch.

---

<div class="post-metadata">

**Author:** ![SanthoshRanga](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/santhoshranga/32/3113_2.png) [@SanthoshRanga](https://forums.pega.com/u/SanthoshRanga)\
**Post date:** [April 12, 2022, 11:00am UTC](https://forums.pega.com/t/report-definition-condition/2484/2 "2022-04-12T11:00:08Z")

</div>

@kumars57 You can make use of **pxCreateDateTime** column value in the filter condition.

---

<div class="post-metadata">

**Author:** ![kumars57](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumars57](https://forums.pega.com/u/kumars57)\
**Post date:** [April 12, 2022, 12:32pm UTC](https://forums.pega.com/t/report-definition-condition/2484/3 "2022-04-12T12:32:47Z")

</div>

@SanthoshRanga My required condition is it does contain data of operator for past date than yesterday after that it can show the data of that operator.

---

<div class="post-metadata">

**Author:** ![SanthoshRanga](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/santhoshranga/32/3113_2.png) [@SanthoshRanga](https://forums.pega.com/u/SanthoshRanga)\
**Post date:** [April 12, 2022, 12:49pm UTC](https://forums.pega.com/t/report-definition-condition/2484/4 "2022-04-12T12:49:12Z")

</div>

@kumars57 Could you please elloborate or send screenshot to better understand your scenario.

---

<div class="post-metadata">

**Author:** ![ShyjuValappil](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/shyjuvalappil/32/14753_2.png) [@ShyjuValappil](https://forums.pega.com/u/ShyjuValappil)\
**Post date:** [April 12, 2022, 12:52pm UTC](https://forums.pega.com/t/report-definition-condition/2484/5 "2022-04-12T12:52:34Z")

</div>

@kumars57

Could you please provide details on what is the data of the operator? Is it the cases created by the operator? or Operator details like operator name, email etc…?

---

<div class="post-metadata">

**Author:** ![RojaP775](https://avatars.discourse-cdn.com/v4/letter/r/f475e1/32.png) [@RojaP775](https://forums.pega.com/u/RojaP775)\
**Post date:** [April 13, 2022, 1:52am UTC](https://forums.pega.com/t/report-definition-condition/2484/6 "2022-04-13T01:52:47Z")

</div>

@kumars57

Create a Report Definition in Data-Admin-Operation-id Class

In the filter conditions add a condition .pxCreatedatetime greater than the required date to fetch the operators created after the particular date.

---

<div class="post-metadata">

**Author:** ![kumars57](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumars57](https://forums.pega.com/u/kumars57)\
**Post date:** [April 13, 2022, 6:06am UTC](https://forums.pega.com/t/report-definition-condition/2484/7 "2022-04-13T06:06:48Z")

</div>

@ShyjuValappil case is created by the operator. Report should not fetch data before “4/12/22 2:01 PM” of particular operator like “abc” and can fetch data of others .It should fetch data of all after that date.

---

<div class="post-metadata">

**Author:** ![ShyjuValappil](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/shyjuvalappil/32/14753_2.png) [@ShyjuValappil](https://forums.pega.com/u/ShyjuValappil)\
**Post date:** [April 13, 2022, 10:39am UTC](https://forums.pega.com/t/report-definition-condition/2484/8 "2022-04-13T10:39:42Z")

</div>

@kumars57

Could you please try the filter as below for F2 and F3?

Please update relationship to **Greater than** and value from **Yesterday** to a specific date if that is the requirement.

 ![Filter condition.png](https://pega1.discourse-cdn.com/pega/original/2X/4/431099ad76569d9defa1efcf251c7e58ff67b57e.png)

---

<div class="post-metadata">

**Author:** ![kumars57](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumars57](https://forums.pega.com/u/kumars57)\
**Post date:** [April 13, 2022, 5:55am UTC](https://forums.pega.com/t/report-definition-condition/2484/9 "2022-04-13T05:55:10Z")

</div>

@SanthoshRanga

 ![Screenshot.jpg](https://pega1.discourse-cdn.com/pega/original/3X/8/0/80c3fcf73878c577f864c884e7249ffd75d2b900.jpeg)