Hi there I have a question about schedules How can I fetch s

Question

Hi there I have a question about schedules How can I fetch schedules for a flow group and specific parameters Example I have very many schedules If I fetch with this query it will be a lot of data for the client I need to fetch with a filter based on targetProjectId from parameter defaults see the image It is possible Thanks ```query GetSchedules flow group where id eq eb595947 xxxxxx schedule ```

Kevin Kho · Answer

Hey < Denis Pokotylyuk External > this is quite tricky I ll try it

Kevin Kho · Answer

I am unsure where you are querying from but for the first one you gave you can do ```query GetSchedules flow group where id eq 7fb20810 cd37 41cf 9b04 218c284f6db5 default parameters contains x something else schedule default parameters ```

Kevin Kho · Answer

Are these parameters created on the Flow group UI or through code

Kevin Kho · Answer

You really this might be easier to just bring in Python and manipulate there

Denis Pokotylyuk(External) · Answer

I create schedules by using graphQL mutation ```set flow group schedule```

Kevin Kho · Answer

I think my query might be enough then to point you in the right direction I hope

Denis Pokotylyuk(External) · Answer

default parameters for my flow group is empty ```query GetSchedules flow group where id eq eb595947 xxxxx default parameters ``` ``` data flow group default parameters ``` How can I query on that then

Denis Pokotylyuk(External) · Answer

```default parameters contains x something else ``` What is x something else in my case slightly smiling face

Denis Pokotylyuk(External) · Answer

parameter defaults and default parameters are different things right

Kevin Kho · Answer

Ah ok I was setting it here

Kevin Kho · Answer

I guess you set it from the clock on the Flow

Denis Pokotylyuk(External) · Answer

But these parameters will be the same for all schedules under the flow group right

Kevin Kho · Answer

They will I was just thinking you set it here There s just a couple of places to set sweat smile

Denis Pokotylyuk(External) · Answer

I need to filter by parameters which are not common Some schedules will be set for a targetProjectId = 2 some schedules for targetProjectId = 3 and I need to fetch schedules for specific targetProjectId since it will be very many schedules If you understand slightly smiling face

Kevin Kho · Answer

Are you filtering on the Flow run level or on the schedule level

Denis Pokotylyuk(External) · Answer

I need to filter on schedule level When I create a schedule for a flow group by set flow group schedule or in UI I register some parameters Then I want to get all schedules with specific parameters

Kevin Kho · Answer

Ok

Kevin Kho · Answer

So I have this

Kevin Kho · Answer

And I want to try just pulling `value two`

Denis Pokotylyuk(External) · Answer

Yes exactly slightly smiling face

Denis Pokotylyuk(External) · Answer

all with p value two

Kevin Kho · Answer

Yeah I m not positive this can be done unfornately because the kost you can do it check the `clocks` Not something as nester as this You d have to execute that in Python

Denis Pokotylyuk(External) · Answer

Ok understand But can it be done in Python How then Do you have a link to the related docs

Kevin Kho · Answer

```from prefect client import Client query = query flow where id eq 608f7f60 cc0d 4abc a63a bb653ff2c1e5 id schedule client = Client res = client graphql query print res data ```

Kevin Kho · Answer

You can use the Prefect Client and then `res data ` will be a dictionary you can manipulate

Denis Pokotylyuk(External) · Answer

But this is actually the same query It gets all the schedules but then it is just to filter out right

Denis Pokotylyuk(External) · Answer

Thank you a lot for helping me btw heart

Kevin Kho · Answer

Yes exactly filter it in Python because we can t do it at the query level

Kevin Kho · Answer

Of course

Denis Pokotylyuk(External) · Answer

Ok the problem that I can have hundreds of schedules and I wanted to filter it on query level thinking face I do not like the idea to fetch the whole list of schedules

Kevin Kho · Answer

I don t think we have a choice here because the GraphQL can t filter on that But actually you might have another problem It works like this Prefect schedules the next 10 flow runs for a given flow The scheduler runs every 90 seconds So let s say you have 20 scheduled runs in the next minute only 10 will be schedules and the other 10 will not be because of the cap in the number of runs that will be scheduled After 10 20 run the scheduler will run again and then you ll get another 10 20

Kevin Kho · Answer

So for a given Flow if you are firing them concurrently you can only have a max of 10 schedules Does that make sense

Denis Pokotylyuk(External) · Answer

gt But if I run every schedules about once or twice a day not so very often Can I have more than 10

Kevin Kho · Answer

I think as long as you don t have more than 10 in a two minute time frame it should be fine

Kevin Kho · Answer

But yes this is unrelated to the graphql lol I don t think you have a choice there because it can t be filtered on the query level

Denis Pokotylyuk(External) · Answer

Ok I think I have to spread them over time slightly smiling face

Denis Pokotylyuk(External) · Answer

I see Thank you very much for your time Nice support through the Slack Now it is a bed time yawning face

Kevin Kho · Answer

Of course slightly smiling face