• Replies 10 replies
  • Subscribers 0 subscribers
  • Views 33 views
  • Users 0 members are here
Options
3sides - Social sharing widget
Related

How to get data of all columns of an isheet item?

Ha Nguyen Danh
27231

HighQ Api provide an api to get an  iSheet item by item id, but this will get the iSheet item by an iSheet View (use the Default View if the isheet view id not specified).

With this one, I can only get all data (all column data) of an isheet item if I have an iSheet View that is configured to have all columns of the iSheet.

Is there a way that I can get the iSheet item with all of it column data without preparing a iSheet View with all the columns?

 

 

Regards,

Ha Nguyen

Parents

  • Hi Ha Nguyen Danh, we use an in-house developed method, however, here is a simple way you can achieve this for your environment:

    1. Decide on a prefix that makes sense to your group. As an example, we want views that start with [SYS.USE
    to be hidden from users
    • (re)name the views you want to hide to include this prefix
    • Add the following CSS into the Custom CSS entry (System Admin / Customize module)
    a#sheetViewQuickDropLinkTxt + ul.dropdown-menu > li > a[title^='[SYS.USE]'] {
    display:none;
}

    See the attached screenshot for example of this.

    This will "hide" the view (selection) from everyone, though you can still navigate to the views if required. If this is annoying whilst you are developing things, you could modify the CSS to allow you to quickly toggle a top-level class to enable/disable certain features, e.g.

    Modified CSS:

    body:not(.ce-disable) a#sheetViewQuickDropLinkTxt + ul.dropdown-menu > li > a[title^='[SYS.USE]'] {
    display:none;
}

    Console command:

    $j("body").toggleClass("ce-disable")

    Andrew

    ]]>
Reply

  • Hi Ha Nguyen Danh, we use an in-house developed method, however, here is a simple way you can achieve this for your environment:

    1. Decide on a prefix that makes sense to your group. As an example, we want views that start with [SYS.USE
    to be hidden from users
    • (re)name the views you want to hide to include this prefix
    • Add the following CSS into the Custom CSS entry (System Admin / Customize module)
    a#sheetViewQuickDropLinkTxt + ul.dropdown-menu > li > a[title^='[SYS.USE]'] {
    display:none;
}

    See the attached screenshot for example of this.

    This will "hide" the view (selection) from everyone, though you can still navigate to the views if required. If this is annoying whilst you are developing things, you could modify the CSS to allow you to quickly toggle a top-level class to enable/disable certain features, e.g.

    Modified CSS:

    body:not(.ce-disable) a#sheetViewQuickDropLinkTxt + ul.dropdown-menu > li > a[title^='[SYS.USE]'] {
    display:none;
}

    Console command:

    $j("body").toggleClass("ce-disable")

    Andrew

    ]]>
Children
No Data