I have spent some time to make it work, so I decided to share it with community.:
<PDM_MACRO NAME=dtlLookup hdr="Request" attr="request" factory=cr extraurl="KEEP.forChangeCrList=1+KEEP.ALWAYS_LIST_CR=1">
Thanks for sharing this Gutis.
haven't before,
but now I have tried and it works fine.
steps I produced:
1. open form to edit;
2. open source code, add <input type=hidden name=SET.type value=x> between forms tag and save; (or publish normal dtlTextbox)
3. search by type='X';
but you should have factory with no type restriction or u'll get constarint like : (type = 'R' or type is NULL) AND (type = 'x')
cdtj did you ever tried to create one more request type let say type= 'X'?
thanks for sharing!
fighting with request types consumes a lot of time,
but I think there is more flexible solution,
you can publish new factory with no type restriction, like:
OBJECT cr { FACTORY req { DOMSET template_list "template_name" "" DYNAMIC ; STANDARD_LISTS { SORT_BY "open_date DESC, id DESC, status=status.sym, priority=priority.sym DESC, ref_num" ; MLIST OFF ; RLIST OFF ; }; REL_ATTR persistent_id ; COMMON_NAME ref_num ; FUNCTION_GROUP "call_mgr" ; }; };
OBJECT cr {
FACTORY req {
DOMSET template_list "template_name" "" DYNAMIC ;
STANDARD_LISTS {
SORT_BY "open_date DESC, id DESC, status=status.sym, priority=priority.sym DESC, ref_num" ;
MLIST OFF ;
RLIST OFF ;
};
REL_ATTR persistent_id ;
COMMON_NAME ref_num ;
FUNCTION_GROUP "call_mgr" ;
and forget about search conditions like (type IN ('R','I','P') OR type is NULL) to display all types in a one form.
plus you'll get correct form sorting.
regards,
cdtj