Help! Bug in my app!

[TheNoLifer]

Hi all,

I've started adding content to my app, and have discovered a bug that I can't fix or work out how/why it's happening! Would appreciate another pair of eyes on this one.

My app URL is http://ada.abernyte.org - if you go into the "Persons" table and do a "Quick Search" for "Boyd" your results will be filtered down to two rows, which is to be expected.

boyd_search.PNG (14.66 KiB) Viewed 6407 times

Now, go back to all results in the Persons table. Do a quick search for "Nicoll". There are two distinct Nicoll surnames added to that table so far, plus one McNicol surname. I would have expected the app to return two rows, or three if you search for "Nicol" (one L).

Instead, it shows ALL rows, and the Nicoll surnames are highlighted, but still remain mixed within the other records.

What on earth?! This isn't correct behaviour is it? And how can I get it to filter down to my Quick Search results?

Many thanks!

TNL

[TheNoLifer]

I've worked it out - not a bug, but still not particularly desirable.

I am using hidden columns in my db - created_by, last_updated_by. The user who entered these records has a surname of Nicoll, which is why they are being brought back in a quick search.

Can I exclude the created_by and last_updated_by columns from quick search?

[TheNoLifer]

Fixed.

Commented out the relevant "fields that can be quick searched" lines in <YOURTABLE>_view.php

Well, this thread was awesome.

[SkayyHH]

Yes, but things like this should be an option in the appgini ide. Appgini wil overwrite your files when generating.

Best regards, Kai

[TheNoLifer]

I've got so many custom bits and pieces in my files now that I can't really re-generate. If I make changes in the Appgini interface then generate, I need to spend significant amounts of time re-applying all my custom code. Don't know if there's a way around that, really.

[shasta59]

If you have lots of custom bits of code go to this page:

http://www.bigprof.com/appgini/help/useful-links

And read the section on code management at the bottom.

Worth the time to figure out how a CVS system works. (I personally did not find them intuitive but eventually got one working ok)

Alan

[peebee]

Not certain (as I haven't actually tried) but I think simply checking the "Do not filter" check box for the fields concerned in your Appgini setup will achieve the desired result?

Do not filter

screenshot100.jpg (100.09 KiB) Viewed 6355 times