Skip to content

Instantly share code, notes, and snippets.

@nvg
nvg / psunit_base.ppc
Last active February 24, 2022 03:31
peoplecode: PSUnit base
import TTS_UNITTEST:TestBase;
class Test extends TTS_UNITTEST:TestBase
method Test();
method Run();
method Setup();
protected
private
instance string &someValue;
@nvg
nvg / component_search.sql
Created June 19, 2017 17:58
peoplecode: sql: component search
---- Menu Look-up
SELECT SRCH.PORTAL_LABEL LABEL
, NVL(SRCH.PORTAL_URI_SEG2, ' ') COMPNOENT
, SRCH.PORTAL_OBJNAME
--L1.PORTAL_LABEL, L2.PORTAL_LABEL, L3.PORTAL_LABEL,
--L4.PORTAL_LABEL, L5.PORTAL_LABEL, L6.PORTAL_LABEL
,'Main Menu > ' || L1.PORTAL_LABEL || decode(L1.PORTAL_REFTYPE, 'F', ' > ')
|| L2.PORTAL_LABEL || DECODE(L2.PORTAL_REFTYPE, 'F', ' > ')
|| L3.PORTAL_LABEL || DECODE(L3.PORTAL_REFTYPE, 'F', ' > ')
|| L4.PORTAL_LABEL || DECODE(L4.PORTAL_REFTYPE, 'F', ' > ')