how to use IN operator in oracle apex classic report

-1

i want use in operator in oracle apex classic report for sorting details data and also multiple details data. so how can i do that by sql query?
please help me.

SELECT fr_st_invoiceno,
 sales_type,
 cust_id,
 sia_id,
 coll_amount,
 remarks,
 cash_bank,
 bank_name,
 check_no,
 update_id,
 updatedate,
 slno,
 invoice_type,
 trcode,
 send_voucher_no,
 send_voucher_no_depot
FROM dis_invoice_tk_collection
WHERE position = 1
 AND fromstore_id =:p157_depot
 AND send_voucher_no IN (:p157_send_voucher_no)

Thanks & best regard.
morshed.

edited Nov 20 '18 at 17:51

Littlefoot

23.8k71534

asked Nov 14 '18 at 10:55

Md Morshed Alam

214

I'm afraid I don't understand the question. What problems do you have when using IN? It works in a classic report as anywhere else. If you want to sort data, user ORDER BY (what does IN have to do with it?). What is "multiple details data"? Could you provide some more info, create a test case, attach a screenshot ... anything?

– Littlefoot
Nov 14 '18 at 20:19

i want to use this code in classic report: select FR_ST_INVOICENO, SALES_TYPE, CUST_ID, SIA_ID, COLL_AMOUNT, REMARKS, CASH_BANK, BANK_NAME, CHECK_NO, UPDATE_ID, UPDATEDATE, SLNO, INVOICE_TYPE, TRCODE, SEND_VOUCHER_NO, SEND_VOUCHER_NO_DEPOT from DIS_INVOICE_TK_COLLECTION where POSITION=1 and FROMSTORE_ID =:P157_DEPOT and SEND_VOUCHER_NO in (:P157_SEND_VOUCHER_NO) but i can't...

– Md Morshed Alam
Nov 20 '18 at 10:32

add a comment |

-1

i want use in operator in oracle apex classic report for sorting details data and also multiple details data. so how can i do that by sql query?
please help me.

SELECT fr_st_invoiceno,
 sales_type,
 cust_id,
 sia_id,
 coll_amount,
 remarks,
 cash_bank,
 bank_name,
 check_no,
 update_id,
 updatedate,
 slno,
 invoice_type,
 trcode,
 send_voucher_no,
 send_voucher_no_depot
FROM dis_invoice_tk_collection
WHERE position = 1
 AND fromstore_id =:p157_depot
 AND send_voucher_no IN (:p157_send_voucher_no)

Thanks & best regard.
morshed.

edited Nov 20 '18 at 17:51

Littlefoot

23.8k71534

asked Nov 14 '18 at 10:55

Md Morshed Alam

214

I'm afraid I don't understand the question. What problems do you have when using IN? It works in a classic report as anywhere else. If you want to sort data, user ORDER BY (what does IN have to do with it?). What is "multiple details data"? Could you provide some more info, create a test case, attach a screenshot ... anything?

– Littlefoot
Nov 14 '18 at 20:19

i want to use this code in classic report: select FR_ST_INVOICENO, SALES_TYPE, CUST_ID, SIA_ID, COLL_AMOUNT, REMARKS, CASH_BANK, BANK_NAME, CHECK_NO, UPDATE_ID, UPDATEDATE, SLNO, INVOICE_TYPE, TRCODE, SEND_VOUCHER_NO, SEND_VOUCHER_NO_DEPOT from DIS_INVOICE_TK_COLLECTION where POSITION=1 and FROMSTORE_ID =:P157_DEPOT and SEND_VOUCHER_NO in (:P157_SEND_VOUCHER_NO) but i can't...

– Md Morshed Alam
Nov 20 '18 at 10:32

add a comment |

-1

i want use in operator in oracle apex classic report for sorting details data and also multiple details data. so how can i do that by sql query?
please help me.

SELECT fr_st_invoiceno,
 sales_type,
 cust_id,
 sia_id,
 coll_amount,
 remarks,
 cash_bank,
 bank_name,
 check_no,
 update_id,
 updatedate,
 slno,
 invoice_type,
 trcode,
 send_voucher_no,
 send_voucher_no_depot
FROM dis_invoice_tk_collection
WHERE position = 1
 AND fromstore_id =:p157_depot
 AND send_voucher_no IN (:p157_send_voucher_no)

Thanks & best regard.
morshed.

edited Nov 20 '18 at 17:51

Littlefoot

23.8k71534

asked Nov 14 '18 at 10:55

Md Morshed Alam

214

i want use in operator in oracle apex classic report for sorting details data and also multiple details data. so how can i do that by sql query?
please help me.

