Non SysID / String Field Database View Joins

Jason R1
Kilo Expert

‎08-02-2023 03:23 PM

Hello All.  I am seeking a guidance on how to construct a database view join using non-sys_id values.

I have 2 custom tables where the only common field is a String type, EX: FRJ-HRD-OFFICE OF THE DIRECTOR.

I found an article that suggested using a Before Query business rule (?).

Any article links or examples would be appreciated.

0 Helpfuls
  • 248 Views
1 REPLY 1

Jason R1
Kilo Expert

‎08-09-2023 08:36 AM

Since no one that may have seen this post has any answers. I will close the question.

0 Helpfuls