View Single Record

  • sp4448

    (@sp4448)


    10 months, 2 weeks ago

    How do I view a single record?

    I’ve put this:
    ID = httpGet[‘ID’] and httpGet[‘ID’] is not null

    under ‘default where’ but it doesn’t work.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    10 months, 2 weeks ago

    Hi @sp4448,

    Thanks for the post!

    URL parameter names must be written and defined in lowercase characters.

    So in your case, it should be: ID = httpGet['id'] and httpGet['id'] is not null in your Default Where clause, and then your URL to view a single record would look something like: YOURDOMAIN.com/your-table-page/?id=1

    Let us know how if that works for you. 😊

    Thread Starter sp4448

    (@sp4448)

    10 months, 2 weeks ago

    Thank you for your help. Unfortunately that does not work regardless of case. I’ve tried it both upper and lower.

    I get ‘No records to display’.

    Also, when I altered the URL to point to the single record using only lowercase, it didn’t work. The URL only works when the case matches the column headings of the table.

    Plugin Contributor Kim L

    (@kimmyx)

    10 months, 2 weeks ago

    Hi @sp4448,

    Could you send us a recording of the issue? There might be other stuff we missed.

    Parameter names doesn’t have to match the column name of your table.

    Here’s an example: https://share.zight.com/4guvRBb0

    We’ll wait for your response. 🙏

    Thread Starter sp4448

    (@sp4448)

    10 months, 2 weeks ago

    Is it possible to send it privately?

    Plugin Contributor Kim L

    (@kimmyx)

    10 months, 2 weeks ago

    Hi @sp4448,

    Yes, you may send us a message via Contact | WP Data Access if you want to send more information privately. 🙏

    We’ll wait for your email!

    Thread Starter sp4448

    (@sp4448)

    10 months, 2 weeks ago

    Thank you so much for your help. It seems the problem was with the URL linking to the second page.

    https://domain/page/?id={:ID}

    It needed both upper and lower case, not the same for both ID.

    Now that I have that sorted, is it possible to remove the table header/footer on the single record page?

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

The topic ‘View Single Record’ is closed to new replies.