SELECT fr_st_invoiceno,
 sales_type,
 cust_id,
 sia_id,
 coll_amount,
 remarks,
 cash_bank,
 bank_name,
 check_no,
 update_id,
 updatedate,
 slno,
 invoice_type,
 trcode,
 send_voucher_no,
 send_voucher_no_depot
FROM dis_invoice_tk_collection
WHERE position = 1
 AND fromstore_id =:p157_depot
 AND send_voucher_no IN (:p157_send_voucher_no)

Thanks & best regard.
morshed.

oracle oracle-apex oracle-apex-5.1

edited Nov 20 '18 at 17:51

Littlefoot

23.8k71534

asked Nov 14 '18 at 10:55

Md Morshed Alam

214

edited Nov 20 '18 at 17:51

Littlefoot

23.8k71534

asked Nov 14 '18 at 10:55

Md Morshed Alam

214

edited Nov 20 '18 at 17:51

Littlefoot

23.8k71534

edited Nov 20 '18 at 17:51

Littlefoot

23.8k71534

edited Nov 20 '18 at 17:51

Littlefoot

23.8k71534

asked Nov 14 '18 at 10:55

Md Morshed Alam

214

asked Nov 14 '18 at 10:55

Md Morshed Alam

214

asked Nov 14 '18 at 10:55

Md Morshed Alam

214

I'm afraid I don't understand the question. What problems do you have when using IN? It works in a classic report as anywhere else. If you want to sort data, user ORDER BY (what does IN have to do with it?). What is "multiple details data"? Could you provide some more info, create a test case, attach a screenshot ... anything?

– Littlefoot
Nov 14 '18 at 20:19

i want to use this code in classic report: select FR_ST_INVOICENO, SALES_TYPE, CUST_ID, SIA_ID, COLL_AMOUNT, REMARKS, CASH_BANK, BANK_NAME, CHECK_NO, UPDATE_ID, UPDATEDATE, SLNO, INVOICE_TYPE, TRCODE, SEND_VOUCHER_NO, SEND_VOUCHER_NO_DEPOT from DIS_INVOICE_TK_COLLECTION where POSITION=1 and FROMSTORE_ID =:P157_DEPOT and SEND_VOUCHER_NO in (:P157_SEND_VOUCHER_NO) but i can't...

– Md Morshed Alam
Nov 20 '18 at 10:32

add a comment |

I'm afraid I don't understand the question. What problems do you have when using IN? It works in a classic report as anywhere else. If you want to sort data, user ORDER BY (what does IN have to do with it?). What is "multiple details data"? Could you provide some more info, create a test case, attach a screenshot ... anything?

– Littlefoot
Nov 14 '18 at 20:19

i want to use this code in classic report: select FR_ST_INVOICENO, SALES_TYPE, CUST_ID, SIA_ID, COLL_AMOUNT, REMARKS, CASH_BANK, BANK_NAME, CHECK_NO, UPDATE_ID, UPDATEDATE, SLNO, INVOICE_TYPE, TRCODE, SEND_VOUCHER_NO, SEND_VOUCHER_NO_DEPOT from DIS_INVOICE_TK_COLLECTION where POSITION=1 and FROMSTORE_ID =:P157_DEPOT and SEND_VOUCHER_NO in (:P157_SEND_VOUCHER_NO) but i can't...

– Md Morshed Alam
Nov 20 '18 at 10:32

I'm afraid I don't understand the question. What problems do you have when using IN? It works in a classic report as anywhere else. If you want to sort data, user ORDER BY (what does IN have to do with it?). What is "multiple details data"? Could you provide some more info, create a test case, attach a screenshot ... anything?

– Littlefoot
Nov 14 '18 at 20:19

i want to use this code in classic report: select FR_ST_INVOICENO, SALES_TYPE, CUST_ID, SIA_ID, COLL_AMOUNT, REMARKS, CASH_BANK, BANK_NAME, CHECK_NO, UPDATE_ID, UPDATEDATE, SLNO, INVOICE_TYPE, TRCODE, SEND_VOUCHER_NO, SEND_VOUCHER_NO_DEPOT from DIS_INVOICE_TK_COLLECTION where POSITION=1 and FROMSTORE_ID =:P157_DEPOT and SEND_VOUCHER_NO in (:P157_SEND_VOUCHER_NO) but i can't...

– Md Morshed Alam
Nov 20 '18 at 10:32

add a comment |

2 Answers
2

active

oldest

votes

You have to split a comma-separated values into rows, such as

and send_voucher in
 (select regexp_substr(:P157_SEND_VOUCHER_NO, '[^,]+', 1, level)
 from dual
 connect by level <= regexp_count(:P157_SEND_VOUCHER_NO, ',') + 1
 )

presuming that P157_SEND_VOUCHER_NO looks like 10,20,30.

