flexjoly

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Forum: Plugins
    In reply to: [Pods - Custom Content Types and Fields] How get the Pods for one taxonomy term, but without another term
    Thread Starter flexjoly

    (@flexjoly)

    1 year ago

    With AI I changed the where ewtag.term_id!=32 to:

    NOT EXISTS (SELECT 1
    FROM     wp_term_relationships AS tr 
    JOIN wp_term_taxonomy AS tt 
     ON tt.taxonomy = 'ewtag'
      AND tt.term_taxonomy_id = tr.term_taxonomy_id
      AND tt.term_id = 32
    WHERE rel_tag_excl.object_id = t.ID )

    Even more complex, but it works!! 🙂

    If you want to use the slug, an extra join is needed:

    NOT EXISTS ( SELECT 1
    FROM     wp_term_relationships AS tr 
    JOIN wp_term_taxonomy AS tt 
      ON tt.taxonomy = 'ewtag'
      AND tt.term_taxonomy_id = tr.term_taxonomy_id 
    JOIN wp_terms AS tm 
      ON tm.term_id = tt.term_id
      AND tm.slug = 'myslug'
    WHERE tr.object_id = t.ID )

    It can also be done with an extra join, but I choose this one, for then it only changes the where and everything is in one place in the query.
    Hope this can help someone else too.

    I still hope is a better or easier solution 😉

    Forum: Plugins
    In reply to: [Pods - Custom Content Types and Fields] How to get rid of registered query_var ‘pg_2’
    Thread Starter flexjoly

    (@flexjoly)

    1 year, 2 months ago

    Hi,
    Thanks for getting back at me!!
    It is a new website. I had only a few plugins running: wp_data_access, wpcode and maybe nested pages, besides pods. No extra wp-caching.
    In wpcode just a little css, js and php, but nothing related to pagination.

    I did not consider any other caching or that it could be browser related. And I was a little impatient and since the site was very new I asked my webhoster (stephson) to re-install everything.

    I really thought Pods had stored this somewhere, sorry. And I really do not want to try it again on my site. But I am happy to recreate the problem on a demo site with pods if pods has (or can facilitate) one.

    Thanks so far!

    • This reply was modified 1 year, 2 months ago by flexjoly.
    Forum: Plugins
    In reply to: [Pods - Custom Content Types and Fields] Getting “parent pod” data when inside an EACH loop (pod template)
    flexjoly

    (@flexjoly)

    1 year, 2 months ago

    What is the name of the bidirectional field in the user-object?
    You can use that to link back to the job.

    If the field is: user.linkedjob then
    {@linkedjob.ID}

    If you use pods template, it should also give you a list of possible fields/tags you can use. If you selected the pod that is used in the template.

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