ironpython - Spotfire Apply Multi-select values from a property control to a filter using a script -


i'm trying figure out how allow user select multiple values property control, , have values passed filter.

the filtering needs conditional 2 different related tables, have use list box tied property control, , handle filtering script.

i have current working version allows 1 selection, need able select multiple.

two tables filtered option selected enter image description here

two tables filtered 1 program selected enter image description here

the script i'm using filter 1 selection @ time is:

 spotfire.dxp.application import filters  spotfire.dxp.application.filters import checkboxfilter   filter1=document.filteringschemes[0].item[mydatatable].item[mydatatable.columns.item["program_name"]].as[checkboxfilter]()  filter2=document.filteringschemes[0].item[mydatatable2].item[mydatatable2.columns.item["program_name"]].as[checkboxfilter]()   program=document.properties["selectedprogram"]   filter1.includeempty = false  value in filter1.values:    filter1.uncheck(value)   filter2.includeempty = false value in filter2.values:    filter2.uncheck(value)   if program == "all":   filter1.check(program)  filter2.includeempty =  false  value in filter2.values:        filter2.check(value) if program  <> "all":  filter1.check(program)  filter2.check(program)

the problem there multiple values in program. add loop parse through each of selected values

for programvalue in program:    if programvalue == "all":         filter1.check(programvalue)        filter2.includeempty = false        value in filter2.values:                filter2.check(value)     if programvalue <> "all":        filter1.check(programvalue)        filter2.check(programvalue)

-

Comments

Post a Comment

Popular posts from this blog

php - Auto increment employee ID -

Image
i want add employee , after that, employee id increment. textbox must disabled also here's code. want auto increment employee id when add new employee. hope me. thank in advance. :) <center> <form class="contact_form" action="#" method="post"> <h2>register new employee</h2> <br/> <table> <tr> <td><label for="emp">emp id:</label></td> <td><input type="text" name="emp" placeholder="emp id" required /></td> </tr> <tr> <td><label for="name">name:</label></td> <td><input type="text" name="fname" placeholder="first name" required /> <input type="text" name="lname" placehol...
Read more

php - isset function not working properly -

the page unable see login form code written under isset function statement. have written code correctly , have executed many times , code written inside isset statement not works. here code:- <?php session_start(); echo "<p style=\"font-color: #ff0000;\"> catogoies </p>"; echo '<link href="var/www/html/sample.css" rel="stylesheet">'; require_once('../html/conn.php'); $query = "select * catogories"; mysqli_select_db($dbc, 'odit'); $retrieve = mysqli_query($dbc, $query); if(!$retrieve) { die(mysqli_error($query)); } while($row=mysqli_fetch_array($retrieve, mysql_assoc)){ echo "<p style=\"font-color: #ff0000;\">".'<a href="cats.php? catogory='.urldecode($row["name"]).'">'.$row["name"].'</a>'."</p>"; $_session['cat']=$row["name"]; } if(!($_session)) ...
Read more

firebird - Error "invalid transaction handle (expecting explicit transaction start)" executing script from Delphi -

i'm developing update app delphi 10. i'm running windows 7 64x, firebird 2.5.1.26351 32x. execution order: checks current version(select statement firebird database) downloads update(via ftp) apply it(.exe files, , execute .sql) error code -901 pops out when try execute .sql files. know there incompatibility issue w7 64x , fdb 32x, but, can everything: backup , restore(gbak), db commands(all). tried fdb 64x instead, , not working. code: //components fdwaitcursor: tfdguixwaitcursor; fddriverlink: tfdphysfbdriverlink; fdconnection:tfdconnection; fdscript: tfdscript; function tthr_script.createcomponents:boolean; begin try fddriverlink := tfdphysfbdriverlink.create(fddriverlink); fdwaitcursor := tfdguixwaitcursor.create(fdwaitcursor); fdconnection := tfdconnection.create(fdconnection); fdconnection begin drivername := 'fb'; params.username := thrbanco.bduser; params.password := thrbanco.bdpass; params.database := ...
Read more