You can translate the question and the replies:

order of fields in Information self service tool

Hi Team, I'm facing issue with Information self service tool. When i query a view in isst, it displays the fields in alphabetical order and not as order in view. for example, i have a derived view dvtest which has fields a, d, c, b in same order. when i query the same view in self service tool, it displays the results in order a, b, c, d . Please help me to get the results in the order as in admin tool. Thanks, raghu
user
14-10-2019 03:26:01 -0400

3 Answers

Hi, I faced similar scenario when executing the view from Information Self-Service Tool without refreshing the view. Hence, I would verify first if the view object is refreshed in the Information Self-Service Tool (i.e.) changes done in Virtual DataPort server would need to be refreshed in Information Self-Service Tool to take effect. If executed without refresh it would show inconsistent results like the one you had. So, I would refresh the derived view "dvtest" by simply clicking the view in the search tree of the [Views](https://community.denodo.com/docs/html/browse/6.0/vdp/isst/databases/views/views#views) tab and execute the view again. Hope this helps!
Denodo Team
15-10-2019 07:39:51 -0400
Hi, I did tried for refreshing the view. Even after that, i'm facing same issue. *I would refresh the derived view “dvtest” by simply clicking the view in the search tree of the Views tab and execute the view again.*
user
16-10-2019 05:17:12 -0400
Hi, In general, Denodo customer can access the support site with a valid Support user and create new Requests. With that said, I would suggest you to raise a support request in the [Denodo Support Site](https://support.denodo.com/) so that Denodo support team will review and analyze it internally. Hope this helps!
Denodo Team
24-10-2019 08:01:54 -0400
You must sign in to add an answer. If you do not have an account, you can register here