monpire - 07 May 2009 12:32 PM

Hi, thanks for such a tool.

I am having some problem implementing even with the example.  No matter what I tried, it just sits there and won’t load the records.

To see this: Flexigrid Test

I have set the libraries to autoload database, nothing seemed to help.  Although in FireBug console there seems to be no query passing. 

Thank you in advance

Monpire - Did you ever get this issue resolved?  I am having similar issues where the datagrid loads but no content is present. 

I tested it in my local development environment with success but on the production server the results are different. 

Do you think it is a permissions issue with the ajax call? 

Thanks - phishee (Brandon)

Ok - I am an idiot; got it working.  I had to go back and use the non-JSON method as my server does not have the JSON extension compiled with PHP.  For future reference, as of PHP 5.2.0 the JSON extension is included by default.

Hope that helps someone - phishee (Brandon)

monpire - 07 May 2009 12:32 PM

Hi, thanks for such a tool.

I am having some problem implementing even with the example.  No matter what I tried, it just sits there and won’t load the records.

To see this: Flexigrid Test

I have set the libraries to autoload database, nothing seemed to help.  Although in FireBug console there seems to be no query passing. 

Thank you in advance

I found what the problem was, it was because I wasn’t using PHP5.  As soon as I upgraded to php5 and fixed some minor naming issues - it worked.  So for future reference

I have been watching flexigrid quite closely now but i have not come across a fully CRUD implementation.The delete method works just fine but i think a simple demo of the remaining CRU will go a long way,i think.

I’d just used it here (development server):
http://hdeya.homeip.net/admin/items/list_all/

and it works great , thanks a lot !

I have a question ..

I have installed flexigrid in my CI project, but it wont work.
When i go to the ajax file directly it works and the logfile gives me the
DEBUG - 2009-07-27 21:00:37—> EVD CMS Flexigrid Class Initialized

When i go to the main page with the <table> it does not show, and i do not get any error messages, the debug message above is also gone.

Its seems like the javascript issent running. Is there a way to debug this?

Thanks for an beautiful datagrid. Have missed one .

Best Regards
Audun

Hi, just want to ask if I can use this Flexigrid with semi-complex SQLs? My query has about 4 left joins, and I don’t know if it can be done with this Flexigrid. Thanks!

Additional question, if I use table aliases with different tables, how will this affext the creation of columns?

Hello.

I need to translate all the texts (that appear to client) to portuguese, but i cant find in what file is the “Quick Search” and the “Page x of y” texts.

EDIT: ANSWER: u can translate using the $gridParams array or directly in the flexigrid.pack.js file.

Really thanks!
DZPOA

Hi,

Thanks for this wonderful grid implementation.
Took me a while to figure it out, as I’m new to PHP and CodeIgniter (being a Perl-dude .

I noticed that this isn’t working (Query error: No tables used):

  $getDocIds_sql = “SELECT uid, folderset, county, doctype FROM panel”;
  $this->db->query($getDocIds_sql);
  $this->CI->flexigrid->build_query();

but this is :

  $this->db->select(‘uid, folderset, county, doctype’)->from(‘panel’);
  $this->CI->flexigrid->build_query();
     
Is this intended ?
Pitty if so, cause I’m trying to implement the following SQL :

1. Create temp table panel using dbforge, which goes fine.
2. Put the results of the following query in the grid :

$getDocIds_sql = “INSERT INTO panel (null, foldername, county, doctype)
              SELECT foldersets.folderset AS folderset,
                  foldersets.county AS county,
                  foldersets.doctype AS doctype
              FROM foldersets
              LEFT JOIN panfoldersets ON foldersets.folderset = panfoldersets.folderset
                AND foldersets.county = panfoldersets.county
                AND foldersets.doctype = panfoldersets.doctype
              WHERE foldersets.docstatus = ‘C’
                AND (foldersets.folderset like ‘%2009’ || foldersets.folderset like ‘%2010’)
                AND (foldersets.doctype = ‘realestate’ OR foldersets.doctype = ‘mortgages’)
                AND panfoldersets.folderset IS NULL
              GROUP BY folderset, county, doctype”;

Looking forward to any input or suggestions.
Thanks.

Hei guys,

Just finish tunning up flexigrid to meet my needs and want to share with you.

I needed that flexigrid “remembers” the column width, search filters and page, so I decided to dig in the code and make it happen.

I used the Jason Valdron implementation witch already had column width to cookie after seeing his implementation it was more easy to make mine.

Here is the final code: http://pastebin.com/f66c1d534

So if you set cookies to true in parameters (is true by default) flexigrid should be save state after leaving the page, and should remain the same when u get back.

Test it and let me know if it works for you.

EDIT: You need to use http://plugins.jquery.com/project/cookie