Use part of website page URL in a query

https://www.ads-software.com/support/topic/qdoc-query-under-other-notes-bottom-of-screen-example-request/

https://www.ads-software.com/support/topic/sql-query-with-wp-user-email/#post-9563674

Thank you very much, Meitar! I will try to work with this info

Hi, Happy New Year!
I tried to make as you advised in your links above. And it’s not working for me. I think I miss something, but after hours and hours, I couldn’t find what exactly. It just doesn’t load a data. I have an empty table.

I would be very happy if you could have a look and recommend me something.

I made a plugin with a following code:
————————–
<?php

/*
Plugin Name: Find Current Page URL
Version: 0.1
*/
function filter_gdoc_query ($query, $atts) {
if (‘https://docs.google.com/spreadsheets/mysheet_address&#8217; !== $atts[‘key’]) { return $query; }
$page_code = wp_get_current_apge_code();
return str_replace(‘__PROGRAM_CODE__’, $page_code, $query);
/*echo ‘result url: ‘ . $page_code;*/
};

function wp_get_current_apge_code(){
$url = str_replace(‘/’, ”, $_SERVER[‘REQUEST_URI’]);
/*echo ‘result url: ‘ . $url;*/
};
add_filter(‘gdoc_query’, ‘filter_gdoc_query’, 10, 2);
—————————
where __PROGRAM_CODE__ is a URL path of the page

The plugin shortcode is following:
[gdoc key=”https://docs.google.com/spreadsheets/mysheet_address&#8221; class=”GoogleInfo1 no-datatables” use_cache=”no” query=”select J where C = ‘__PROGRAM_CODE__’ “]

Thank you very much!

This is a request for custom code. I do not provide such support on this forum. You need to learn more about PHP or hire someone to do it for you. Good luck.

Ok, thank you. Is any way I can get support (maybe not on this forum)?