This topic is locked

Guide 61 - Advanced search - Inclusion of detail records

5/14/2023 2:33:16 PM
PHPRunner Tips and Tricks
fhumanes author

I think that we are all aware that PHPRunner manages searches very well and I personally believe that it is one of its strengths, since it generates a lot of good code to resolve searches.
However, there are some cases that occur in some types of applications that are not enough and it is not easy to expand the searches that the product generates.
Objetive
Expand the search so that it is also resolved;

  • Searches by description of multiple lookup fields.* The search for information of records details.
    DEMO: (advanced version) https://fhumanes.com/advanced_search/
    DEMO: (normal version) https://fhumanes.com/video/videoConsulta/
    img alt
    As shown in the figure, in green, the relationships that PHPRunner resolves and that we do not have to do anything for the general search to work well for us.
    In red we have the 2 cases that I indicate and that remain to be completed. In this case:
  • The multiple interpreters of the films are stored all their keys, with the "," separator, in a single field, therefore it cannot be searched by the name or part of the name of the interpreters,* In the data model, a movie can have multiple themes and has been normalized with an intermediate table. By default, you can't search for movies by any subject.
    If you are interested in this topic, keep reading the article at this link .
    Regards,
    fernando