Dears, I found this article about APEX and Server side conditions. I have a report from a table which doesn't contain username only the referring ID. So when I display the report, I'd like to present username in the column of ID. So I tried "Rows returned:" and added this SQL script: SELECT NAME FROM PEOPLE WHERE ID = :PEOPLEID; :PEOPLEID <== this is the row in the report which I want to change to username My question is how to refer to a row in a report. Thank you.
Discy Latest Questions
Hi! I use LoV item with shuttle. I tried to create save process for shuttle item, but when I move value to right side I got error: Error computing item source value for page item P8_SHUTTLE. ORA-01722: invalid number When I click OK button value is inserted. When I move values from right to left side there is no error. Save process: DECLARE vTAB APEX_APPLICATION_GLOBAL.VC_ARR2; BEGIN vTAB := apex_util.string_to_table (:P8_SHUTTLE); DELETE FROM role_privileges WHERE fk_role_id = :P8_ROLES; FOR i IN 1 .. vTAB.count LOOP INSERT INTO role_privileges (fk_privilege_id, fk_role_id) VALUES (vTAB(i), :P8_ROLES); END LOOP; END;
I am using cards to display diagrams. When page is load or reload diagram is displayed well, but when I use Faceted Search cards region is refreshed(without reload) and diagram doesn't fit in card. On page load or after reload page: After using Faceted Search and region refresh: Cards region query select ID, TITLE as CARD_TITLE, DIAGRAM, apex_page.get_url ( p_page => 21, p_items => 'P21_ID', p_values => "ID") as CARD_LINK, null as CARD_INITIALS, null as CARD_SUBTITLE, null as CARD_SUBTEXT, '<!DOCTYPE html> <html> <head> <meta charset="UTF-8" /> <!-- viewer --> ...
Hi! I use List Of Value with shuttle, to assign user roles. I want to display roles hierarchically, for instance, when user who is logged in, has an Admin role this user should be able to see all roles and assignee them to selected user from LOV item. When user have Moderator role, then should be able to see users who are the moderators and all other who are below this role. And user should be unable to see roles above own role in shuttle. Thanks in advance