2. PHPRunner General questions
  3. [SOLVED]  DROPDOWN in datagrid depend on Additional WHERE tabs
This topic is locked
[SOLVED]

 DROPDOWN in datagrid depend on Additional WHERE tabs

 		1/26/2021 9:13:33 AM
PHPRunner General questions
G
 gchowani author

Hi everyone,
Is there possible to decrease dropdown list values (2) based on Additional WHERE tabs value ID (1)?

My dropdown field are specified for all tabs and the list is pretty long, it will be brilliant to find a way to limit the dropdown values depend on selected tab.
Best Regards, <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=28084&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />

G
 		gchowani author 1/26/2021

Hi ALL,
It seems that after few hours I have found the solution,

I am not sure if best one...as dropbox is not working on "ALL Tab"
On Events "Before Display" I have added below code to get the tab ID from URL

$_SESSION["tabvalue"]=@$_REQUEST["tab"];


and after on Lookup Wizard I have used defined session variable on WHERE:

your_field = ':session.tabvalue'

.
I hope it can help others <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=93671&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

If there is better solution PLEASE shout.