Hello Experts ,
Where can we find the predefined columns for the search rule set . For ex . if i execute a search rule set i get only score and rule id but i need to configure in such a way so that i will receive rule number also in the result table . Where to configure my result table parameters ?
Awaiting your response .
Thanks in advance .
It depends on how you wanna retrieve your result.
In case you are storing the result of SYS.EXECUTE_SEARCH_RULE_SET directly in a table you just have to add the column "_RULE_NUMBER" to the table.
In case you are dealing with the result set of SYS.EXECUTE_SEARCH_RULE_SET, you have to add a "resultsetcolumn name" for "_RULE_NUMBER" to the XML you are passing to the procedure. E.g.
<resultsetcolumn name="_RULE_NUMBER"/>
You can check the Code Examples for Searching with a Rule Set in the online help.
Regards,
Florian
Hello pfeller ,
In the search rule set query we are not providing the result table name instead we are giving the rule set name which calls the attribute view but i dont find the columns defined there also but its returning with the _score , _rule_id and the view columns . Dont know where these two columns are fetched exactly .
Regards ,
Wilson
That are pre-defined columns (Executing a Search With a Rule Set).