Skip to Main Content
Feature Request FR-1868
Product Area Application Builder
Status CLOSED

12 Voters

Customize Single Row View

subramav Public · Aug 29 2021

Idea Summary
Ability to change the layout of Single Row View “form” behind Interactive Report/Grid

Use Case
When we have large number of fields in an IR/IG, we often provide an alternative UI to show all the fields (and group the related fields nicely) in one page using a modal window. But this doesn't give us record navigations and all the customizations that are configured on the IG. Being able to manipulate the layout of the default single row view would be extremely useful.

Preferred Solution (Optional)
How would you implement this idea? If you are not sure, leave blank.

We reviewed this idea carefully, and while it was interesting, we concluded that it is unlikely to make its way into APEX in the foreseeable future.

Known Duplicates

Known duplicates

FR-1924
FR-1924 Improve the presentation and ergonomics possibilities for the Single Row View of IG
FR-3619
FR-3619 Make Single row view in IG editable

Comments

Comments

  • john.snyders APEX Team OP 3.9 years ago

    In IG some customization is possible with JavaScript. For example putting to fields on the same line.

    One possibility is to make the existing capabilities declarative.

  • subramav OP 3.7 years ago

    Thanks John!

    Where can we get help on customizing single row view using JavaScript while we wait for declarative capabilities?

  • john.snyders APEX Team OP 3.3 years ago

    https://docs.oracle.com/en/database/oracle/application-express/21.2/aexjs/recordView.html#fields

  • vincent morneau Admin OP 1.9 years ago

    Hi @subramav 

    The team discussed this idea today. We think that for extended customizations, it might make more sense to create a dedicated page for that row view, that way you can use the full power of page designer to display the data in it's full glory.

    Single Row View is designed to be a quick glimpse at the data.

  • subramav OP 1.9 years ago

    Hi Vencent,
    That's an excellent idea. Wouldn't it be nice to have a declarative way to embed that dedicated page you mentioned?

    Current approach is designed to provide a quick glimpse at the data, but to whom? If the items are not placed in a meaningful way to the business users, IT people or anyone else, what is the use?

  • vincent morneau Admin OP 1.9 years ago

    The single row view is not designed to be customizable, but APEX offers much more comprehensive tools to create custom form pages. Single row view is designed to be a quick look at the data, without page redirect, so it's faster to render, but it comes at the cost of no customization.

    In your case, given your requirements, it doesn't appear like single row view is a good fit.

  • pierre-antoine.lebeault OP 1.4 years ago

    Hi @vincent morneau ,

    OK for a dedicated page to view the row, but do you know how to get the row number / selected rows number () ?

    Thank you.

    PA

  • karel ekema OP 7 months ago

    @pierre-antoine.lebeault : you can get the row number using:

    let currentRowNumber = model.indexOf(record) + 1;
  • karel ekema OP 6 months ago

    For large number of fields, in case a bit of custom code is ok for you, alternatively you can instantiate a recordView in a separate region with the same model and field configuration as the IG. Using region template as drawer, you get (with added Collapse/Expand All button):

    It makes use of the power of view/model separation which APEX offers here: I did a proof of concept, and it works perfectly. There are also options to make use of columns in the layout.

  • joachim.forster OP 5 months ago

    Hi Karel, 

    thank you for your work / proof of concept  ! 
    please go on with your investigations 🙏🏽
    maybe help the apex team to  provide a better customizeable single row view out of the box.
    even if it cannot be made perfect, some enhancements would be great, version by version
    it seems there is not any declarative customization available currently ?!? 
    even enable/disable ig single row view ?

    Thank you.
    Joachim