Skip to Content
avatar image
Former Member

Search rule set pre defined columns in result table

Mar 02, 2017 at 07:12 AM | 23 Views

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 .

SAP HANA studio
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    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.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded