From 5bbaea50e46bda3524f5df929d974883a06dbeaa Mon Sep 17 00:00:00 2001 From: UbitUmarov Date: Sun, 13 Oct 2019 18:52:33 +0100 Subject: groups v2: remove wrong filters on DB search --- OpenSim/Data/PGSQL/PGSQLGroupsData.cs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'OpenSim/Data/PGSQL/PGSQLGroupsData.cs') diff --git a/OpenSim/Data/PGSQL/PGSQLGroupsData.cs b/OpenSim/Data/PGSQL/PGSQLGroupsData.cs index f398256..04e2f69 100755 --- a/OpenSim/Data/PGSQL/PGSQLGroupsData.cs +++ b/OpenSim/Data/PGSQL/PGSQLGroupsData.cs @@ -86,13 +86,13 @@ namespace OpenSim.Data.PGSQL if (string.IsNullOrEmpty(pattern)) // True for where clause { - pattern = " 1 ORDER BY lower(\"Name\") LIMIT 100"; + pattern = "1"; return m_Groups.Get(pattern); } else { - pattern = " \"ShowInList\" = 1 AND lower(\"Name\") LIKE lower('%" + pattern + "%') ORDER BY lower(\"Name\") LIMIT 100"; + pattern = " \"ShowInList\" = 1 AND lower(\"Name\") LIKE lower('%" + pattern + "%')"; return m_Groups.Get(pattern, new NpgsqlParameter("pattern", pattern)); } -- cgit v1.1