10 years ago
0
Topic

Hello,

This is my first post.

I have facing problem in searching the comma separated values saved by a dynamic multiple select field from a single select field (in List & Search Type).

Here is the scenario.

I have two Custom Content Types A and B which are saved in Category Cat-A (id 10) and Cat-B (id 11) respectively.
Now, custom content type B contains a field A1 which is a Dynamic Select Field with the following settings (which allows you to select multiple values added in Custom Content Type A)

Name : a_1
Query : Construction
Table : #__content
Where : catid='10' (where 10 is the ID for the category where A1 values are saved)
Order By : title Ascending
Options Name : title
Options Value : id
Rows : 10
Multiple : Yes
Separator : , (comma)
Format / Object : Standard | Article

When I add a new article for Custom Content Type B, I can select multiple values for field A1 (which gets populated with Custom Content Type A Article Titles) and these are saved in the database as comma separated values. - EVERYTHING IS WORKING UPTIL HERE.

Now on the website frontend, I have a List and Search Type for Custom Content Type B, and this time instead of the dynamic multiple select field (A1) as in the admin, I have a single select field (A1-Single) for filtering the results.

Details for A1-Single
Field Type : Article (Related)
Categories : Cat-A (Selected in the list)
Display (Parent) : Link
Content Type (Parent) : Blank
Format / Object : Custom | Free | Custom Content Type B Table Selected | A1 Field Selected
Live Value : Default - (Have tried the other options also but with no result)
Match : Any Words Exact with Separator , (comma) - (Have tried the other options also but with no result)

I have not been able to get the correct records for my search. Any help would be greatly appreciated.

Joomla Version :  3.1.1
Seblod Version : 3.1.5

Thanks

Get a VIP membership