I want to display a value to the text field; it is from a SQL query. And that SQL's WHERE keyword is from the list item. Searching by ID in the selected row will return a single item.

SELECT SHOP_NAME, ID FROM M_SHOP WHERE ID = '(selected ID)';

CodePudding user response：

Just use page item's name preceded by colon (:) sign. For example, if that ID represents department ID and page number is 1, that could be

SELECT SHOP_NAME, ID FROM M_SHOP WHERE ID = :P1_DEPARTMENT_ID