Filtering a query field with a dropdown on the profile view without editing??

so i made a query field that gets info from the database for hockey match results and i'd like for the users to filter the results based on a months dropdown list directly on the profile.
i could create a code field with the list but then i'm not sure how to pass the dropdown value to the query field. Any insight on the best way to proceed would be greatly appreciated.

You want a query field to update its results when the dropdown value changes? Yes, that's doable but only in profile edit or registration. This is done using the "Update On" functionality in CB Core Fields Ajax by having the query field update when the dropdown field changes (you'd select the dropdown field in the update on of the query field).

well so far i got the following code which creates my dropdown and when i select a new month it reloads the page on the correct tab.
I created a query field that get the correct information based on a text field with the month number in it.

The only thing i'm missing is to update the month text field in the data base before i reload the page:

Any insight would be appreciated:

You most likely already have a function somewhere for the ajax field that i can call up instead building my own ... which would be better to use for update purposes and security. i'm guessing something like this would work with the correct info filled in :

function performAjaxUpdate() {
$.ajax({
url: 'test.php',
method: 'POST',
data: {
action: 'save',
field: $("#db_field").val(),
val: $("#db_value").attr()
},
dataType:'json',
success: function(data) {
alert(data.success);
}
});
return false;
}

I don't understand what you're trying to do. Why are you building a dropdown with PHP? Your dropdown values are static so a standard select field should be sufficient. If you need dropdown values from PHP you can use CB Code Field and its Code Select fieldtype. If you want to be able to edit the field from profile view with ajax you can use CB Core Fields Ajax for that (see Integrations > CB Core Fields Ajax parameters while editing your select field).

Well what i want to do is to add a dropdown FILTER to display hockey montly stats (and i'll mostly a year/season filter too) in the profile view.(Yes i could have tried a dropdown with cbajax but it felt convoluted on the profile view.)

i have a cb query that gets the corrects stats based on a month variable (a simple text field as of now)