Public void Lookup ()
{
Systablelookup;
Query query = new query ();
Querybuilddatasource qbds;
;
Ofstaffingtable. jobid = ""; // leave the field empty to prevent groupby pulling failure when the field has a value.
Ofstaffingtable_jobid.text ("");
Export ablelookup = export ablelookup: newparameters (tablenum (hrppartypositiontablerelationship), this );
Using ablelookup. addlookupfield (fieldnum (hrppartypositiontablerelationship, jobid ));
Using ablelookup. addlookupfield (fieldnum (hrppartypositiontablerelationship, jobname ));
Qbds = query. adddatasource (tablenum (hrppartypositiontablerelationship ));
Qbds. ordermode (ordermode: groupby );
Qbds. addselectionfield (fieldnum (hrppartypositiontablerelationship, jobid), selectionfield: database );
Qbds. addsortfield (fieldnum (hrppartypositiontablerelationship, jobid ));
Qbds. addselectionfield (fieldnum (hrppartypositiontablerelationship, jobname), selectionfield: database );
Qbds. addsortfield (fieldnum (hrppartypositiontablerelationship, jobname ));
Qbds. addrange (fieldnum (hrppartypositiontablerelationship, organizationunitid). Value (queryvalue (ofstaffingtable. organizationunitid ));
Systablelookup. parmquery (query );
Using ablelookup. Using mformlookup ();
}
Use group by to filter data in standard Lookup