Title: WidiGMX's Replies | WordPress.org

---

# WidiGMX

  [  ](https://wordpress.org/support/users/widigmx/)

 *   [Profile](https://wordpress.org/support/users/widigmx/)
 *   [Topics Started](https://wordpress.org/support/users/widigmx/topics/)
 *   [Replies Created](https://wordpress.org/support/users/widigmx/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/widigmx/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/widigmx/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/widigmx/engagements/)
 *   [Favorites](https://wordpress.org/support/users/widigmx/favorites/)

 Search replies:

## Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Pods - Custom Content Types and Fields] Find using a hierarchical taxonomy](https://wordpress.org/support/topic/find-using-a-hierarchical-taxonomy/)
 *  Thread Starter [WidiGMX](https://wordpress.org/support/users/widigmx/)
 * (@widigmx)
 * [2 years ago](https://wordpress.org/support/topic/find-using-a-hierarchical-taxonomy/#post-17764083)
 * It seems that this problem is not relevant. I thought there should be ready-made
   solutions. Now I have experimented myself and found the following solution.
 * There is an undocumented (or poorly documented) feature in the PODS shortcode:
   The “join” attribute can be used to introduce a SQL fragment that is inserted
   at the appropriate place in the SQL query. This replaces the previously nested
   SQL query.
 * Joins via table `wp_term_taxonomy` to the table `wp_terms` take you to the parent
   category.
 * So, I have added a corresponding join clause:
 *     ```wp-block-code
       join="LEFT JOIN wp_term_taxonomy AS a ON cuisine.term_id=a.term_id
             LEFT JOIN wp_terms AS q ON a.parent=q.term_id"
       ```
   
 * changed my where clause:
 *     ```wp-block-code
       where="cuisine.term_id and q.slug='european'"
       ```
   
 * where the fragment `cuisine.term_id` ensures that the field `cuisine` is available
   in the SQL query.
 * Regards Friedbert
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Pods - Custom Content Types and Fields] Shortcode WHERE for custom taxonomy parent name/slug?](https://wordpress.org/support/topic/shortcode-where-for-custom-taxonomy-parent-name-slug/)
 *  [WidiGMX](https://wordpress.org/support/users/widigmx/)
 * (@widigmx)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-where-for-custom-taxonomy-parent-name-slug/#post-14013594)
 * Hi [@apollolux](https://wordpress.org/support/users/apollolux/),
 * I don’t know, whether you have found a solution so long. Since I was faced with
   the same problem, I experimented a bit.
    My solution: the where clause cannot
   check whether the parent of the current taxanomy term points to the category 
   you are looking for. Instead, they should check whether the current term is a
   member of the set of all child terms of the category.
 * `where="placement.term_id in (SELECT b.term_id FROM wp_terms a JOIN wp_term_taxonomy
   b ON a.term_id=b.parent WHERE a.slug='featured')"`
 * Regards,
    Friedbert
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Pods - Custom Content Types and Fields] Howto add tagcloud widgets to relationship fields](https://wordpress.org/support/topic/howto-add-tagcloud-widgets-to-relationship-fields/)
 *  Thread Starter [WidiGMX](https://wordpress.org/support/users/widigmx/)
 * (@widigmx)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/howto-add-tagcloud-widgets-to-relationship-fields/#post-13991400)
 * Hi [@keraweb](https://wordpress.org/support/users/keraweb/),
 * Yes, I know that´s the standard way, and yes that´s simple and working
    But then
   the terms of the taxonomy are listed in the order given by the taxonomy. I, on
   the other hand, don’t want to think of the terms as an unordered set. Rather,
   I want to prioritize or order the list of taxonomy terms individually for each
   entry of the custom post type.
    -  This reply was modified 5 years, 3 months ago by [WidiGMX](https://wordpress.org/support/users/widigmx/).
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Pods - Custom Content Types and Fields] Howto add tagcloud widgets to relationship fields](https://wordpress.org/support/topic/howto-add-tagcloud-widgets-to-relationship-fields/)
 *  Thread Starter [WidiGMX](https://wordpress.org/support/users/widigmx/)
 * (@widigmx)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/howto-add-tagcloud-widgets-to-relationship-fields/#post-13990283)
 * Thanks for the hint. Yes, that already works partionally. The tagcloud widget
   in the admin interface disappears. But, unfortunately, the menu entry at the 
   previously associated post type also disappears.
 * Example: We have a Custom Post Type “person” (label.singular=”Person”, label.
   plural=”Personen”).
    Then we defined a taxonomy “ausbildung” (label.singular=”
   Ausbildung”, label.plural=”Ausbildungen”). To each person we want to assign several
   educations (qualifications). We want to sort the order of the educations for 
   each person according to their priorities. Therefore, we do not use the taxonomy
   as an associated taxonomy, but as a relationship data field with multiple selection,
   where we can change the order.
 * Until now, the admin menu shows the menu item “Personen” with the submenu item“
   Ausbildungen” to edit this taxonomy. That disappeared now too.
 * Now I have tried to use the options “Admin UI” of the taxonomy “ausbildung” to
   place this menu entry again under the menu item “Personen”. But unfortunately
   unsuccessfully.
    If I set **Menu Name**=”Ausbildungen” and **Menu Location**=”
   Add a submenu item to Settings menu”, then it appears as expected in the Settings
   menu. Any attempts with **Menu Location**=”Add a submenu item to another menu”
   to place this item back to the menu item “Personen” menu failed. What do I have
   to enter in **Custom Menu Location**? The attempts with “Personen”, “Person”,“
   person” or “posts-person” were not successful so far.
 * Regards, Friedbert
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Pods - Custom Content Types and Fields] Howto add tagcloud widgets to relationship fields](https://wordpress.org/support/topic/howto-add-tagcloud-widgets-to-relationship-fields/)
 *  Thread Starter [WidiGMX](https://wordpress.org/support/users/widigmx/)
 * (@widigmx)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/howto-add-tagcloud-widgets-to-relationship-fields/#post-13922489)
 * Ohh – I forget to mention that I talk about the input form in the backend (Admin
   UI) – sorry.
    We use custom post types (Pods) to store the master data of our
   workers or products. The problem described above occurs when we edit one of these
   items in the backend (admin UI).
 * An example: We have specified the following data structure.
    - A taxanomy “CustTaxColors” with the items { Black, Blue, Gold, Green, Red,
      White, Yellow }.
    - A custom post type “CustPostFlags” with two custom fields “Flag Colors”, “
      Other Colors”, where both references the taxanomy “CustTaxColors” (multiple
      select).
 * Now we use the admin dashboard to create a new entry of “CustomPostFlags”. The
   section “More Fields” shows the two fields (“Flag Colors”, “Other Colors”) where
   we can choose the items of the taxanomy. But there is also a single widget named“
   CustTaxColors” on the sidebar where we can select the items using checkboxes.
   The selection within this widget is not related to the data of the data fields.
   That’s confusing!
 * Is it possible to hide this widget in the admin UI?
    Or is it possible to use
   two of these tagcloud widgets instead of the simple input fields.
 * Regards,
    Friedbert
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Looking for a plugin to send issues to GitHub](https://wordpress.org/support/topic/looking-a-plugin-to-send-issues-to-github/)
 *  Thread Starter [WidiGMX](https://wordpress.org/support/users/widigmx/)
 * (@widigmx)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/looking-a-plugin-to-send-issues-to-github/#post-13640673)
 * Hello Samuel,
    ok, I will let you know as soon as a solution becomes apparent.
   The approach via Gravity Forms you suggested sounds very exciting. I will keep
   that in mind for corresponding projects. The current project, however, is a website
   for a non-profit hiking club. I can’t use a commercial product from external 
   service providers there.
 * Thanks and regards,
    Friedbert

Viewing 6 replies - 1 through 6 (of 6 total)