...

View Full Version : Dynamic query builder help required



xaverian
06-25-2012, 10:52 AM
Hi,
I need a filter (or a dynamic query builder) for the following html:


1)Each field e.g. project name or path should be able to have include and exclude filters optionally.
2) Include filters are to be used in additive mode i.e show the projects having either 'micado' or 'fwflow' in path.
3) Exclude filters are to be used in subtractive mode i.e show the projects having neither 'micado' nor 'fwflow' in path.

Please help. I hope I could clearly state my requirement and the post is readable for you. Please let me know if you need any further explanation.

Thanks in advance !!!

#################################

<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US" xml:lang="en-US">
<head>
<title> Collections</title>

</head>
<body bgcolor="#FFFFFF">

<h3>All Projects</h3><TABLE BORDER=0 BGCOLOR="#F5F5F5"><TR><TD>o</TD><TD><a href="collstat.pl?path=/home/fwflow/temp_clk_camino_tool_clk/nodm/v0.0.0/units/clock_generator/tool/results">@LIBRARY_NAME@</a></TD><TD><a href="collstat.pl?path=/home/fwflow/temp_clk_camino_tool_clk/nodm/v0.0.0/units/clock_generator/tool/results">(/home/fwflow/temp_clk_camino_tool_clk/nodm/v0.0.0/units/clock_generator/tool/results)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/micado/spooler_c65fla/dss/dss.common.default/units/macro/tool/results">AnalogIP:Test1</a></TD><TD><a href="collstat.pl?path=/home/micado/spooler_c65fla/dss/dss.common.default/units/macro/tool/results">(/home/micado/spooler_c65fla/dss/dss.common.default/units/macro/tool/results)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/micado/spooler_c65fla/dss/dss.common.default/units/top/tool_analogip/results">AnalogIP:Test2</a></TD><TD><a href="collstat.pl?path=/home/micado/spooler_c65fla/dss/dss.common.default/units/top/tool_analogip/results">(/home/micado/spooler_c65fla/dss/dss.common.default/units/top/tool_analogip/results)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/micado/spooler_c65lp_OA/dss/dss.common.default/units/top/tool3.2/results">spooler Regression 3.2</a></TD><TD><a href="collstat.pl?path=/home/micado/spooler_c65lp_OA/dss/dss.common.default/units/top/tool3.2/results">(/home/micado/spooler_c65lp_OA/dss/dss.common.default/units/top/tool3.2/results)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/micado/spooler_c65lp_OA/dss/dss.common.default/units/top/tool/results">spooler Regression 3.3</a></TD><TD><a href="collstat.pl?path=/home/micado/spooler_c65lp_OA/dss/dss.common.default/units/top/tool/results">(/home/micado/spooler_c65lp_OA/dss/dss.common.default/units/top/tool/results)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/plls4ws/pll_xg223/dss/dss.common.default/units/main/tool/results">spooler Regression plls4ws</a></TD><TD><a href="collstat.pl?path=/home/plls4ws/pll_xg223/dss/dss.common.default/units/main/tool/results">(/home/plls4ws/pll_xg223/dss/dss.common.default/units/main/tool/results)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/tool/development/dss/dss.common.default/units/flowtest">FlowTest-TestCollection</a></TD><TD><a href="collstat.pl?path=/home/tool/development/dss/dss.common.default/units/flowtest">(/home/tool/development/dss/dss.common.default/units/flowtest)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/fcaprj/wicked_amix/nodm/default/units/clock_generator">flowtest_cells</a></TD><TD><a href="collstat.pl?path=/home/fcaprj/wicked_amix/nodm/default/units/clock_generator">(/home/fcaprj/wicked_amix/nodm/default/units/clock_generator)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/fcaprj/wicked_amix/nodm/default/units/clock_generator/dsi_Results">flowtest_cells</a></TD><TD><a href="collstat.pl?path=/home/fcaprj/wicked_amix/nodm/default/units/clock_generator/dsi_Results">(/home/fcaprj/wicked_amix/nodm/default/units/clock_generator/dsi_Results)</a></TD></TR>


<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/fwflow/clk_6.0/nodm/v0.0.0/units/clock_generator">flowtest_cells</a></TD><TD><a href="collstat.pl?path=/home/fwflow/clk_6.0/nodm/v0.0.0/units/clock_generator">(/home/fwflow/clk_6.0/nodm/v0.0.0/units/clock_generator)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/fwflow/clk_6.0_rh5/nodm/v0.0.0/units/clock_generator">flowtest_cells</a></TD><TD><a href="collstat.pl?path=/home/fwflow/clk_6.0_rh5/nodm/v0.0.0/units/clock_generator">(/home/fwflow/clk_6.0_rh5/nodm/v0.0.0/units/clock_generator)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/fwflow/clk_AMIXFP2/nodm/v0.0.0/units/clock_generator">flowtest_cells</a></TD><TD><a href="collstat.pl?path=/home/fwflow/clk_AMIXFP2/nodm/v0.0.0/units/clock_generator">(/home/fwflow/clk_AMIXFP2/nodm/v0.0.0/units/clock_generator)</a></TD></TR>

<TR><TD>o</TD><TD><a href="collstat.pl?path=R:/tool_3.0/tooltest/win/tool3.0_Results_demo">tool_test_cells</a></TD><TD><a href="collstat.pl?path=R:/tool_3.0/tooltest/win/tool3.0_Results_demo">(R:/tool_3.0/tooltest/win/tool3.0_Results_demo)</a></TD></TR>
<TR><TD>o</TD><TD><a href="collstat.pl?path=/home/micado/c11n_v311/dss/dss.common.default/units/demonstrators/home/steve/tool2.1.1_Results">tool_test_cells_patch_cells</a></TD><TD><a href="collstat.pl?path=/home/micado/c11n_v311/dss/dss.common.default/units/demonstrators/home/steve/tool2.1.1_Results">(/home/micado/c11n_v311/dss/dss.common.default/units/demonstrators/home/steve/tool2.1.1_Results)</a></TD></TR>
</TABLE><P><BR><hr>

<p /><br />
</body>
</html>######################################

Philip M
06-25-2012, 11:03 AM
I doubt if many people will have the time (or inclination) to disentangle your unreadable code.

To start with, when posting here please help us to help you by following the posting guidelines and wrapping your code in CODE tags. This means use the octothorpe or # button on the toolbar. You can (and should) edit your previous post. Otherwise I would say that you have no chance at all.


It is your responsibility to die() if necessary….. - PHP Manual

xaverian
06-25-2012, 04:57 PM
Can anybody please help me out on this ?

For ease of your understanding of my requirement , please see the following link:

http://www.developerextensions.com/index.php/extjs-grid-query-builder


The filtering implemented in the above link, I want somethinf of that sort.

Thanks.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum