Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Is there a way to create a where-based join in Designer Stud...


Ben Maxwell

Recommended Posts

Is there a way to create a where-based join in Designer Studio 8207.27

 

Joining Fiscal_YR to FISCALYEAR

 

 

 

Issue with actual and usage type

 

 

In App Studio I was able to create a where-based join without having the need to modify the master files. Is there a similar option that I havent stumbled up yet

Link to comment
Share on other sites

The challenge here is one table is pointed to view of my GL data, and the other table is a table which is tied into a Fiscal Year, Period table. I cant really change the format types of these tables, or I would have to create another Business View of the table to effect the formatting. In App Studio I was able to do a where-based join, and that seemed to do the trick.
Link to comment
Share on other sites

Except if I havent found the way to do it, sadly, it seems that a WHERE based JOIN as done in AS its not possible using Designer.

I have created DEFINEd fields and have tried to use them in the JOIN without any success.

The DEFINEd fields dont even display in the JOIN editor.

So, my previous posted steps are not good in that situation where you need to join two fields having a different format based on a DEFINEd field to have them matching.

Maybe in a further release this will be possible

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...