I had the same issue, where I wanted to only display certain rows based on a given criteria ... essentially generating a dynamic WHERE statement, which overrides the parameter value in the menu parameter.
I have changed the source code (cant seem to upload an attachment ... see
www.perfumedrop.com.au/catalog.pdf) changes marked as Bruce, or just copy the whole thing for components/com_joodb/models/catalog.php to include an additional parameter "whereovr" that can be passed when you invoke the component. Essentially you pass the criteria for your where statement eg. Usrid=2
I am using Community Builder Profile Pro, and therefore embedded the call to the joodb module using another plugin "Include Component". Thereby you are able to dynamically call the joodb catalog view from any article etc. passing the required data. Call is the same as the URL for menu call, and mine looks like: {component url='/index.php?option=com_joodb&view=catalog&Itemid=61&whereovr=centre={fld cb_spgroup}'}
Note: If you are intending to call from Community Builder Pro, there was another issue to be resolved that can be found at:
www.joomduck.com/support-forum/community...gin-code/page-2.html I am using Joomla 1.5 and latest version of Joodb.
Hope this is of assistance ... has helped me heaps.
