Iterate down one data source, filtering another panel based on the contents of a field

Iterate down one data source, filtering another panel based on the contents of one of the fields

To install this script, navigate to the Adobe InDesign Application Directory and paste the script file into the following folder ‘Scripts -> Scripts Panel’. The script can then be run from the Scripts panel; this is found in ‘Window -> Utilities -> Scripts’.

var bodyDSName = "ENTER NAME OF DATASOURCE TO EXTRACT FIELD CONTENTS FROM";
var calloutDSName = "ENTER NAME OF DATASOURCE TO FILTER";
var fieldContentName = "ENTER THE NAME OF THE FIELD TO EXTRACT CONTENTS FROM";
var filterField = "ENTER THE NAME OF THE FIELD YOU WISH TO FILTER";
var filterOperator = "ENTER THE OPERATOR FOR THE FILTER"; //i.e "=" ">" "<" "<>"

var myEasyCatalog = app.easycatalogObject; 
var bodyDS = app.easycatalogObject.datasources.item(bodyDSName);
var calloutDS = app.easycatalogObject.datasources.item(calloutDSName);

var bodyDV = bodyDS.dataviews.item(bodyDSName);
var calloutDV = calloutDS.dataviews.item(calloutDSName);

for (i = 0; i < bodyDV.records.count(); ++i) 
{
	var record = bodyDV.records.item(i);
	$.writeln(record.fields.item(fieldContentName).fieldContent);
	calloutDV.subsetOf(filterField, filterOperator, record.fields.item(fieldContentName).fieldContent, true);
}

var bodyDSName = "ENTER NAME OF DATASOURCE TO EXTRACT FIELD CONTENTS FROM";

var calloutDSName = "ENTER NAME OF DATASOURCE TO FILTER";

var fieldContentName = "ENTER THE NAME OF THE FIELD TO EXTRACT CONTENTS FROM";

var filterField = "ENTER THE NAME OF THE FIELD YOU WISH TO FILTER";

var filterOperator = "ENTER THE OPERATOR FOR THE FILTER"; //i.e "=" ">" "<" "<>"

var myEasyCatalog = app.easycatalogObject;

var bodyDS = app.easycatalogObject.datasources.item(bodyDSName);

var calloutDS = app.easycatalogObject.datasources.item(calloutDSName);

var bodyDV = bodyDS.dataviews.item(bodyDSName);

var calloutDV = calloutDS.dataviews.item(calloutDSName);

for (i = 0; i < bodyDV.records.count(); ++i)

{

var record = bodyDV.records.item(i);

$.writeln(record.fields.item(fieldContentName).fieldContent);

calloutDV.subsetOf(filterField, filterOperator, record.fields.item(fieldContentName).fieldContent, true);

}

Iterate down one data source, filtering another panel based on the contents of a field

What’s new in 2025

Empower your catalogs at a free Nousmedis and SalesLayer webinar, June 4, 2024.

What’s New In 2024

EasyCatalog Training

Start your free trial today