Search/filter/sort functions, how?

More
15 years 2 months ago #12010 by sospixs
Hi im stuck with this "Search" problem
for a week and now im just solve my problem ,
May be help any one .

Im just add php code in "models/categories.php"
Line 337
From
Code:
$where .= ' AND LOWER( i.title ) LIKE '.$this->_db->Quote( '%'.$this->_db->getEscaped( $filter, true ).'%', false );

To be
Code:
$where .= ' AND ( LOWER( i.title ) LIKE '.$this->_db->Quote( '%'.$this->_db->getEscaped( $filter, true ).'%', false ); $where .= ' OR LOWER( ie.search_index ) LIKE '.$this->_db->Quote( '%'.$this->_db->getEscaped( $filter, true ).'%', false ); $where .= ' ) ';

Caz old sql doesn't search in others field ,

BUT Still have problem when searching return more than one page , When i change page , Search result will lost . T T , In this case i can't solve.

How can i pass filter value to next page ?

Please Log in or Create an account to join the conversation.

More
15 years 2 months ago #12014 by sospixs
Hi , Im try to find how to pass filter value to pagination . I'm no luck .

In my case
I have setup category to show 10 article per page .
(I have 50 articles then result show 5 pages ) and also show search box on the top of category list.

When I submit any value in search box , such as "install" that hits around 15 articles ,absolutely show in 2 pages ,

But when i press "Next" botton of pagination to go next page, My search box is empty and result are clear , Result return 50 article again , HOW DO I CORRECT THIS ? Please HELP.

Thank you
2010-11-01
SOLVED by myself.

Please Log in or Create an account to join the conversation.

More
14 years 11 months ago #14116 by boulij

poolp wrote: Merci ! :mrgreen:
Ca marche bien ! Mais il y a une petite erreur a changer :

add into new line #33 of 'category_items.php' of your template

Code:
<script type="text/javascript" src="<?php echo JURI::base().'components/com_flexicontent/assets/js/sortable.js'?>"></script>

Encore Merci !




Hi,

I have an error message when the category opens: "Handler cannot be removed". I precise that i'm still on local.

Second question: where can I modify the head of column style. I find a CSS file but when I change something, it impacts all the links.

Thank you

Please Log in or Create an account to join the conversation.

More
14 years 11 months ago #14164 by gauthier
The filter solution works fine but I have:

A pop up error message 2 times: "Handler could not be removed" when I refresh my page.

This error is linked with the javascript but I don't have any idea of what could be the problem.

I found this in error logs of firefox:

Error: window.addEvent is not a function
Source File: http://localhost/revisedextranet/people
Line: 6


as the script still running I don't understand why it still a problem for it.

Please Log in or Create an account to join the conversation.

More
14 years 11 months ago #14169 by gauthier
I found the origin of the error :idea:

In sortable.js,
I put a comment on the line #283
Code:
//alert("Handler could not be removed");

And my problem was solved.

Please Log in or Create an account to join the conversation.

More
14 years 11 months ago #14171 by micker
great thanks

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

More
14 years 9 months ago #15320 by ViveLeFlexicontent
The final piece I needed for my content. Thank you so much!

Please Log in or Create an account to join the conversation.

More
14 years 8 months ago #15783 by ViveLeFlexicontent
Wish I would be able to sort by image, tried to install and implement tablesorter (a different plugin) but couldnt get it working properly.
And already had it all the way I wanted it too with this fix.
So if anybody has any ideas how to include img sorting in this script.. would be very pleasant :D
Gonna make a filter instead till I find a way to do this.

Please Log in or Create an account to join the conversation.

More
14 years 8 months ago #15921 by micker
hello (i am not a dev just an idea)
maybe a javascript to link description ore name of image to selected field
after filter with selected field ...
or more simple
use tag
regards

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

More
14 years 8 months ago #15948 by ViveLeFlexicontent
thanks for responding micker, appreciate your help..
will give the tag a try. I think you mean the custom field tag, haven't tried that one yet.
I think the problem is flexicontent doesn't give the image a title but it does give it a alt tag, except this script doesn't recognize it.

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Save