Required Alternate Functionality of Drupal View in DKAN 2

[muhammadmohsinali]

I have query, I want to create a report of datasets (meta fields such as title, desc, tags, topics etc.). In Dkan 1 there is drupal view of dataset content type & I can play that with that view, I can sort, add filter criteria etc. But I cannot use Drupal views in DKAN 2 because dataset meta information is wrapped in json in field_json_metadata_value column. How can I prepare a report with the same functionality as it is in DKAN 1 with drupal views. Is there any recommendations? Or how can I decode json metadata and prepare a report? Thanks in advance.

[janette]

@muhammadmohsinali you can create custom code to break up the json metadata into "fields", have a look at

• https://api.drupal.org/api/drupal/core%21modules%21views%21views.theme.inc/function/template_preprocess_views_view_field/8.2.x
• https://kevinquillen.com/overriding-output-search-api-fields-views
• https://github.com/GetDKAN/dkan/blob/2.x/modules/metastore/modules/metastore_admin/metastore_admin.module#L37

[dafeder]

@muhammadmohsinali also, because DKAN is integrated with the Search API, you can create a view based on that search API index. However I believe we need to do more work on that integration in order to return more than simply the dataset UUID in each result. We may be looking into this in the next few months but would welcome a contribution if you get to it first!