2. PHPRunner General questions
  3. Advanced Search returns to Master List not the calling Additional Page List
This topic is locked

Advanced Search returns to Master List not the calling Additional Page List

 		9/10/2020 17:18:56
PHPRunner General questions
B
 brt133 authorDevClub member

I'm pretty new to PHPrunner, still trying to orient myself.
I have a DB with a million+ Members and under each member are their friends and family members ('MyRelationships').


Image A


Image B
I click "Add New Friend" (image A, myrelationships_list URL). Landing on the myrelationships_add page (image B ), the first field (idMember) is a lookup on 'Members' table with 'List page with search' option going to page 'FindMember'. So, I click 'Select' and go to the FindMember list (image C ).


Image C
The pop-up 'FindMember' page (image C - still on myrelationshipd_add.php) is an Additional List Page for the 'Members' table in Designer. It works well if I just click on a First Name - it selects the record and returns me to continue filling out the 'Add a New Friend' page.
But, I want to use the Advanced Search (image D ) to find people because mySQL should make use of a Members table Index I have set up (FirstName(8), Last(8), Gender, BirthYear).


Image D
Here's the problem: Because this Advanced Search is on the Members table, when I fill it out and click Search, I go back to the members_list.php (image E ) instead of going back to the myrelationships_add page (image C ) where I originally started the Advanced Search from.


Image E
I want to return from image D to a list of filtered records on image C and be able to click on a first name to Select the record.
I've worked on this for 3 days trying different things. How can I do that?
Thank you! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=27754&image=6&table=forumtopics' class='bbc_emoticon' alt=':)' />

(PHPrunner 10.4 build 35672x64)
S
 		skbrasil 9/10/2020

A while ago in one of my test projects in an online manual library, I had a problem running in the test environment.
In my case, converting everything to a primary key, however, I managed to reduce the database search.
I advise you to create a specific sql query for search.
in the database example I did the following:
In short, I dismembered the entire database to get to work. more performance during consultations.
There is an ideal in the sql query editor to limit the size of queries.
I prefer a single search field especially when working with a lot of data, and if in your case the more than 1 million records are in a single table, you will surely have a headache in the future or spend a fortune on database optimization. Dice.
B
 		brt133 authorDevClub member 9/10/2020

Thank you Antonio.
I agree the database could benefit from optimization, and I could even purge a bunch of old records, to help with overall performance.
But, any idea how to make the Advanced Search screen return to the original list screen that it was called from?
Thank you again for your thoughts Antonio!
S
 		skbrasil 9/10/2020

Event editor
Ok now I understand in your case you want to redirect after the search for this, you have two options:
Event editor

https://xlinesoft.com/phprunner/docs/events.htm
B
 		brt133 authorDevClub member 9/10/2020

Antonio,
It's not really a redirect that I am looking for. I really just want the Advanced Search to work the way it normally works in PHPR: While on a list, Click Advanced Search button, enter search parameter(s ), click the Search button, and return to the original calling procedure which now has a filtered set of records on it.
Except THIS time I want to perform this Advanced Search from a List that is a Lookup wizard List (see image C from OP ), and upon clicking Search button on the Advanced Search screen I want to go back to this list (image C ) - not the Master Member list :


I guess the simplest way to ask this is: Can a Lookup wizard 'List page with search' page have a working 'Advanced Search' button on it?
Thank you again Antonio!
S
 		skbrasil 9/11/2020



Antonio,
It's not really a redirect that I am looking for. I really just want the Advanced Search to work the way it normally works in PHPR: While on a list, Click Advanced Search button, enter search parameter(s ), click the Search button, and return to the original calling procedure which now has a filtered set of records on it.
Except THIS time I want to perform this Advanced Search from a List that is a Lookup wizard List (see image C from OP ), and upon clicking Search button on the Advanced Search screen I want to go back to this list (image C ) - not the Master Member list :

I guess the simplest way to ask this is: Can a Lookup wizard 'List page with search' page have a working 'Advanced Search' button on it?
Thank you again Antonio!


You have already verified that the page in your list is the same generated in a normal search.
Or check the search filter settings on the related page.
if you have a video
I can try to help you via TeamView
I'm working on a marketplace project, we can exchange experience and learn together.
I don't speak english,

but we can chat via text