We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 21739
    • 49 Posts
    Ive got a custom listbox filled by doing "@SELECT `pagetitle` AS `name`,`id` FROM etc...".

    Unfortunately this also means that the dropdown filter is showing "IDs", as it is intended. I would however like it to display the actual names (pagetitle). Is this possible?

    (See attachement)

      • 4172
      • 5,888 Posts
      you can do a join to the resource-table in the joins-configuration on the tab MIGXdb-settings

      for example, if your field is named 'resource_id':

      if you have no relation defined in you schema:

      {"alias":"Resource","classname":"modResource","on":"Resource.id=yourClassname.resource_id"}



      than you should have access to that field in your grid with: Resource_pagetitle

        -------------------------------

        you can buy me a beer, if you like MIGX

        http://webcmsolutions.de/migx.html

        Thanks!
        • 4172
        • 5,888 Posts
        sorry, I see you are talking about the dropdown-filter.
        you will need your own custom getcombo - processor.
          -------------------------------

          you can buy me a beer, if you like MIGX

          http://webcmsolutions.de/migx.html

          Thanks!