Dynamic link to separate page with table row content

Hi @sirluki,

Have you considered to add all columns to your publication and make it responsive? If I understand your question correctly that might be the simplest way to get what you are looking for.

Alternatively, you could create a master detail publication. This is documented here:
https://wpdataaccess.com/docs/documentation/data-publisher/master-detail-publication/

Do you have a public URL I can visit to see what’s happening?

Thanks,
Peter

Dear Peter,

Thank you very much for your reply! I’m sorry but I had no chance to post a message over the weekend. This evening I will try with master detail publication. I tried with responsive publication but (as far I understand) creates only a pop-up window with the details – this is great however I need to have a separate page for each table entry after clicking dynamic hyperlink ??

The page I’m working on you can find here:

https://wspominamybliskich-nowa.pl/znajdz-zmarlego/?_wpnonce=7f5fd94e8e

It explains the problem. There is a first column with “Zobacz” header and wondering how to do it, that it will take me to the new page where all the details will be shown depends on which link I click. Hope that clarifies the issue better.

Let me try to work with you suggestion this evening. Nevertheless if you find some other suggestion based on above explanation, I’ll be more than happy if you could share that with me. Thank you very much Peter once again for support and great plugin you made! It really makes life easier!

Hi @sirluki,

Looks like you are on the right track. Just forget about taking all the details with you to the detail page. Jump to the detail page with your id and use the id for the detail publication. That’s all. Let the publication do the work.

Hope this helps,
Peter

Hi Peter,

Thank you very much for reply! As promised, I have tested and are really close to the solution… It seems I’m missing one element only. What I did is:

1. I created a page for profile data display;
2. I created separate publication for that page;
3. I linked that page with dynamic hyperlink, displaying ?id=$$ID$$ in the URL;

But I were unable to filter the publication for ID from URL… Can you give me an advice how to achieve it? I tried with WHERE clause (I assume this is the way to do it) but cannot extract ID from URL to filter the table to show results only for that particular ID.

Webpage link:
https://wspominamybliskich-nowa.pl/znajdz-zmarlego/?_wpnonce=99fa043d73

Again, I’ll be more than happy to receive your support in this matter. Thank you very much Peter!

Hi @sirluki,

Your dynamic hyperlink contains:
?id=$$ID$$

This needs to be:
?wpda_search_column_id=$$ID$$

Please see the documentation further information:
https://wpdataaccess.com/docs/documentation/data-publisher/adding-filters/#url-parameters

Unfortunately this filter has no effect on your server. I have no idea why.

Would it be possible to give me temporary access for further investigation? You can use the contactform on the plugin website to send me a message in private.

Thanks,
Peter

Dear @peterschulznl,

I just sent you a private messsage through plugin website. Thank you once again for your help!

Thank you for giving me access!

This is a bug. The filter does not work when the column name uses uppercase characters. I fixed this issue by comparing in lowercase and querying case sensitive. The fix is available in the next release.

@sirluki Your version already contains the fix.

Best regards,
Peter