Skip to Content

Search rule set pre defined columns in result table

Mar 02, 2017 at 07:12 AM


avatar image
Former Member

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 .

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Mar 02, 2017 at 08:37 AM

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.


Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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 ,



That are pre-defined columns (Executing a Search With a Rule Set).