Modify ↓

Opened 16 years ago

Closed 4 years ago

#4473 closed defect (wontfix)

Cannot access database views in SQLQueryMacro.

Reported by: rhidalgo@… Owned by: James Mills
Priority: normal Component: SqlQueryMacro
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

It seems that when a SQL statement accesses a view in the database (SQLite), the result is 'No results'. Is there a limitation on the database objects the macro accomodates?

Attachments (0)

Change History (1)

comment:1 Changed 4 years ago by Ryan J Ollos

Resolution: → wontfix
Status: new → closed

​wiki:TracDev/DatabaseApi#GuidelinesforSQLStatements says:

you may use views if you feel you need them, but this not used within Trac core

Please try after the patch in #12023 is committed.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain James Mills.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.