Skip to main content
Solved

Table Relations using Greater than or Less than Operator


kerry_bespoke
Contributor
Forum|alt.badge.img

I am setting up a table relation where the tables join based on a date range (see screenshot below)

In setting this up in TimeXtender, I noticed that I can only set this up on the lookup field and not as the default relation between the tables.

Does anyone know of a way this can be setup on the default table relation? Or can we had as an enhancement for TX?

(NOTE: I have edited the table names and columns for this post)

 

Best answer by Thomas Lind

Hi Kerry

No, it is not possible to set this as table relations.

It would be a new feature if it needed to do this.

That said, I have a guide regarding joins using greater and less than operators.

https://legacysupport.timextender.com/hc/en-us/articles/115005972746-Improve-execution-times-by-splitting-exchange-rates-out-on-dates

The guide is about exchange rates, but it can be used on all tables where a date range is necessary to get the data.

View original
Did this topic help you find an answer to your question?

4 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • Answer
  • March 30, 2023

Hi Kerry

No, it is not possible to set this as table relations.

It would be a new feature if it needed to do this.

That said, I have a guide regarding joins using greater and less than operators.

https://legacysupport.timextender.com/hc/en-us/articles/115005972746-Improve-execution-times-by-splitting-exchange-rates-out-on-dates

The guide is about exchange rates, but it can be used on all tables where a date range is necessary to get the data.


kerry_bespoke
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • 23 replies
  • March 30, 2023

Thank you for sending this over, I think this could work for what I need. I currently have something similar already setup but for MTD Customer values so can extend this.

Since I am working with an on premise (legacy) version of TX, if this enhancement ever was added, we would need to migrate to the new Cloud based TX. Is that right?


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @kerry_bespoke! Hope you are doing well! 😊 Yes if the feature were to be added, it would most likely be to the new cloud-based version of TimeXtender and not the legacy version. We plan on releasing a migration tool to help migrate projects from the legacy version to the new cloud-based version of TimeXtender. Please feel free to submit an idea for the table relations feature in the ideas section.


kerry_bespoke
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • 23 replies
  • April 10, 2023

Hi @Christian Hauggaard ! I am thanks, hope you are as well.

I will add my comments from this post to the ideas section to see if we can add this as a new feature. 

A migration tool sounds exciting! I will look out for that release (:


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