find repositories after certain date.

[santhosh kumar challa]

Trying to find all repositories with text alter table except some repositories after this date. the below search don't work.

alter table -repo:apple -repo:orange -repo:gauva repo:contains.commit.after(june 25 2020) ext:sql  

[Patrik S]

Hello @santhosh kumar challa ,

Thank you for reaching out to Atlassian Community!

I'm afraid that Code Search in bitbucket cloud does not currently have any modifier to filter based on the date.

You can check the available modifiers/filter in the following documentation : 

• https://confluence.atlassian.com/bitbucket/code-search-in-bitbucket-873876782.html

Based on the above, you can only filter your query to Include or Not include a given repository, but not based on date. Please allow me to share some examples : 

• Include just repos apple, orange and gauva :
  

  repo:apple repo:orange repo:gauva search-term

• Include all the repos except repository called apple

  search-term NOT repo:apple

Let me know in case you have any questions.

Thank you, @santhosh kumar challa .

Kind regards,

Patrik S

[santhosh kumar challa]

Hi Patrik,

Thanks for the quick reply.

Can we also do this?

Trying to find all repositories with text "alter table" except some repositories after this specific date. the below search don't work.

alter table -repo:apple -repo:orange -repo:gauva repo:contains.commit.after(june 25 2020) ext:sql  

[Patrik S]

Hello @santhosh kumar challa ,

As I mentioned in my previous answer, Code Search in bitbucket does not currently support filtering the repositories by date. I went ahead and created a feature request to implement this functionality: 

• https://jira.atlassian.com/browse/BCLOUD-22006

I would suggest you to add your vote there, since this helps both developers and product managers to understand the interest. Also, make sure you add yourself as a watcher in case you want to receive first-hand updates from that ticket. Please note that all features are implemented with this policy in mind

Thank you, @santhosh kumar challa .

Kind regards,

Patrik S