Business rule not working with database view
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-12-2018 09:41 AM
I created a database view to join 3 tables for querying via the ODBC driver. The numerous exclusions I needed did not work via the Where clause in the views so I created a business rule to execute BEFORE Query with conditions that exclude data for specified fields (like unit = TAMUG). But when I run a report to test the rule on this database view, it doesn't work. Does the rule not filter the data unless you script it? Or is querying via a report not a good test?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2018 06:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2018 09:21 PM
I haven't seen DB views able to work with the prefix proceeded by a ".". As far as I have seen, the prefix should be proceeded with a "_" to work properly.
So your where clauses would be like "pj_sys_id = pt_parent"
