For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
I have come across a relationship behavior that I don't know how to change without programming the logic of the relationships on my own. Depending on the value of the field in the master table in the detail, the condition of the where clause changes, you can apply =, LIKE or even include no operator, causing the query to fail. If the field for which the relationship is made contains an _ (underscore) in the where of the detail block, it will make a LIKE field:block_master.field_master. If it starts with # it will not apply any operator and the query will fail. Is there a way to change the behavior so that the operator of relations is always "=" regardless of the content of the field? Examples: Relation fails because where clause in detail is "product_code :table_master.product_code". It does: WHERE product_code '#FAIL' instead of WHERE product_code = '#FAIL' Relation doesn't work correctly because where clause in detail is "product_code LIKE :table_master.product_code". Relation works OK because where clause in detail is "product_code = :table_master.product_code". Thank you,