Comments on Dan McGhan's Oracle Blog: Transposed Report Example

What would be the best approach for something like...

2009-11-10T16:11:50.365-05:00

What would be the best approach for something like this? I wanted to make a sign up application for different events and as more records and attributes are added I can see this query coming to a screeching halt.

I agree. I saw inner joins before I even finished ...

2009-11-03T23:23:13.677-05:00

I agree. I saw inner joins before I even finished reading the post!

Anonymous, I agree, I don't like to see data ...

2009-11-02T19:46:24.800-05:00

Anonymous,

I agree, I don't like to see data stored this way either. This post was really just to demonstrate how one could use the flexibility of Apex to work with such a design.

Ugghh this wreaks of the EAV method... What is ...

2009-11-02T18:05:36.755-05:00

Ugghh this wreaks of the EAV method...

What is the query to show me all Concert tickets at Madison Square Garden for Metallica between $30 and $65 in the orchestra section? I smell tons of inner joins and filters on attribute types instead of accessing the columns directly.

Flexible sure- the best approach? Doubtful.

Anonymous, Thanks, should be working now.

2009-11-02T12:50:39.988-05:00

Anonymous,

Thanks, should be working now.

Hi, Is link to demo wrong? It comes to this same ...

2009-11-02T12:44:44.728-05:00

Hi,

Is link to demo wrong?
It comes to this same page