the "sort" parameter is not used for options and DB connection type, but
as you already noticed, it's also not needed since one can easily define
the sort/order directly via the SQL definition.
armin
On 29/10/15 15:42, jose mvm wrote:
> Hi,
>
> I' am trying to get a drop-down list for search, sorted by descending order:
>
> =====
> <searchitem name="RegistoProcessosObra" description="Processos de Obra">
> <layer type="postgis" name="RegistoProcessosObra">
> <field type="n" name="proc_ano"
> description="Ano" wildcard="2">
> <definition type="options"
> connectiontype="db" sort="desc">
> <dsn
> encoding="UTF-8">pgsql://zemacau:z53498k@10.27.2.24/pmapper</dsn>
> <sql>SELECT DISTINCT proc_ano,
> proc_ano FROM p_obra WHERE proc_ano IS
> NOT NULL ORDER BY proc_ano</sql>
> </definition>
> </field>
> <field type="n" name="proc_numero"
> description="Número" wildcard="2" />
> <field type="s" name="cod_edificio"
> description="Código Edifício"
> wildcard="0" />
> </layer>
> </searchitem>
> =====
>
> But it seems to me that the option SORT in the search.xml file is ignored by
> the search.php file...
>
> pm_debug.log shows me that information:
>
> =====
> [29-Oct-2015 14:20:04] P.MAPPER debug info
> XML->//definition
> SimpleXMLElement Object
> (
> [@attributes] => Array
> (
> [type] => options
> [connectiontype] => db
> [sort] => desc
> )
>
> [dsn] => pgsql://zemacau:z53498k@10.27.2.24/pmapper
> [sql] => SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano
> IS NOT NULL ORDER BY proc_ano
> )
>
> [29-Oct-2015 14:20:04] P.MAPPER debug info
> search.php->getOptionsFromDb()
> SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL
> ORDER BY proc_ano
> [29-Oct-2015 14:20:04] P.MAPPER debug info
> search.php->getOptionsFromDb()->json
> { "1960":"1960", "1961":"1961", "1962":"1962", "1963":"1963",
> "1964":"1964", "1967":"1967", "1969":"1969", "1970":"1970", "1972":"1972",
> "1975":"1975", "1979":"1979", "1984":"1984", "1985":"1985", "1986":"1986",
> "1987":"1987", "1988":"1988", "1989":"1989", "1990":"1990", "1991":"1991",
> "1992":"1992", "1993":"1993", "1994":"1994", "1995":"1995", "1996":"1996",
> "1997":"1997", "1998":"1998", "1999":"1999", "2000":"2000", "2001":"2001",
> "2002":"2002", "2003":"2003", "2004":"2004", "2005":"2005", "2006":"2006",
> "2007":"2007", "2008":"2008", "2009":"2009", "2010":"2010", "2011":"2011",
> "2012":"2012", "2013":"2013", "2014":"2014", "2015":"2015"}
> =====
>
> If i force the SELECT in search.xml file with DESC, like this:
>
> <sql>SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT
> NULL ORDER BY proc_ano DESC</sql>
>
> the pm_debug.log shows me the coorect information:
>
> =====
> XML->//definition
> SimpleXMLElement Object
> (
> [@attributes] => Array
> (
> [type] => options
> [connectiontype] => db
> [sort] => desc
> )
>
> [dsn] => pgsql://zemacau:z53498k@10.27.2.24/pmapper
> [sql] => SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano
> IS NOT NULL ORDER BY proc_ano DESC
> )
>
> [29-Oct-2015 14:27:18] P.MAPPER debug info
> search.php->getOptionsFromDb()
> SELECT DISTINCT proc_ano, proc_ano FROM p_obra WHERE proc_ano IS NOT NULL
> ORDER BY proc_ano DESC
> [29-Oct-2015 14:27:18] P.MAPPER debug info
> search.php->getOptionsFromDb()->json
> { "2015":"2015", "2014":"2014", "2013":"2013", "2012":"2012",
> "2011":"2011", "2010":"2010", "2009":"2009", "2008":"2008", "2007":"2007",
> "2006":"2006", "2005":"2005", "2004":"2004", "2003":"2003", "2002":"2002",
> "2001":"2001", "2000":"2000", "1999":"1999", "1998":"1998", "1997":"1997",
> "1996":"1996", "1995":"1995", "1994":"1994", "1993":"1993", "1992":"1992",
> "1991":"1991", "1990":"1990", "1989":"1989", "1988":"1988", "1987":"1987",
> "1986":"1986", "1985":"1985", "1984":"1984", "1979":"1979", "1975":"1975",
> "1972":"1972", "1970":"1970", "1969":"1969", "1967":"1967", "1964":"1964",
> "1963":"1963", "1962":"1962", "1961":"1961", "1960":"1960"}
> =====
>
> But the drop-down list appears always sorted in ascending order...
> <http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025805/dropdownlist.jpg>
>
> I think this is a pmapper bug...
>
> Can anyone help me, please?
> Thanks in advance
>
>
>
>
> --
> View this message in context:
> http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-4-3-2-search-in-postgis-with-option-sort-desc-tp4025805.html
> Sent from the pmapper-users -- p.mapper users mailing list mailing list
> archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
------------------------------------------------------------------------------
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
