TRIRIGA

Maximo Real Estate and Facilities (The Evolution of TRIRIGA)

Come for answers, stay for best practices. All we're missing is you.

 View Only

Question about Query Section

  • 1.  Question about Query Section

    Posted 10 days ago

    Hi Team,

    My name is Asako. I'm working on TRIRIGA project for the large automotive company in Japan.

    I have a question about create the Query Section.
    I'd really appreciate it if you answer my question.

    I would like to create a query section that displays a list of records associated with the key of the parent data. 

    The desired implementation example is as follows: selecting the Dodgers should display a list of players in the query section.

    Data Modeler:

    Create Baseball Module

    Create Team and Player BO(both include team_no field)

    Create Association(Player BO belong to Team BO)

    Report Manager:

    Create Report(List of Player and List of Team)

    Form Builder:

    Create team form and add query section

    Query Section properties:

     Query: List of Player

     Association Type:Belongs To

     Select Association Type:Selected

    When I open the team form by selecting the Dodgers from the team list, the query section displays all players from all teams.

    What settings are required to display a filtered list of players filtered by team_no?

    The filter settings seem to be incorrect, but I don't know how to set them up correctly.
    If there are any other incorrect settings, please let me know.



    ------------------------------
    ASAKO SHIMAZU
    ------------------------------