Nico,
Thanks for your response. The tables were already joined in the query
definition inside the controller.
query = ((db2.STATUSPOINT.POINTNUMBER < 100)&\
(db2.STATUSPOINT.POINTACCESSAREA == db2.AOR.AOR))
I feel quite certain that the problem is associated with the extra SQL
required to do pagination on an Oracle database. I have tested this theory
to the extent that I successfully implemented the same controller, model,
and data on a mysql database, and everything worked perfectly.
I've included the models as you suggested:
db2 = DAL('oracle://******/********@*****', migrate=False)
db2.define_table('AOR',
Field('AOR','integer',writable=False),
Field('REFERENCENAME','string',writable=False),
Field('ACCESSAREAASSIGNMENT','integer',writable=False),
Field('ACCESSZONEASSIGNMENT','integer,writable=False'),
primarykey=['AOR'],
migrate=False
)
db2.define_table('STATUSPOINT',
Field('POINTNUMBER',
'integer',writable=False),
Field('POINTNAME',
'string',writable=False),
Field('LOGPARTITION',
'integer',writable=False),
Field('POINTACCESSAREA',
'integer',writable=False),
Field('ALTERNATEMENUINFORMATIONAREA',
'integer',writable=False),
Field('LOGICALDISPLAYREFERENCE',
'string',writable=False),
Field('STATION',
'integer',writable=False),
Field('GROUPINHERITANCE',
'integer',writable=False),
Field('TRIGGERS',
'integer',writable=False),
Field('INITIALVALUE',
'integer',writable=False),
Field('PROPAGATEINITIALVALUE',
'string',writable=False),
Field('SETNONUPDATE',
'string',writable=False),
Field('MANUALOVERRIDE',
'string',writable=False),
Field('MANUALENTRY',
'string',writable=False),
Field('EVENTS',
'string',writable=False),
Field('MAPBOARDGROUPNUMBER',
'integer',writable=False),
Field('DATADIVISION',
'integer',writable=False),
Field('ANALOGDEMANDSCAN',
'string',writable=False),
Field('STATEFEATURES',
'integer',writable=False),
Field('STATECALCULATOR',
'integer',writable=False),
Field('CONTROL',
'integer',writable=False),
Field('INDICATION',
'integer',writable=False),
Field('ALTDATASOURCELIST',
'integer',writable=False),
Field('ALTDATASOURCEUSAGELIST',
'integer',writable=False),
Field('ALTDATASOURCEPROC',
'integer',writable=False),
Field('ASSOCDEVICESETNUMBER',
'integer',writable=False),
Field('ASSETID',
'string',writable=False),
Field('PICOLLECTION',
'string',writable=False),
Field('PIVALUETAG',
'string',writable=False),
Field('PIQUALITYSTORAGE',
'string',writable=False),
Field('PIQUALITYTAG',
'string',writable=False),
Field('COLLECTTOHISTORICAL',
'integer',writable=False),
Field('POINTURLS',
'integer',writable=False),
Field('ACTIONDESCRIPTIONSET',
'integer',writable=False),
Field('CIRCUITLABELNUMBER',
'integer',writable=False),
Field('SUBSTATIONNUMBER',
'integer',writable=False),
Field('DEVICETYPENUMBER',
'integer',writable=False),
Field('LONGNAMENUMBER',
'integer',writable=False),
Field('TOGGLERELEASETHRESHOLD',
'integer',writable=False),
Field('TOGGLEINHIBITTHRESHOLD',
'integer',writable=False),
Field('CONTROLWARNING',
'integer',writable=False),
Field('EDNACOLLECTION',
'string',writable=False),
Field('EDNAEXTIDENTIFIER',
'string',writable=False),
Field('EDNAQUALITYSTORAGE',
'string',writable=False),
Field('EDNASECURITYGROUP',
'integer',writable=False),
Field('DOG1REF',
'integer',writable=False),
Field('DOG2REF',
'integer',writable=False),
Field('DOG3REF',
'integer',writable=False),
Field('DOG4REF',
'integer',writable=False),
Field('DH_READ_REFERENCE',
'integer',writable=False),
Field('PI_DIGITAL_SET_NUMBER',
'integer',writable=False),
Field('DOG_ASSIGNMENT_FKO',
'integer',writable=False),
Field('DOM',
'string',writable=False),
Field('OPCSERVERITEM',
'integer',writable=False),
Field('SCADAGROUP_FKO',
'integer',writable=False),
Field('TRANSIENTSTATEDELAY',
'integer',writable=False),
Field('TRIPPEDBREAKERSUMMARY',
'string',writable=False),
primarykey=['POINTNUMBER'],
migrate=False
)
- Tom
On Tuesday, September 6, 2016 at 12:20:42 AM UTC-6, Nico de Groot wrote:
>
> Hi Tom,
> I think you need to specify the join between the two tables in the query,
> otherwise you get the full product of the two tables. Please check the
> Web2py book at
> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Inner-joins
>
>
> Please show the model files if you need more help.
>
> Nico de Groot
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
