question

HichamELMORSLI-1445 avatar image
0 Votes"
HichamELMORSLI-1445 asked MiguelEscobar-3907 edited

Format SQL Query Result into web menu



I am trying to build a drill-down menu for my website, where the user will click on a category and it will show the subcategories of that clicked category, there could be n-levels. I am able to write an SQL query which returns the output exactly as I want, but the problem is...I don't want to show the whole menu to the end-user, I would like to open/expand only clicked category.
my Query output is:

1 IPTV
2 Jadoo Tv
3 Shava Tv
4 Java Tv
5 Programming
6 Microsoft
7 Asp.Net
8 PHP
so by default IPTV & Programming Should be displayed, since they are parent, and when I click on IPTV it should open the children of IPTV, like I said there could be n-levels.

I was thinking, I can load the output of query to webpage and then control the menu navigation with css/javascript.

do you guys have any ideas?


dotnet-csharp
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MiguelEscobar-3907 avatar image
0 Votes"
MiguelEscobar-3907 answered

hey @HichamELMORSLI-1445

I've modified the tag used in your thread as the original tag was "power-query-online" and the question doesn't appear to be related to the Power Query product. You can learn more about Microsoft Power Query from the link below:
https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query

Feel free to modify the tag again to a topic that suits your question best. I'm not entirely sure what programming language you might be using, so I added dotnet csharp.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.