fudge4u
Member
I would like to create a prefilter to display only records of items which match a value contained within the user's profile.
I created a field in the user's profile {vp3db_comprofiler_fields___cb_dcn}. This contains a "1" or "0" to indicate the items they are permitted to view in a list.
The list I want to join has a field {new_mcdc_items___mcdc_dcn_item} which has a "1" or "0" to indicate when that item is to be displayed.
So, when the user logs in and selects the menu to see a list of items available to them, I only want to display the items where the value of "mcdc_dcn_item" matches the value of "cb_dcn" from their profile.
I created a field in the user's profile {vp3db_comprofiler_fields___cb_dcn}. This contains a "1" or "0" to indicate the items they are permitted to view in a list.
The list I want to join has a field {new_mcdc_items___mcdc_dcn_item} which has a "1" or "0" to indicate when that item is to be displayed.
So, when the user logs in and selects the menu to see a list of items available to them, I only want to display the items where the value of "mcdc_dcn_item" matches the value of "cb_dcn" from their profile.