|
Hi everybody, I have the following problem: I am working with Project Trees in FS financials, and have been asked to limt the selection of a tree node based on the value of a higher level node, which really means that I have to dynamically build the lower level list box based on the higher level list box. The first list box is based on the following SQL VIEW: Select a.setid, a.tree_name, a.tree_node from pstreenode a where a.effdt = (select max(effdt) from pstreenode where a.setid = setid and a.tree_name = tree_name and effdt <= sysdate) and a.tree_level_num = 1. As you can see this list box is based on the tree_name field on the current record. What I have attempted (no success) is to populate a derived work field with the value of the of this list box (when the value changes), and use the derived work field in a SQL VIEW to limit my selection on the lower level. Here is the code: Select a.setid, a.tree_name, a.tree_node from pstreenode a where a.effdt = (select max(effdt) from pstreenode where a.setid = setid and a.tree_name = tree_name and effdt <= sysdate) and a.tree_level_num = 2 and tree_node = derived.field. The SQL build always abends. I have tried to seach the User archives with no success. Any help or feedback would be greatly appreciated. The environment is Windows NT 4.0 and Windows 95, SQR Version 4, Database = Oracle 7, Software = Peoplesoft 7.5. Thanks in advance, Dennis Missel
|