Skip to main content
Solved

Views creation Generation order and priority

H
Sidekick
Forum|alt.badge.img+6

Hi, 

I've defined a view vw_tour_resource. 

Some columns of this view I would reuse in another view vw_tour_driver.

When testing the query itself for the view vw_tour_driver, then in works fine. 

But when creating a new version, then I get an error 

I think the root cause of this is that the view vw_tour_driver is created first before the (existing) view vw_tour_resource as it is alphabetically earlier.

I tried to influence it with Generation order no and Priority, but that seems not working. Tried with giving higher or lower priority, higher or lower Generation order no, but that seems not helping.

How to fix this issue? 

 

Best answer by Mark Jongeling

Hi HJ,

The Generation order no is the order in which code is generated. In this case you have changed the Generation order no of the Functionality. That will not give you the desired result as changing this value only changes its generation position in the Generate definitions screen. 

However, in Data model → Tables you can change the Generation order no of the view and that will result in the view being created earlier or later than others. Having the vw_tour_resource on order no 100 and vw_tour_driver on order no 105 will do the trick. 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Mark Jongeling
  • Administrator
  • 3945 replies
  • Answer
  • April 22, 2021

Hi HJ,

The Generation order no is the order in which code is generated. In this case you have changed the Generation order no of the Functionality. That will not give you the desired result as changing this value only changes its generation position in the Generate definitions screen. 

However, in Data model → Tables you can change the Generation order no of the view and that will result in the view being created earlier or later than others. Having the vw_tour_resource on order no 100 and vw_tour_driver on order no 105 will do the trick. 

"Wake me up before you low-code" | On holiday 06-02 till 27-06
Harold
Marius Korff
2 people like this
  • Harold
    Harold
  • Marius Korff
    Marius Korff
H
Sidekick
Forum|alt.badge.img+6

Thanks for the quick reply!

Mark Jongeling
1 person likes this
  • Mark Jongeling
    Mark Jongeling
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings