BAQ Prompt

I am wanting to add a prompt to my BAQ that shows our CIP project spending. Right now, it will show everything to date. I’d like to be able to run this BAQ to go back and pull all data through the month specified. Any help would be great!

Just need to create a month parameter to set the Start and End dates based on month :slight_smile: to limit the results returned or to filter after my preference is the former.

2 Likes

I am not quite sure how to create a parameter.

Actions > Define Parameters

At least in 2024.1, the only place I have able to find it in the browser is by adding a condition, getting the Parameter slide out, and then adding it. Maybe it’s available somewhere else, but I haven’t seen it.

2 Likes

Ahhh, not on 20XX version yet so TY for that information @Mark_Wonsil! They have no info on their profile yet :confused:

1 Like

Hopefully that’s not something new in 2024.1 … in 2023.2, it’s in the dropdown menu at the top-right of the BAQ designer:
image

4 Likes

Feeling It Charlie Day GIF by First We Feast

4 Likes

Small reminder how to filter dates efficiently

7 Likes

That is so cool I just did this a couple hours ago…

1 Like