2. PHPRunner General questions
  3. Getting rid of specific values at lookup wizard selection
This topic is locked

Getting rid of specific values at lookup wizard selection

 		1/10/2011 01:55:42
PHPRunner General questions
A
 amuro author

Hi~
The scenario is when user chooses a product group in particular, the goods included in this group shows up.

It has done in lookupwizard with dependent dropdown listbox.
Now, the dependent dropdown column must consider situation of some products not on sale.

Another table documents which products are not avaible now.
How could it work out? Thank you <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=16067&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
D
 		danaci 1/10/2011

hi,

for fields

Edit as setting-lookup wizard-where expression
A
 		amuro author 1/11/2011

Hi~

Let me explain precisely.
There are 4 kinds of price list.

List A has a1, a2, ... items.

List B has a1, b2, ... items.

List C has a1, b2, c1, ... items.

List D has a1, d1, d2, ... items.
Suppose a1 is unavailbe.
While user chooses List A, product column has only a2 could be chose.

While user chooses List C, product column has b2, c1 could be chose.
How to figure it out? Thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=55518&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Sergey Kornilov admin 1/11/2011

Add WHERE clause like

" fieldname<>'a1'"
A
 		amuro author 1/11/2011

Hi~
I cannot fill fixed code in where clause.
The unvailable items change dynamically.

For expample, a1 is unvailable today, but vailable tomorrow.

Maybe b1 is vailable today and tomorrow, but unvailable after tomorrow.
Thank you <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=55546&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Sergey Kornilov admin 1/11/2011

Use session variable in this case. Populate this session variable according to your own rules in one of events.

" fieldname<>'" . $_SESSION["somevar"] . "'"