Is there anyway to use Sql Table widget as Master-Detail? Like context selector, when click in row start action to show information into other Sql Table?
as you can see from the documentation, this requires you to add a SQL datasource to the SQL table. And this cannot be customized the same way that the queries on the context selector can.
(see Create and Assign the Data Source for a Widget - CA Unified Infrastructure Management - 8.4 - CA Technologies Documentat… )
There are some substitution parameters available, but none that would help you here. If this is a requirement for you I would ask you to add this as an idea.
CA Tech Support
Retrieving data ...