Current time: 01-23-2021, 12:17 AM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Query Search Time
08-16-2010, 06:08 PM
Post: #23
RE: Database Query Search Time
Hello Again,

One thing about the SOLR searches is that there are only four custom fields. The Coldfusion documentation states that custom1 through custom4 do not work with the SOLR engine. However, that is not true.

I have more than four fields I want to do narrow down the results with. With custom4, I am setting this field to do boolean searches on different variables.

PRODUCT_VALIDATED = Has the product been validated by the admin staff?
PRODUCT_PHOTO = Does this product have a local image?
PRODUCT_GOOGLE_IMAGE_URL = Does this product have an external image?

All I need is one sequence of numbers for each boolean variable I want to do searches with. Because I have three boolean variables, I need three sequences of numbers.

The first number in the sequence will be 122 or 022. The second number in the sequence will be 212 or 202. The last number in the sequence will be 221 or 220.

To find products that have been validated and have photos on the local server I can set the criteria to this:

criteria="custom4:122 AND custom4:212"

To find products that have been validated and have photos on an external server I can set the criteria to this:

criteria="custom4:122 AND custom4:221"

More to come...

Sincerely,
Travis Walters
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Database Query Search Time - pmeenan - 07-04-2010, 12:03 PM
RE: Database Query Search Time - pmeenan - 07-05-2010, 04:35 AM
RE: Database Query Search Time - sajal - 07-05-2010, 05:03 AM
RE: Database Query Search Time - pmeenan - 07-08-2010, 08:47 PM
RE: Database Query Search Time - sajal - 08-13-2010, 10:06 PM
RE: Database Query Search Time - sajal - 08-14-2010, 03:38 AM
RE: Database Query Search Time - sajal - 08-14-2010, 06:50 AM
RE: Database Query Search Time - pmeenan - 08-16-2010, 02:55 AM
RE: Database Query Search Time - green-watch.org - 08-16-2010 06:08 PM
RE: Database Query Search Time - sajal - 08-17-2010, 01:14 AM
RE: Database Query Search Time - pmeenan - 08-23-2010, 01:22 AM
RE: Database Query Search Time - pmeenan - 08-23-2010, 08:45 PM
RE: Database Query Search Time - ringman57 - 08-24-2010, 11:52 PM
RE: Database Query Search Time - ringman57 - 08-25-2010, 02:54 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)