# 'Has ever been an SQL'

**URL:** <https://community.hubspot.com/t/has-ever-been-an-sql/74242>\
**Category:** Dashboards & Reporting\
**Tags:** reports\
**Created:** [February 1, 2023, 1:29pm UTC](https://community.hubspot.com/t/has-ever-been-an-sql/74242 "2023-02-01T13:29:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![OBeagley](https://avatars.discourse-cdn.com/v4/letter/o/5daacb/32.png) [@OBeagley](https://community.hubspot.com/u/OBeagley)\
**Post date:** [February 1, 2023, 1:29pm UTC](https://community.hubspot.com/t/has-ever-been-an-sql/74242/1 "2023-02-01T13:29:34Z")

</div>

Hello. I’m looking to create a report to show the number of SQLs that each BD rep has introduced to the pipeline in 2023. The problem I have is that as soon as the contact is moved onto the next stage of the funnel, they are no longer an SQL, and therefore the report I have already made becomes invalid.

I would like to make a report to show all contacts that **have ever been an SQL** this year. Is there a way to do this? Thanks

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [February 1, 2023, 1:32pm UTC](https://community.hubspot.com/t/has-ever-been-an-sql/74242/2 "2023-02-01T13:32:00Z")

</div>

Hi @OBeagley,

When contacts enter the SQL lifecycle stage, this date gets populated:

 ![karstenkoehler_0-1675258239494.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/7/170aaef15354f94f28a97ea9c331286c1060d52d.png)

This date stays populated even after the contact changes their lifecycle stage, it only gets cleared when the _Lifecycle stage_ gets cleared.

When you filter for ‘is known’ you’ll get all contacts who have ever been SQL. You can also filter for specific date ranges.

Best regards!