Multiple Queries

adamgonzalez1984

Hello all,

I was hoping someone can point me in the right direction. I am trying to update multiple queries based on one drop down list. Basically someone clicks on a "change campaign" button that brings a popup window with a single drop down with the campaigns that the user has created. I need for the 4 different queries to get updated simultaneously based on what the user chooses from the drop down. Can someone offer some suggestions as to how to accomplish this? Thanks in advance!

-Adam

for reference...

aware_support

Your popup window is presumably implemented as a process. You need to go to the Auto Refresh options of each of the queries (this is in the Details dialog of the query editor) you want to update and add the process to the list of processes that cause query refresh.

Obviously, the queries themselves have to depend on the information selected in the drop down.

adamgonzalez1984

Good Suggestion!. I'm not sure what the query would look like to make it depend on the information selected in the drop down. I guess that is at the core of my problem. Thanks!

rocketman

The query itself doesn't have to change.

Let's assume the process looks like

Here's an example from my app.

The Office administrator calls up the form for a Flying gift voucher sale which appears on the left of the screen. On the right of the screen is a list of gift vouchers together with the date on which the holder is coming to fly, at the bottom of which are the "unallocated" vouchers (ie no flying slot allocated)

The Office Admin then puts a flying date into the voucher form on the left and presses "Save" . Because the query list is set to "Auto Refresh" She will then immediately see on the right, the record for that voucher disappear from the unallocated section and appear in the appropriate date slot.

Hope this helps

rocketman

Sorry ... should have added - The list is a simple query of the voucher BO sorted in date order. As soon as something changes the date on an existing voucher, the list automatically gets refreshed.

The "something" can either be editing an existing record, adding a new one, or simply changing any of the attributes from within a process or a BO "Rule"

Once you have grasped what Auto Refresh can do, you'll be amazed at what you can achieve.

Good Luck

adamgonzalez1984

Rocketman, thanks for the input. I think it applies to my situation but not fully. I'm having a difficult time understanding how a single drop down would filter the 4 queries at the same time. I understand that I can auto refresh the 4 queries but I need the 4 queries to be dependent on what is chosen in the drop down. I am going to have different movie campaigns in that drop down list and when the user selects a movie campaign from that list It is going to update those 4 queries based on what movie campaign they chose. The queries are just showing what products are associated with that movie campaign. The 4 queries are basically just telling me in what department the product is currently in. We have 4 different departments so that's why there are 4 queries. So the auto refresh this is awesome but I don't think it solves my core issue. I really appreciate the help. Thanks.

-Adam

tford

Adam,

Do your 4 queries work today when based on the first value of your popup and you are looking to get the query values to change when the popup changes?

adamgonzalez1984

No, the queries do not work right now. they are just showing me all products of all campaigns upon login and it doesn't matter what is chosen in the drop down. When I do choose something in the drop down and press search the 4 queries disappear and just a single table appears with the query results. thanks!

tford

One way to solve this:

1) Have the user select a Campaign in RegularUser BO Form.

The form can have "Hide buttons" checked

The Campaign attribute of RegularUser can have "Save form when selection changes" checked

2) Create a process:

VIEW LoggedInRegularUser USING 'Pick Campaign

3) Place this process in the first Content Panel of your VP.

4) In your first query use something like:

FIND CampaignDetails WHERE CampaignDetails.Campaign=LoggedInRegularUser.Campaign

This query will have Auto Refresh for RegularUser BO

5) Place this query in the 2nd Content Panel of the VP created in #3.

6) Follow steps #4 and #5 for your other 3 queries.

When testing it, you should now find that:
1) Your campaign selection is on the same screen as your 4 queries. Users will always know which Campaign the queries are for.

2) As soon as your change the Campaign drop down, it will automatically save the form and refresh all of the queries.

rocketman

..... Looks good to me Tom.