Reply to thread

Message

<blockquote data-quote="Hesse" data-source="post: 78795" data-attributes="member: 23814">The SQL code is quite easy if the developers want to add the index view.&nbsp; I'm working on a generic media module similar to in meedio and I've got the views pretty much working, I've just been busy lately and haven't had time to work on it.For a top level view, you could use:[CODE]strSQL = String.Format(&quot;SELECT substr({0}, 1, 1) AS first, {5} FROM {1} GROUP BY first ORDER BY first {4}&quot;, MPCurrentItem.strGroupBy, MPCurrentItem.strTable, MPCurrentItem.strSortBy, MPCurrentItem.strSortBy, MPCurrentItem.strSortAsc, MPCurrentItem.strImageColumn);[/CODE]Then for the next level after the index, I use:[CODE]strSQL = String.Format(&quot;SELECT {0}, {7} FROM {1} WHERE substr({5}, 1, 1) LIKE '{6}' GROUP BY {2} ORDER BY {3} {4}&quot;, MPCurrentItem.strGroupBy, MPCurrentItem.strTable, MPCurrentItem.strSortBy, MPCurrentItem.strSortBy, MPCurrentItem.strSortAsc, MPPreviousItem.strSortBy, &quot;{0}&quot;, MPCurrentItem.strImageColumn);[/CODE]</blockquote>

[QUOTE="Hesse, post: 78795, member: 23814"] The SQL code is quite easy if the developers want to add the index view. I'm working on a generic media module similar to in meedio and I've got the views pretty much working, I've just been busy lately and haven't had time to work on it. For a top level view, you could use: [CODE] strSQL = String.Format("SELECT substr({0}, 1, 1) AS first, {5} FROM {1} GROUP BY first ORDER BY first {4}", MPCurrentItem.strGroupBy, MPCurrentItem.strTable, MPCurrentItem.strSortBy, MPCurrentItem.strSortBy, MPCurrentItem.strSortAsc, MPCurrentItem.strImageColumn); [/CODE] Then for the next level after the index, I use: [CODE] strSQL = String.Format("SELECT {0}, {7} FROM {1} WHERE substr({5}, 1, 1) LIKE '{6}' GROUP BY {2} ORDER BY {3} {4}", MPCurrentItem.strGroupBy, MPCurrentItem.strTable, MPCurrentItem.strSortBy, MPCurrentItem.strSortBy, MPCurrentItem.strSortAsc, MPPreviousItem.strSortBy, "{0}", MPCurrentItem.strImageColumn); [/CODE] [/QUOTE]

Verification