Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    May 2012
    Posts
    56
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Dynamic query builder help required

    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 !!!

    #################################
    Code:
    <!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>
    ######################################
    Last edited by xaverian; 06-25-2012 at 11:17 AM. Reason: To make the post readable and clear

  • #2
    Supreme Master coder! Philip M's Avatar
    Join Date
    Jun 2002
    Location
    London, England
    Posts
    18,303
    Thanks
    203
    Thanked 2,562 Times in 2,540 Posts
    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

    All the code given in this post has been tested and is intended to address the question asked.
    Unless stated otherwise it is not just a demonstration.

  • #3
    New Coder
    Join Date
    May 2012
    Posts
    56
    Thanks
    3
    Thanked 0 Times in 0 Posts
    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/i...-query-builder


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

    Thanks.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •