how to sort store records by keywords by orders ??

hi Bob & MAX,

thanks for your support. i have a question,

is this possible we sort store records by any "keywords" or arrage records by any order..

in short any search facility for store records.. ????
coz so many records its really problem to sort out 1 records easily ??

please let me know

thanks in advance
san

Hi san,

The records are just stored in a MySQL database table so you can do *anything* with them in terms of sorting or retrieving. The problem is that you will need to find or create code to do that if you want to show the results in Joomla. That's not difficult but it is a bit more than we can easily help with in the forum here.

As a temporary solution you can use a tool like PHPMyAdmin or the MySQL Query Browser that will let you access your database and run queries on it separately from Joomla.

Bob

hi Bob,
thanks for suggestion..
but the problem.. we want a search on the admin part to sort out records without knowing any mysql etc..

is this problem we can add any search box on top and admin can search records just enter any keywords... or name or date.. of records ??

myphpadmin not easy to operate by a person who doesnot know about programming ??

thanks
san

Hi san,

I guess that a better data viewer / searcher might get into a future version of ChronoForms. I don't know if that is in Max's plans or not.

The simple answer is probably to export the data into Excel where most users will be OK with sorting or filtering. A more expensive solution would be to use a MySQL front end like Navicat that has a neat table interface (along with may other tools that you probably don't want).

I'll think some more about this, but make no promises.

Bob<br><br>Post edited by: GreyHead, at: 2007/08/09 10:13

thanks a lot

Hi San,

V2.3 is still under development and I will try to include this.

Cheers

Max

hi
thanks for your support

i have developed the solution, now i have sort records by keywords or order by ASC or DESC too.. in the same chrono view record panel. and have delete button for each records..
now admin can delete records and sort records by keywords..

IF ANY BODY NEED HELP TO DEVELOP THIS SORT OF FUNCTION, SO CONTACT ME BY MY WEBSITE OR BY THIS POST..

FOR MORE DETAIL SEE ATTACHED FILE

THANKS
SAN