I have two search forms set here under their own menu items:
- WCI Search / works
- FTI Search / works
BUT WHEN I try stacking these two searches as modules per e.g.: Stacked Modules of List Searches I get NO RESULT
Try these searches:
WCI enter: WCI-CBG-A23 or see here
FTI enter: CBS-10-1-N-23F or see here
They don't work when stacked! any ideas?
In my FTI search I am using the search query field with this MySQL select command:
SELECT a.wci_sku, b.fti_sku, b.description, a.qty_onhand
FROM #__cck_free_form_xref_qty AS a
JOIN #__cck_free_form_xref AS b
ON a.fti_sku = b.fti_sku
WHERE [MATCH]a.fti_sku||$uri->getValue('x_fti_sku')[/MATCH]
-----
I would prefer to combine these as one form and simply tweak the MySQL select command, so
- IF one is search for WCI # then the mysql code reflects IF WCI form input field EXISTS or
- IF one is search for FTI # then the mysql code reflects IF FTI form input field EXISTS
but not sure how to add IF EXISTS when regarding an entry into the input field.
Hmmm ... the Seblod List / Search when used as a MODULE only seems to produce the proper search result when setting to:
Menu Item Target = The same List Search set as a menu item
As far as I have tested anyways