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

[swathi52]

Thanks Lucas, i got the point.

I have one more doubt, Is it possible to put dot walking in where clause on tables?

[manjusha]

Hi,

you can not use dot wlking in where clause in view table.

please refer below link.

https://community.servicenow.com/community?id=community_question&sys_id=f7c0d3a9dbdcdbc01dcaf3231f961945

Mark this answer as correct if helps

Regrds,

Manjusha Bangle

[Daniel Oderbolz]

Hello!

I know this is an old thread, but still. I keep reading that the order field has something to do with performance.

(Also mentioned here by @Daniel Draes : DATABASE VIEWS* for beginners. - ServiceNow Community)

However, in a pure SQL Statement, the order in which you add tables to the FROM Statement has no impact on performance. However, I found that sometimes, the Query generated is just wrong when the Order is "wrong". 
So my feeling is that the Query Generator is not robust enough and needs some help in the form of the Order to construct the query. 

Honestly, I think the Database View feature could use some more documentation and more examples, especially when it comes to order and the Where Clauses.

Just my 2 cents.