Home/Vinish/Best Answers
  1. Asked:

    How to refresh items on dialog closed?

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    Okay. Then you can notice on the parent page, which is based on a form, there you will find a process at Before Header level, which executes on page load. So to refresh the form, you will have to reload the parent page on the close dialog. To do this, remove the True action you created to refresh thRead more

    Okay. Then you can notice on the parent page, which is based on a form, there you will find a process at Before Header level, which executes on page load.

    So to refresh the form, you will have to reload the parent page on the close dialog.

    To do this, remove the True action you created to refresh the items and create a new True action to execute JavaScript code, and add the following code in it:

    location.reload();

    Now after the dialog closes, the page will reload to display new values.

    Please let me know for any further questions.

    See less
    • 1
  2. Asked:

    Using Region with Type (Help Text) in Oracle Apex

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    The type Help Text region shows all the help text in one place (in this region). For example, you have 10 page items on your page, and you have specified the help text for every or a few page items. Below is how you can specify the help text for page items: Click on the page item, and in the propertRead more

    The type Help Text region shows all the help text in one place (in this region).

    For example, you have 10 page items on your page, and you have specified the help text for every or a few page items. Below is how you can specify the help text for page items:

    Click on the page item, and in the property palette > Help section, you will find the property Help Text. Specify the help text for that item. Below is the screenshot:

    Page item help text in Oracle Apex.

    When you run the page, you will see a question mark icon right-side of the page item. And when you click the help text will appear. Below is the screenshot:

    Showing help text in Oracle Apex.

    Now suppose you have specified the help text for almost every item on the page. Then the Help Text Region helps to display all help text in that region.

    The better way to show the help text region is by using the region display selector. Because if the help text region always displays, it will not look good.

    To display it using the region display selector, follow these steps:

    Create a region and set its type to region display selector. Set its position to Breadcrumb Bar and Template to blank with attributes.

    Then click on the Attribute node of the display selector and turn-off the include show all property.

    Now create a region and set its type to Help Text. Set its Region Display Selector property button on.

    Click on your other region, which has the page items, and set its Region Display Selector property button on.

    Now save the changes and run the page. You will get the output as below:

    Help text region output in Oracle Apex.

    Help Page:

    Creating Help tab in Oracle Apex.

    Please let me know if you still have any questions.

    See less
    • 0
  3. Asked:

    How to set value from Badge List to IR

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    Then just follow the first example. It will work. Below I am briefing again: javascript:runIR('#STATUS#'); JavaScript function: function runIR (pstatus) { apex.item("P2_STATUS").setValue(pstatus); apex.region("IRemp").refresh(); } If you still not able to do it, then create a demo app and let me knoRead more

    Then just follow the first example. It will work. Below I am briefing again:

    javascript:runIR('#STATUS#');

    JavaScript function:

    function runIR (pstatus) {
  apex.item("P2_STATUS").setValue(pstatus);
  apex.region("IRemp").refresh();
}

    If you still not able to do it, then create a demo app and let me know.

    See less
    • 1
  4. Asked:

    How to refresh a page after calling and closing a modal page in Oracle Apex

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    To refresh the page 'A' on close of the dialog page, follow these steps: On page 'A,' create a dynamic action as follows: Name: daRefreshIG Event: Dialog Closed Selection Type: Region Region: Report_1 (your IG region) True Action Action: Refresh Selection Type: Region Region: Report_1 (Your IG regioRead more

    To refresh the page ‘A’ on close of the dialog page, follow these steps:

    On page ‘A,’ create a dynamic action as follows:

    Name: daRefreshIG
    Event: Dialog Closed
    Selection Type: Region
    Region: Report_1 (your IG region)

    True Action

    Action: Refresh
    Selection Type: Region
    Region: Report_1 (Your IG region)

    If the above dynamic action does not work, which happens in some cases, then remove the above one and create another DA as follows:

    Name: da_selectjs
    Event: Dialog Closed
    Selection Type: JavaScript Expression
    JavaScript Expression: window

    True Action

    Action: Refresh
    Selection Type: Region
    Region: Report_1 (your IG region)

    It will surely work. Please try and let me know if any issues.

    See less
    • 1
  5. Asked:

    Barcode Generator in Oracle apex

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    Add the following Google barcode font code into the HTML header section: <link href="https://fonts.googleapis.com/css2?family=Libre+Barcode+128+Text&display=swap" rel="stylesheet"> Below is the screenshot: The font I used in the above image is different, don't use that. For your purpose foRead more

    Add the following Google barcode font code into the HTML header section:

    <link href="https://fonts.googleapis.com/css2?family=Libre+Barcode+128+Text&display=swap" rel="stylesheet">

    Below is the screenshot:

    Adding Google font in Oracle Apex.

    The font I used in the above image is different, don’t use that. For your purpose font, Libre Barcode 128 Text is ok.

     

    Now to make the product id column in the report as the barcode add the following code in the HTML expression section of the product id column:

    <span style="font-size: 34px;font-family: 'Libre Barcode 128 Text', cursive;">#PRODUCT_ID#</span>

    Below is the screenshot:

    HTML expression.

    Output:

    Oracle Apex: Display barcode font in Interactive Report.

     

    You can use more types of barcodes. Check this link Google font barcode.

    See less
    • 1
  6. Asked:

    loadjava utility to load multiple dependent jar files

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    Hi Abhi, I am not a Java guy, but it seems that you are missing the class in your project classpath. This error is something like class not found; that is why it cannot instantiate the class. You have to find it how you can add this class to your classpath or in your project.

    Hi Abhi,

    I am not a Java guy, but it seems that you are missing the class in your project classpath. This error is something like class not found; that is why it cannot instantiate the class.

    You have to find it how you can add this class to your classpath or in your project.

    See less
    • 0
  7. Asked:

    How to accept JSON arrays of objects on ORDS

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    You can accept JSON array inputs via type object using PL/SQL in Oracle ORDS. Below is an example: Create a table to store the data: CREATE TABLE APP_USERS ( NAME VARCHAR2(30), USERTYPE VARCHAR2(10)); Create a DB package with TYPE declaration: CREATE OR REPLACE PACKAGE accept_json AS TYPE vc_arr ISRead more

    You can accept JSON array inputs via type object using PL/SQL in Oracle ORDS. Below is an example:

    Create a table to store the data:

    CREATE TABLE APP_USERS (
NAME VARCHAR2(30),
USERTYPE VARCHAR2(10));

    Create a DB package with TYPE declaration:

    CREATE OR REPLACE PACKAGE accept_json AS
    TYPE vc_arr IS
        TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
    PROCEDURE ins_user (
        u_name IN vc_arr
    );
 
END accept_json;
 
/
 
CREATE OR REPLACE PACKAGE BODY accept_json AS
 
    PROCEDURE ins_user (
        u_name IN vc_arr
    ) AS
    BEGIN
        FOR i IN 1..u_name.COUNT LOOP 
         INSERT INTO app_users (
            name,
            usertype
         ) VALUES (
            u_name(i),
            'ENDUSER'
          );
 
        END LOOP;
 
        COMMIT;
    END ins_user;
 
END accept_json;

    Now enable the above DB package for ORDS:

    BEGIN
    ORDS.ENABLE_OBJECT(p_enabled => TRUE,
                       p_schema => 'YOURSCHEMA',
                       p_object => 'ACCEPT_JSON',
                       p_object_type => 'PACKAGE',
                       p_object_alias => 'ACCEPT_JSON',
                       p_auto_rest_auth => FALSE);
    COMMIT;
END;

    Calling the package:

    curl --request POST \
  --url http://localhost:8080/ords/hr/accept_json/INS_USER \
  --header 'content-type: application/json' \
  --data '{
	"u_name" : [ "adam", "susan"]
}'

    Please try and let me know if any issues.

    See less
    • 1
  8. Asked:

    Change Column color in nested classic report

    Vinish

    Vinish

    View Profile
    Vinish Legendary
    This answer was edited.

    It should change the background color of headings (thead element) because of the following CSS: #report_child thead { background-color: black; } To change the heading text color try this: #report_parent thead a{ color: white;} Please let me know if it is not working.

    It should change the background color of headings (thead element) because of the following CSS:

    #report_child thead {
  background-color: black;
}

    To change the heading text color try this:

    #report_parent thead a{
      color: white;
    }

    Coloring classic report in Oracle Apex.

    Please let me know if it is not working.

    See less
    • 1
  9. Asked:

    Loop Through Interactive Grid Records And Insert Through Cursor

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    The interactive grid is based on the table, so you can insert the records into the table then refresh the grid to display the records. If you need to insert the records using JavaScript, check the following post: Insert records into Interactive Grid using JavaScript

    The interactive grid is based on the table, so you can insert the records into the table then refresh the grid to display the records.

    If you need to insert the records using JavaScript, check the following post:

    Insert records into Interactive Grid using JavaScript

    See less
    • 0
  10. Asked:

    IRIS Scan in oracle apex integration

    Vinish

    Vinish

    View Profile
    Vinish Legendary

    IRIS scanner is not an input or output device for a computer, so it is not like a plug and play device. It is installed separately to give access to a particular area/company to the registered people or employees. It is a biometric machine that transfers the data to the computer on-demand or on a spRead more

    IRIS scanner is not an input or output device for a computer, so it is not like a plug and play device.

    It is installed separately to give access to a particular area/company to the registered people or employees.

    It is a biometric machine that transfers the data to the computer on-demand or on a specific scheduler setting.

    You have to coordinate with the IRIS machine supplier to access the data or import it into the Oracle database.

    See less
    • 1