Hi all,
is it possible to use join operators while creating a custom field?
I want to join two views.
Thank you
Join tables in custom fields
Userlevel 7
+22
This topic has been closed for comments
Hi,
When you creating list of values for a custom field you have based it on a single view. Instead of that you can create new view as a join of two other views and base your custom field on the new one.
Best Regards,
Pawel
Userlevel 7
+22
Hi,
When you creating list of values for a custom field you have based it on a single view. Instead of that you can create new view as a join of two other views and base your custom field on the new one.
Best Regards,
Pawel
Hi Pawel,
I am afraid I didn’t catch that. Do you have an example to clarify it?
Thank you and kind regards
Yes, for IFS Apps 9, when using the “Select” Implementation Type for a Read Only custom field, you can use any valid SQL statement, as long as it’s correctly bound.
Did you run into some issue when trying this out to see if it would work?
I believe Pawel is outlining your options when creating a persistent custom field that references a single view to determine what shows up on the list of values when the user chooses a value to populate the field.
Userlevel 7
+22
Hi
yes I had a problem in the past. But I found another way to solve it.
Thank you for replying.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.