Same Table included Twice

[George]

I have a table of notes "NOTES" on staff members. It has two columns
for staff Id's (staffId and updatedId).

The staffId links to the staff memeber that the note is about, the
updatedId links to the staff member that wrote the note.

If I include both of these in my model , how does wheels generate my
column names since its the same table included twice?

[Mohamad El-Husseini]

Self-referencing tables is not possible as far as I know. You'll have to write a custom query.

[George]

I think I figured a quick work around. Just create a view of that same
table and call it something else.

Then in my model, when ever I have to reference the same table twise,
I include the view version of the second table.

On Feb 10, 6:15 am, Mohamad El-Husseini <husseini....@gmail.com>
wrote:

[Mohamad El-Husseini]

I've never tried using a DB view with Wheels. Itsn't it easier to just write a custom query?

[George]

A custom query is not flexible and would have to be re-written every
time it changes and it also would break conventions.

If I create a view, very simple as new view (STAFF VIEW SQL = "Select
* from Staff" save as owners.

Then my model includes hasMany("owners").

Now any my models can include both Staff and Owners just fine. Could
not be simpler.

On Feb 10, 11:11 am, Mohamad El-Husseini <husseini....@gmail.com>
wrote: