Select record list view with appleid filter

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Russ
    Senior Member
    • Feb 2022
    • 472

    Select record list view with appleid filter

    When I tried purchase orders (in sales pack), I saw a very cool way to add related records, when clicking, it brings a pop-up that already has a filter, wow, so cool!

    Is there any way to add this?

    I saw some similar discussion here, is this a proper way? The only way?
    Hi, I have an entity Project. It has multiple links to an entity Project Document, one for Budget, for Proposal, for Report, etc. For each Project Document, the Project that it belongs to is set. Now in the Project, I want to be able to select e.g. the budget. I click the select Project document. It opens the (small) list



    THanks a lot!
    Attached Files
  • Russ
    Senior Member
    • Feb 2022
    • 472

    #2
    We have few relations Opportunity->Account (account as a borrower, account as an escrow, etc), would be so cooooool to add a filter, so when clicked 'Escrow' to open up a list view with accounts type 'escrow'! Mind blowing

    Comment

    • yuri
      Member
      • Mar 2014
      • 8845

      #3
      There are two build-in handlers for account and accounts: https://github.com/espocrm/espocrm/t...select-related

      In metadata > clientDefs > YourEntityType.json

      Code:
      {
          "relationshipPanels": {
               "yourLink": {
                     "selectHandler": "handlers/select-related/same-account-many"
                }
           }
      }
      Example: https://github.com/espocrm/espocrm/b.../Case.json#L87
      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

      Comment

      • Russ
        Senior Member
        • Feb 2022
        • 472

        #4
        Originally posted by yuri
        There are two build-in handlers for account and accounts: https://github.com/espocrm/espocrm/t...select-related

        In metadata > clientDefs > YourEntityType.json

        Code:
        {
        "relationshipPanels": {
        "yourLink": {
        "selectHandler": "handlers/select-related/same-account-many"
        }
        }
        }
        Example: https://github.com/espocrm/espocrm/b.../Case.json#L87
        THanks, indeed, I understood, so I can select contacts from the same account, cool!!


        But how can I make it show only accounts with certain filter, type - 'Lender'?

        And another similar issue:
        I have 3 contact->opportunity relations:
        a) opportunitiesPrimary - Many-to-One - label Opportunities (as a Borrower)
        b) contact1 - Many-to-One - label Opportunities as Borrower's Agent
        c) contact12 - Many-to-One - label Loans as Escrow/Title

        How can I make 'borrower' dropdown to open contacts with filter type 'Borrower', 'Agent', 'Escrow' or 'Escrow title'?​


        ---
        If I am asking for too much, I will then continue to paid support.

        Thanks
        Attached Files
        Last edited by Russ; 05-10-2024, 08:33 PM.

        Comment

        • yuri
          Member
          • Mar 2014
          • 8845

          #5
          You can create a Report Filter for each type. Then at Administration > Entity Manager > Opportunities > {link} > Edit, you can select that filter. This is a new feature: https://github.com/espocrm/espocrm/issues/3002. The downside, is that you will have primary filters that you may not need other than for selecting related record. In future I think we will have the ability to make Report Filters hidden on the list view.
          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

          Comment

          • Russ
            Senior Member
            • Feb 2022
            • 472

            #6
            Originally posted by yuri
            You can create a Report Filter for each type. Then at Administration > Entity Manager > Opportunities > {link} > Edit, you can select that filter. This is a new feature: https://github.com/espocrm/espocrm/issues/3002. The downside, is that you will have primary filters that you may not need other than for selecting related record. In future I think we will have the ability to make Report Filters hidden on the list view.

            This fixed the vast majority, thanks, yuri

            Comment

            • rouhu
              Member
              • Sep 2020
              • 42

              #7
              Originally posted by yuri
              You can create a Report Filter for each type. Then at Administration > Entity Manager > Opportunities > {link} > Edit, you can select that filter. This is a new feature: https://github.com/espocrm/espocrm/issues/3002. The downside, is that you will have primary filters that you may not need other than for selecting related record. In future I think we will have the ability to make Report Filters hidden on the list view.
              Wonderful new feature. Now what I cannot find is to how to create primary filters other than report filters. Is there documentation or examples for this ? For example, if Account has many Tasks and I want to assign each Task to a Contact of the Account, I want to filter the Contact lookup for only those contacts that are linked with the Account in question.

              Comment

              Working...