Category
Data Sources
Product Version
7.1
Creating a View with a OR in the INNER JOIN
Answered
Hello guys,
Using the View Builder, is there a way to create a view with an 'OR' in an 'INNER JOIN' including an hardcoded value ?
Select a.1, a.2, a.3, b.4,
From a
Inner JOIN b
on( a.1 = b.1 and (a.2 = b.2 or a.2 = ' XXX ' ) )
Thanks
Louis-André
The same question
Hi Louis,
You can created nested logic by pressing the blue arrows to the left of the join logic as seen below:
Does this work for you?
Regards,
Nathan
Hi Louis,
You can created nested logic by pressing the blue arrows to the left of the join logic as seen below:
Does this work for you?
Regards,
Nathan
About the hardcoded value instead of selecting a colunm ?
Inner JOIN b
on(
a.1 = b.1
and ( a.2 = b.2 or a.2 = ' XXX ' )
)
About the hardcoded value instead of selecting a colunm ?
Inner JOIN b
on(
a.1 = b.1
and ( a.2 = b.2 or a.2 = ' XXX ' )
)
Hi Louis,
My apologies, the hardcoded value will not be possible unless:
Hopefully one of these will work for you here, and sorry for the inconvenience.
Regards,
Nathan
Hi Louis,
My apologies, the hardcoded value will not be possible unless:
Hopefully one of these will work for you here, and sorry for the inconvenience.
Regards,
Nathan
Hi Louis,
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
Hi Louis,
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
Replies have been locked on this page!