PODS shortcode filter by url

  • Resolved nfcgomes

    (@nfcgomes)


    4 years, 9 months ago

    I have a website with many users and each user has activities.
    I’m using PODs to create a POD called “activities”.

    I am generating a list on the frontend using:

    <ul>
[pods name="activities" where="post_author={@user.id}"]
  <li>
  <a href= "{@permalink}" >{@post_title}</a>
  </li>
  [/pods]
</ul>

    So, any user just can see its own activities.
    I would like that when the user click on some activity could open that activity form on edit mode, so filtered by current url, permalink or something like? All this in frontend.

    I know how to list activities in frontend, I know how to show PODS record in frontend one editable form, but I don’t know how to generate a list on frontend and when we click on any object we would open just that form in edit mode.

    Is that doable?
    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter nfcgomes

    (@nfcgomes)

    4 years, 9 months ago

    Solved

    giorega23

    (@giorega23)

    4 years, 6 months ago

    @nfcgomes Hi, i have a similar problem, i need to dispaly for each user their own activities

    but this dosen’t work the where condition, any suggestion?
    [pods name=”mission” where=”post_author={@user.id}” template=”Mission – Missions”]

    Database Error; SQL: SELECT DISTINCTt.*FROMwp_postsASt`
    WHERE ( ( post_author={@user.id} ) AND ( t.post_type = ‘mission’ ) AND ( t.post_status IN ( ‘publish’ ) ) ) ORDER BY t.menu_order, t.post_title, t.post_date
    LIMIT 0, 15; Response: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘@user.id} ) AND ( t.post_type = ‘mission’ ) AND ( t.post_status I…’ at line 7`

    Thread Starter nfcgomes

    (@nfcgomes)

    4 years, 6 months ago

    You can try without the template=”Mission – Missions” first. I thintk that the remaining syntax is good.

    tazar64

    (@tazar64)

    4 years, 1 month ago

    Hi nfcgomes,

    You said just ‘solved’. I’m trying the same thing. How you solved, can you elaborate, please?

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

The topic ‘PODS shortcode filter by url’ is closed to new replies.