BASIC GLOBAL SEARCH IN PEOPLESOFT

 

HOW TO CREATE GLOBAL SEARCH


MAINMENU>REPORTINGTOOLS>QUERY MANAGER
STEP:1MAINMENU>REPORTING TOOLS > QUERY MANAGER>
1.LAST EFFDATE COLUMN
2.CRETRIA FOR EFFDT
 IS NOT LESS THAN
CREATE A PSQUERY 
OR (USE CONNECTED QUERY) OR (USE DOCUMENTS ALSO)

PEOPLETOOLS>SEARCH FRAME WORK>DESIGNER>

DEFINE SEARCH DEFINITION
STEP:1PEOPLETOOLS>SEARCHFRAMEWORK>
DESIGNER>  DEFINE SEARCH DEFNITIONS

1.MAP DATE ,LINK COLUMN
2.ADD TITLE,SUMMARY
3.MAP SEARCH ATTRIBUTE IN TOP (SELECT FIELDS FOR GLOBAL SEARCH DISPAY)&FACETED

ADD NEW VALUE
CREATE SEARCH DEFINITION NAME* 
SOURCE TYPPE =QUERY
ADD+
SOURCE NAME=PS_QUERY NAME

DEFINE SEARCH CATAGORY

STEP:2

PEOPLETOOLS>SEARCH FRAMEWORK> DESIGNER>  DEFINE SEARCH CATEGORIES

CHECK BOX (SEARCH GROUP)
MAP SEARCH  DEFINITION NAME BELOW AND SAVE

ADD NEW VALUE
SEARCH CATEGUARY=SAME NAME SEARCH DEFNITION NAME




PEOPLETOOLS>SEARCH FRAME WORK>ADMINISTRATOR>
DEFINE SEARCH CONTEX
STEP:1      PEOPLETOOLS>SEARCH FRAMEWORK>
ADMINISTRATOR> DEFINE SEARCH CONTEX		ADD NEW VALUE(+)
SEARCH category name and SAVE
DEPLOY SEARCH OBJECT 
STEP2PEOPLETOOLS>SEARCH FRAMEWORK>
ADMINISTRATOR> DEPLOY SEARCH OBJECT		SELECT OUR CREATED SEARCH DEFNITION
AND CLICK DEPLOY
SHEDULE SEARCH INDEX-TRANSFRT DATA PT-SEARCH ENGINE
STEP:3PEOPLETOOLS>SEARCH FRAMEWORK>
ADMINISTRATOR> SHEDULE SEARCH INDEX		FULL INDEX CHECK BOX
FOR ALL PS QUER DATA TO SEARCH ENGINE		RUN CONTROL ID=SEARCH DEFINITION NAME
ADD
MAP A SEARCH TO SECURITY
STEP:1PEOPLETOOLD>SECURITY>
PERMISSION AND ROLE>ROLES		1.SELECT ANY ROLE>
PERMISSION LIST>VIEW DEFINITION>
2.BELOW SEARCH GROUP ADD +
CATAGERY NAME AND ADD

Comments

Post a Comment

Popular posts from this blog

SQL TO SEE ALL THE OBJECTS IN PROJECT BY PROJECT NAME (PEOPLESOFT)

SELECT PROJECTNAME  ,OBJECTTYPE     , CASE OBJECTTYPE WHEN 0 THEN CASE NVL((     SELECT RECTYPE      FROM PSRECDEFN     WHERE RECNAME = I.OBJECTVALUE1), 99) WHEN 0 THEN 'SQL Table in DB' WHEN 1 THEN 'SQL View in DB' WHEN 2 THEN  'Work Record' WHEN 3 THEN 'Sub Record' WHEN 5 THEN 'Dynamic View' WHEN 6 THEN 'Query View' WHEN 7 THEN  'Temporary Table' ELSE 'Other Record or Deleted' END WHEN 1 THEN 'Index' WHEN 2 THEN 'Field' WHEN 3 THEN  'Field Format' WHEN 4 THEN 'Translate Value' WHEN 5 THEN 'Page' WHEN 6 THEN 'Menu' WHEN 7 THEN 'Component'  WHEN 8 THEN 'Record PeopleCode' WHEN 9 THEN 'Menu PeopleCode' WHEN 10 THEN 'Query' WHEN 11 THEN 'Tree  Structure' WHEN 12 THEN 'Tree' WHEN 13 THEN 'Access Group' WHEN 14 THEN 'Color' WHEN 15 THEN 'Style' WHEN 16  THEN 'Business Process Map' WHEN 17 THEN 'Bu...
Read more

BIP (BIPUBLISHER) Using PS_Query

HOW TO CREATE BI-PUBLISHER REPORT CREATE PS QUERY BASED ON REQUIRMENTS OF OUR REPORT REGISTER BIP DATA SOURCE STEP:1 MAINMENU>REPORTING TOOLS> BI PUBLISHER> REGISTER BIP DATA SOURCE ADD NEW VALUE (+)  SOURCE TYPE=QUERY SOURCE ID= PS-QUERY NAME GENERATE XML FOR OUR QUERY DOWNLOAD THAT XML FILE UPLOAD THAT FILE IN WORD BI PUBLISHER MODIFY THE WORF FILE BASED ON OUR REQUIRMENTS SAVE THAT FILE AS RTCH TEXT FORMATE(RTF) CREATING BIP REPORT DEFINITION STEP:2 MAINMENU>REPORTING TOOLS> BI PUBLISHER> CREATE BIP REPORT DEFINITION ADD NEW VALUE (+)  REPORT NAME= NEW NAME FOR REPORT DATA SOURCR TYPE=QUERY DATA SOURCT ID=PS-QUERY NAME INSIDE TABS 1.DEFINITION TAB DESCR= CREATE DESCR REPORT STATUS ACTIVE MAKE IT ALLUSERS 2.TEMPLATE TAB CHANGE STATUS TO ACTIVE UPLODE RTF FILE 3.OUTPUT TAB CHANGE OUT PUT TYPE AS PER YOUR REQUIRMENTS MAKE DEFAULT AS PDF BIP QUERY REPORT VIEWER STEP:3 MAINMENU>REPORTING TOOLS> BI PUBLISHER> BIP QUERY REPORT VIEWER REPORT NAME= (WHAT...
Read more