Search in 265

What exactly is the question?

What exactly is the question?

I wanted to search in an other table then the from table (voorraad), the dropdown boxes works good except the simple search

If you want to search more than one table at once use JOIN SQL query.
http://www.xlinesoft.com/phprunner/docs/us...sql_queries.htm

If you want to search more than one table at once use JOIN SQL query.

I use this querie:

SELECT

`voorraad`.`voorraad_id`,

`voorraad`.`pallet_id`,

`voorraad`.`voorraad_lotnummer`,

`voorraad`.`voorraad_saldo`,

`voorraad`.`voorraad_gewicht`,

`voorraad`.`voorraad_ordnr`,

`voorraad`.`voorraad_ontvangstdatum`,

`voorraad`.`voorraad_status`,

`voorraad`.`voorraad_inventaris`,

`lokaties`.`lokatie_naam`,

`artikel`.`artikel_nr`,

`artikel`.`artikel_omschrijving`,

`artikel`.`eenheid_id`,

`artikel`.`eenheidtype_id`,

`lokaties`.`magazijn_id`,

`artikel`.`artikel_inhoud`,

`voorraad`.`idartikel`,

`voorraad`.`lokatie_id`,

Sum(`inkooporderregels`.`inkooporderregels_besteld`) AS `aantinb`,

Sum(`inkooporderregels`.`inkooporderregel_gewicht`) AS `gewichtinb`

FROM

`voorraad`

Right Outer Join `artikel` ON `voorraad`.`idartikel` = `artikel`.`idartikel`

Inner Join `lokaties` ON `voorraad`.`lokatie_id` = `lokaties`.`lokatie_id`

Left Outer Join `inkooporderregels` ON `inkooporderregels`.`idartikel` = `artikel`.`artikel_nr`

WHERE

`lokaties`.`magazijn_id` = '100'
In version 3 it works perfect, now with ajax it works not

John,
search works for joined fields without Ajax suggest.

We'll add Ajax suggest for joined fields in one of the next PHPRunner version.

John,

Hello Jane
if i understand it well I can not search on it with Ajax, the other fields search well with Ajax. if a search on a joined field it give no result. can i combine ajax and normal searching

John,
you can search on joined fields without Ajax. The limitation is Ajax search popup doesn't appear for these fields.

Search feature and Ajax suggest work independently.

John,

Jane,
if I

Search for: Any field Contains it works fine with joined fields, but when searched specific on a joined field I get No records found

John,
please publish your project on Demo Account and post a URL to your pages here along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.

John,

Jane,
the link is http://demo.asprunner.net/john_van_der_gaa...rraad/login.php
the view where it's go wrong is voorraad and specific on lokatie

There is a limitation of tables quantity on the Demo Account server.

Please send database creation script to [email=support@xlinesoft.com]support@xlinesoft.com[/email].