Data & Services - Solr Server

// Create a new Solr collection
collectionCreate(
  name="products",
  path="/var/solr/data/products"
);

// Index files into the collection
collectionIndexPath(
  name="products",
  path="/var/www/products",
  recurse=true,
  extensions="pdf,doc,docx,html"
);

// Search the collection
searchResults = collectionSearch(
  name="products",
  criteria="laptop computer",
  maxRows=20,
  startRow=1
);

// Display results
for (result in searchResults.results) {
  writeOutput("<h3>#result.title#</h3>");
  writeOutput("<p>#result.summary#</p>");
  writeOutput("<p>Score: #result.score#</p>");
}

<!--- Create a new Solr collection --->
<cfcollection
  action="create"
  collection="products"
  path="/var/solr/data/products">

<!--- Index files into the collection --->
<cfindex
  action="refresh"
  collection="products"
  key="/var/www/products"
  type="path"
  recurse="true"
  extensions="pdf,doc,docx,html">

<!--- Search the collection --->
<cfsearch
  collection="products"
  criteria="laptop computer"
  maxrows="20"
  startrow="1"
  name="searchResults">

<!--- Display results --->
<cfloop query="searchResults">
  <h3><cfoutput>#title#</cfoutput></h3>
  <p><cfoutput>#summary#</cfoutput></p>
  <p>Score: <cfoutput>#score#</cfoutput></p>
</cfloop>

// Get products from database
products = queryExecute("
  SELECT id, name, description, category
  FROM products
  WHERE active = 1
");

// Index each product
collectionIndexCustom(
  name="products",
  body=products.description,
  title=products.name,
  key=products.id,
  custom1=products.category,
  type="custom"
);

// Search with filtering
searchResults = collectionSearch(
  name="products",
  criteria="wireless mouse",
  custom1="Electronics"  // Filter by category
);

<!--- Get products from database --->
<cfquery name="products">
  SELECT id, name, description, category
  FROM products
  WHERE active = 1
</cfquery>

<!--- Index each product --->
<cfindex
  action="update"
  collection="products"
  query="products"
  body="description"
  title="name"
  key="id"
  custom1="category"
  type="custom">

<!--- Search with filtering --->
<cfsearch
  collection="products"
  criteria="wireless mouse"
  custom1="Electronics"
  name="searchResults">