Hi,
I am new in apex and I have problem.Version: Apex 5.0.1
I created page item: P101_BRANCH
Type: Select List
List of values: Shared Components --- BRACH_VER1
And it is working ok.
Now I want add dynamic default value for this filter.
Default value depends from user and his branch.
I have table with user and branch, sql query like:
select BRANCH from C_BRANCH_USERS
where UPPER(LOGIN) = UPPER(:APP_USER.);
In table for each user I have only one branch.
Next, when user log in and run report he want see (default) only their branch (later of course he can choose others branch).
How can set result from this query to default value for my filter?
What about default in page item options? I see static value and pl/sql. Why I can't use only sql query?