Thursday, March 31, 2011

Stupid view criteria with an and criteria not working

Note to self :

When creating a bind variable enabled criteria follow the following steps so you have no hassles.

1) Create LOV with straight sql (no bind variables in sql) or you will get a bind variable not bound error.

2) Create criteria (DONT use a criteria in your mappings create multiple criteria). This avoids parameter not found in sql error.

3) Apply all criteria to attribute lov mapping (View Accessors, edit, blue button to move). Then map your bind variable to a value ie if you have a attribute called Code in the VO you can just write Code in the value section.

4) If you want you can set a hint on the bind variable to hide it in the LOV.

DONE!!!

No comments:

Post a Comment