Can a custom query be created to use the aptran, pjtran and purorddet tables or are the queries limited to a single table?
Cherie
*This post is locked for comments
Can a custom query be created to use the aptran, pjtran and purorddet tables or are the queries limited to a single table?
Cherie
*This post is locked for comments
Quick Query are based on SQL views. In theory, any query that can be built as a view can work out. The only restriction I remember is that in order to use the pagination feature, there must be a unique key (can be a combination of fields) through the view.
Basically, any query you can write & get working in SQL can be used to create a new custom Quick Query.