What is the order field on Database views? what it does? how it works?

[swathi52]

Hi,

What is the order field on Database views? what it does? how it works?

Thanks,

swathi

[Lucas Vieites]

Hi swathigutnuku,

Which database view are you referring to? Note that the fields in database views come from the tables that were used to create the view. You should check the source tables to find where that "order" field comes from.

I hope I was of help.

Kind regards,

Lucas

[swathi52]

Hi Lucas,

Let me clear my question here.

Let us say i have created a view named 'X' joining tables 'A' and 'B'.

Now when we open this view , in the related list 'view tables', we can personalize to get column 'order'.

what does this refer?

Thanks

swathi

[Apurva Malewad1]

Hi,

Its basically used for preventing performance issue.Like we have multiple view tables for database view and you have written where clause as needed,It will give the result as per the order defined for that table to avoid ambiguity for execution.

Hope this will help you.

Please mark my answer as correct/helpful if it helps you to find the solution.

Thanks and Regards,

Apurva Malewadikar

www.DXSherpa.com

[Lucas Vieites · Accepted solution]

Aha, I understand what you mean. The Order is used when JOINing the tables for the view; joined tables are evaluated from left to right. See the documentation topic Add a table to the database view for more information.

Kind regards,

Lucas Vieites