Json export for Phoca categories (Joomla 3)

[innovader]

Hello,

I am looking to find out how to create an SQL view for my phoca download categories. Usually I create the view easily in phpMyadmn and then I enable the view from the Json export plugin on the back-end.
This method is used when I am looking to load content dynamically from a Joomla website to an app's page using phonegap.

Regards

[Jan]

Hi, what you exactly mean with "SQL view for my phoca download categories"

All SQL queries to build a categories view are stored in model:

components/com_phocadownload/models/categories.php

Jan