Don't forget to put P157_SEND_VOUCHER_NO item into "page items to submit" property.

answered Nov 20 '18 at 18:01

Littlefoot

23.8k71534

yeah good achievement for me. thanks a lot littlefoot.

– Md Morshed Alam
Nov 22 '18 at 9:09

add a comment |

AND instr(','||:p157_send_voucher_no||',', ','||send_voucher_no||',') > 0

answered Nov 26 '18 at 7:15

Jeffrey Kemp

48.4k1189134

add a comment |

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53298551%2fhow-to-use-in-operator-in-oracle-apex-classic-report%23new-answer', 'question_page');

);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

You have to split a comma-separated values into rows, such as

and send_voucher in
 (select regexp_substr(:P157_SEND_VOUCHER_NO, '[^,]+', 1, level)
 from dual
 connect by level <= regexp_count(:P157_SEND_VOUCHER_NO, ',') + 1
 )

presuming that P157_SEND_VOUCHER_NO looks like 10,20,30.

Don't forget to put P157_SEND_VOUCHER_NO item into "page items to submit" property.

answered Nov 20 '18 at 18:01

Littlefoot

23.8k71534

yeah good achievement for me. thanks a lot littlefoot.

– Md Morshed Alam
Nov 22 '18 at 9:09

add a comment |

You have to split a comma-separated values into rows, such as

and send_voucher in
 (select regexp_substr(:P157_SEND_VOUCHER_NO, '[^,]+', 1, level)
 from dual
 connect by level <= regexp_count(:P157_SEND_VOUCHER_NO, ',') + 1
 )

presuming that P157_SEND_VOUCHER_NO looks like 10,20,30.

Don't forget to put P157_SEND_VOUCHER_NO item into "page items to submit" property.

answered Nov 20 '18 at 18:01

Littlefoot

23.8k71534

yeah good achievement for me. thanks a lot littlefoot.

– Md Morshed Alam
Nov 22 '18 at 9:09

add a comment |

You have to split a comma-separated values into rows, such as

and send_voucher in
 (select regexp_substr(:P157_SEND_VOUCHER_NO, '[^,]+', 1, level)
 from dual
 connect by level <= regexp_count(:P157_SEND_VOUCHER_NO, ',') + 1
 )

presuming that P157_SEND_VOUCHER_NO looks like 10,20,30.

Don't forget to put P157_SEND_VOUCHER_NO item into "page items to submit" property.

answered Nov 20 '18 at 18:01

Littlefoot

23.8k71534

You have to split a comma-separated values into rows, such as

and send_voucher in
 (select regexp_substr(:P157_SEND_VOUCHER_NO, '[^,]+', 1, level)
 from dual
 connect by level <= regexp_count(:P157_SEND_VOUCHER_NO, ',') + 1
 )

presuming that P157_SEND_VOUCHER_NO looks like 10,20,30.

Don't forget to put P157_SEND_VOUCHER_NO item into "page items to submit" property.

answered Nov 20 '18 at 18:01

Littlefoot

23.8k71534

answered Nov 20 '18 at 18:01

Littlefoot

23.8k71534

answered Nov 20 '18 at 18:01

Littlefoot

23.8k71534

answered Nov 20 '18 at 18:01

Littlefoot

23.8k71534

yeah good achievement for me. thanks a lot littlefoot.

– Md Morshed Alam
Nov 22 '18 at 9:09

add a comment |

yeah good achievement for me. thanks a lot littlefoot.

– Md Morshed Alam
Nov 22 '18 at 9:09

yeah good achievement for me. thanks a lot littlefoot.

– Md Morshed Alam
Nov 22 '18 at 9:09

add a comment |

AND instr(','||:p157_send_voucher_no||',', ','||send_voucher_no||',') > 0

answered Nov 26 '18 at 7:15

Jeffrey Kemp

48.4k1189134

add a comment |

AND instr(','||:p157_send_voucher_no||',', ','||send_voucher_no||',') > 0

answered Nov 26 '18 at 7:15

Jeffrey Kemp

48.4k1189134

add a comment |

AND instr(','||:p157_send_voucher_no||',', ','||send_voucher_no||',') > 0

answered Nov 26 '18 at 7:15

Jeffrey Kemp

48.4k1189134

AND instr(','||:p157_send_voucher_no||',', ','||send_voucher_no||',') > 0

answered Nov 26 '18 at 7:15

Jeffrey Kemp

48.4k1189134

answered Nov 26 '18 at 7:15

Jeffrey Kemp

48.4k1189134

answered Nov 26 '18 at 7:15

Jeffrey Kemp

48.4k1189134

answered Nov 26 '18 at 7:15

Jeffrey Kemp

48.4k1189134

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Pfthb