HI there,

I have used view to filter my result but I have some problems in using it.

I used CCK to add extra fields for (eg) ABC node. Then I have also installed and enabled the modules below:
Views
Views exporter
Views Filter Pack
Views UI
views_filter_pack CCK

I made the filter expose to everyone. My problem comes when I made the filter in selection mode, but I have no problem with type and search mode.

For instance:
I have 2 filters - 1) title search (people need to type and search) 2) product search (people use the drop down list to select one from the list)

The filter works when users type and search for some words, the results will be out. However, when users use the drop down menu to select one from the list and click "apply", no result will be out at all. I am sure there would be some results, but the result is blank.

May I know what would be the problem, could someone please provide me some advice?

Thanks. Hope to hear from you soon.

CommentFileSizeAuthor
#3 export_view.txt8 KBDLZJ
#3 sql_before_remove_all_other_filters.txt1.41 KBDLZJ
#3 sql_after_remove_all_other_filter_except_selection_filter.txt1.34 KBDLZJ

Comments

DLZJ’s picture

DLZJ commented

HI,

Sorry, I have missed out something.

Even I have deleted the particular view and recreate a new one, it won't work as well.

Thanks.

dawehner’s picture

dawehner
Primary language German
commented
Assigned: DLZJ » Unassigned
Status: Active » Postponed (maintainer needs more info)

First i suggest to export the view, this helps other people to help you.

- What happens if you remove the title search filter?
- Did you tryed to reproduce the behaviour in the view preview? Could you please pastebin the result sql also.

Thanks!

DLZJ’s picture

DLZJ commented
StatusFileSize
new sql_after_remove_all_other_filter_except_selection_filter.txt1.34 KB
new sql_before_remove_all_other_filters.txt1.41 KB
new export_view.txt8 KB

Thanks for the reply.

The selection filter only works when I put "Any". However, if I select anything else other than "Any", the result will be blank.

1) I have attached the VIEW file below.

2) I have tried to remove all filters except the "product search" (selection filter), but it still doesn't work in both "live preview" and "View page".

3) Kindly take a look at the SQL files below for both before and after removing all other filters.

Really thanks for your help ;)

dawehner’s picture

dawehner
Primary language German
commented
Status: Postponed (maintainer needs more info) » Active

It would be cool if you would update the status.

DLZJ’s picture

DLZJ commented

Hi, What do you mean update the status? My problem remains the same now.

dawehner’s picture

dawehner
Primary language German
commented

The status of the issue.

DLZJ’s picture

DLZJ commented

Hi dereine,

The status of the issue is "active" now, do you want me to put "needs work" or "needs review"?

Could you suggest what I shall do to overcome the problem besides updating the status of the issue?

Thank you.

dawehner’s picture

dawehner
Primary language German
commented

No, just from postponed to active if you provided the informations :)

But currently my time is incredible limited.

DLZJ’s picture

DLZJ commented
Assigned: Unassigned » DLZJ

Oh I see,

I try to set it to active status and save it again. (Just in case you still see postpone, could you please set it as active for me? Sorry to disturb you as I may not set it correct or something weird had happened to my account)

No problem, I shall wait patiently then.

Thanks for your time and being patient to me. ;)

DLZJ’s picture

DLZJ commented
Assigned: DLZJ » Unassigned
DLZJ’s picture

DLZJ commented

Hi dereine,

Just one quick question, may I know whether there is any information about this problem from other websites? So that I would try to follow their guidelines to get thing done. ;)

Thanks a lot.

esmerel’s picture

esmerel commented
Status: Active » Closed (fixed)

General closing of issues with no activity for 6 months