cancel
Showing results for 
Search instead for 
Did you mean: 

Adjust maxhits in Bol query

Former Member
0 Kudos
295

Hello,

i use in my coding the query for opportunities like this:

query = cl_crm_bol_dquery_service=>get_instance( 'BTQ1Order' ).
  query->add_selection_param( iv_attr_name = 'BU_PARTNER'
                              iv_sign = 'I'
                              iv_option = 'EQ'
                              iv_low = lv_partner_no ).
  query->add_selection_param( iv_attr_name = 'OBJECT_TYPE'
                              iv_sign = 'I'
                              iv_option = 'EQ'
                              iv_low = 'BUS2000111' ).
  query->add_selection_param( iv_attr_name = 'POSTING_DATE'
                              iv_sign = 'I'
                              iv_option = 'BT'
                              iv_low = lv_datlo
                              iv_high = lv_dathig
                              ).

  result ?= query->get_query_result( ).

With this coding the result is maximum 100 Opportunities.

How can i adjust or delete this restriction of 100 entries?

Thanks a lot.

Best regards

Manfred

Accepted Solutions (1)

Accepted Solutions (1)

arunprakash_karuppanan
Active Contributor
0 Kudos

Hi,

You can use the query->set_query_parameters( ) method. It uses a name_value tab for setting parameters(it_parameters). Include parameter 'MAX_HITS' and the desired value in this table and set it via this method.

Regards,

Arun Prakash

Former Member
0 Kudos

Hi,

Can you please tell me how can I ensure that the 100 hits that are picked up using MAX_HITS are the latest hundred hits.

Regards

Priyanka

Answers (0)