def filter_buildQuery(self):
#Build query set and return results
columnList = ",".join(self.rptFields)
filterStmnt = self.txtSqlParser.toPlainText()
#Check if sorting has been defined
stLen,stSQL = self.sorting_compileSort()
#Check if grouping has been defined
gpLen,gpQuery = self.grouping_orderQuery()
sortStmnt=''
if gpLen > 0:
sortStmnt = gpQuery
if stLen>0:
stSQL = stSQL.replace(" ORDER BY","")
sortStmnt = sortStmnt+"," + stSQL
else:
if stLen>0:
sortStmnt = stSQL
results=None
try:
results = process_report_filter(self.tabName,columnList,filterStmnt,sortStmnt)
except sqlalchemy.exc.ProgrammingError,sqlalchemy.exc.DataError:
self.ErrorInfoMessage(QApplication.translate("ReportBuilder","The SQL statement is invalid!"))
def filter_buildQuery(self):
#Build query set and return results
queryCols = self.selectedColumns()
if self.geomColumn != "":
queryCols.append("ST_AsText(%s)"%(self.geomColumn))
columnList = ",".join(queryCols)
whereStmnt = self.txtWhereQuery.toPlainText()
sortStmnt=''
results=None
try:
results = process_report_filter(self.srcTab,columnList,whereStmnt,sortStmnt)
except sqlalchemy.exc.DataError,e:
if e is None:
errMessage = "Database Error Message - NOT AVAILABLE"
else:
errMessage = e.message
self.ErrorInfoMessage("The SQL statement is invalid!\n" + errMessage)
