Hello Everyone,
I have a query,
I have a standard change catalog. In which I have a Category as Standard change which is parent, and the data is stored under [sc_category] table. now this standard change category has child categories A, B, C which are also stored in same [sc_category] table. to show this child options in request form I have a variable [Childs of Standard] of type reference filed, in type specifications I have given reference table [sc_category] and in reference qualifier condition given this = active=true^parent="parent_sysid"
so now in request form for [Childs of standard] variable I can see three options A ,B ,C.
Now the Actual question is for the child categories Again they have child categories like Category A parent of (x1, x2, X3), Category B parent of (y1, y2, y3, y4), Category C parent of (z1, z2, z3). so, now again I have variable [select option] of type reference filed, in type specifications I have given reference table [sc_category]in which I need to show Childs of A, B, C. like if user select A in [Childs of standard variable] then I need to show only (x1, x2, x3) in [select option] variable. after selecting X1 then in another field user can select the templates.
So now can I get help what can i give in reference qualifier for [select option variable] that show only relevant Childs based on selection of parent such as A in Childs of standard then in variable select option x1, x2, x3. and same continues to B &C.
