This section provides steps to review data and identify how fields will be used for search in order to build a WebFOCUS procedure to create Magnify index libraries.
Note: Usually fields that make high-level groupings, typically those used as BY fields, make good categories. Although numerical values, like price, usually do not make good categories as is, they make excellent categories when converted to a range.
Note: Searchable fields tend to be those that are alphanumeric strings, IDs, or any other data that is to be matched to searched terms.
Note: You can copy and paste Field, Format, and Value information from the table below into their respective places in the Define object.
Field |
Format |
Value |
Purpose |
---|---|---|---|
SYSSOURCE |
A25 |
'School Courses' |
Hard-coded category value. |
TUITION_RANGE |
A50 |
IF COURSE.CRSELIST.TUITION LT 1000 THEN '1. Under 1K' ELSE IF COURSE.CRSELIST.TUITION LT 2000 THEN'2. 1K-2K' ELSE '3. Over 2K' |
Granular data rolled up into a range. |
SEARCHTITLE |
A2000 |
'<b>Course Name:' | COURSE.CRSELIST.CTITLE |'('|COURSE.CRSELIST.COURSECODE ||')</b>' |
Text shown as the Search result main title. |
TITLE_URL |
A2000 |
'/ibi_apps/WFServlet?' || 'FXK=' || COURSE.CRSELIST.COURSECODE ||'&'||'IBIF_ex=courses_detail' ||'&'|| 'IBIAPP_app=magnify_courses' |
The main drill down link for the main title of the search results. In this case, a BI report passing the course code. |
LINK_DISPLAY_NAME1 |
A2000 |
'Search Other Department Courses' |
Additional drill-down text. |
LINK_URL1 |
A2000 |
'ibi_apps/search' ||'q='|| COURSE.CRSELIST.SOURCE |
Additional drill-down link. |
LINK_DISPLAY_NAME2 |
A2000 |
'All Courses in this Subject' |
Additional drill-down text. |
LINK_URL2 |
A2000 |
'/ibi_apps/WFServlet?' || 'FXK=' || COURSE.CRSELIST.CLASSIF ||'&'||'IBIF_ex=courses_similar' ||'&'|| 'IBIAPP_app=magnify_courses' |
Additional drill-down link. |
HARDCODED |
A50 |
'schools course' |
Additional searchable content not originally found with the data. |
For more information, see Indexing Using the FORMAT MAGNIFY Command.
Note: The URL value being referenced for the TITLE_URL and Link_URL2 fields does not exist. Therefore, when executed, the links for the main title link and second additional link of the search results will not drill down to a valid webpage.
Field |
Column Title (Case-Sensitive) |
Purpose |
---|---|---|
COURSECODE |
MagnifyID |
Unique identifiers (required) |
COURSECODE |
WF_INDEX_UNIQUE_KEY |
Unique identifiers (required) |
SYSSOURCE |
C1_Source_System |
Category |
SOURCE |
C2_Department |
Category |
CLASSIF |
C3_Subject |
Category |
TUITION_RANGE |
C4_Tuition_Range |
Category |
SEARCHTITLE |
SearchTitle |
Drill down link information |
TITLE_URL |
Drill down link information | |
LINK_DISPLAY_NAME1 |
Drill down link information | |
LINK_URL1 |
Drill down link information | |
LINK_DISPLAY_NAME2 |
Drill down link information | |
LINK_URL2 |
Drill down link information | |
DESCRIPTN1 |
S_DESCRIPTN1 |
Searchable content |
DESCRIPTN2 |
S_DESCRIPTN2 |
Searchable content |
DESCRIPTN3 |
S_DESCRIPTN3 |
Searchable content |
CTITLE |
S_CTITLE |
Searchable content |
COURSECODE |
S_COURSECODE |
Searchable content |
SYSSOURCE |
S_SYSSOURCE |
Searchable content |
SOURCE |
S_SOURCE |
Searchable content |
CLASSIF |
S_CLASSIF |
Searchable content |
HARDCODED |
S_HARDCODED |
Searchable content |
Note: The resulting column title dictates how the data will be used in the search interface.
For more information, see Indexing Using the FORMAT MAGNIFY Command.
Note: You can copy and paste connection or SET parameter information from the table below to their respective places in the Engine object.
Note: If the engine (MAGNIFY) (case-sensitive) does not display in the list, you must type it in manually. In addition, for connections listed as no connection, you must select no connection in order to activate the SET parameter field. The prior image shows an Engine entry.
For more information, see Indexing Using the FORMAT MAGNIFY Command.
Note: You must set the ASNAMES setting to MIXED in order to preserve case-sensitivity. For more information, see Indexing Using the FORMAT MAGNIFY Command.
Note: If you receive an error message indicating that your Magnify server is not licensed for indexing, please contact your WebFOCUS Administrator. For more information on this error message, see Magnify Error Handling.
http://host:port/wfcontext_root/search
where:
Is the machine name and port number where WebFOCUS is installed.
Is the WebFOCUS application root.
Note:
WebFOCUS |