---
title: "Discussion on \"APEX_REGION.OPEN_QUERY_CONTEXT and Row Counts\" | Hashnode"
description: "Discussion on \"APEX_REGION.OPEN_QUERY_CONTEXT and Row Counts\". I created an Oracle APEX Plugin recently, with the amazing title of Pretius x-y of Lazy z Pagination. I created this plugin because Interactive Reports, with x-y of z pagination, were taking a ridiculously long amount of time to not only fetch the re..."
url: "https://hashnode.com/posts/apexregionopenquerycontext-and-row-counts/67516f4cc6ccf33a61c2ac8b"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [APEX\_REGION.OPEN\_QUERY\_CONTEXT and Row Counts](https://mattmulvaney.hashnode.dev/apexregionopenquerycontext-and-row-counts?utm_source=hashnode&utm_medium=feed)

I created an Oracle APEX Plugin recently, with the amazing title of Pretius x-y of Lazy z Pagination. I created this plugin because Interactive Reports, with x-y of z pagination, were taking a ridiculously long amount of time to not only fetch the re...

Dec 5, 2024 · 4 min read · mattmulvaney.hashnode.dev  
Read the article

-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#oci](https://hashnode.com/tag/oci)
-   [#oracle](https://hashnode.com/tag/oracle)
-   [#oracle-apex](https://hashnode.com/tag/oracle-apex)

## Written by

[Matt Mulvaney](https://hashnode.com/@lufcmattylad)

@lufcmattylad

  
[View profile](https://hashnode.com/@lufcmattylad)

I do fancy stuff with Oracle APEX #orclapex

With around 20 years on the job, Matt is one of the most experienced software developers at Pretius. He likes meeting new people, traveling to conferences, and working on different projects. He’s also a big sports fan (regularly watches Leeds United, Formula 1, and boxing), and not just as a spectator – he often starts his days on a mountain bike, to tune his mind.

## Responses 2

Markdown supported · ⌘↵ to post

[Jon Dixon](https://hashnode.com/@orclapex)

[Dec 13, 2024](https://hashnode.com/posts/apexregionopenquerycontext-and-row-counts/67516f4cc6ccf33a61c2ac8b/comment/675bb107e2dcb826739cfc03)

Nice post. I still find myself using APEX\_JSON for small stuff. Do as I say, not as I do!

[W Koessler](https://hashnode.com/@wok)

[Dec 6, 2024](https://hashnode.com/posts/apexregionopenquerycontext-and-row-counts/67516f4cc6ccf33a61c2ac8b/comment/6752d5da3b9dfa82896ede61)

Hi Matt, thanks a lot for another useful tip! I made a plugin which counts the results of IR and IG Regions that are organized in tabs. I count using Lv\_result\_t := apex\_plugin\_util.get\_data … And then lv\_result\_t(1).count Works Perfect. Kind regards W
