Including the name of a drop down in a query

[Former Member]

I have a couple drop down UDFs that have drop down values, however I want to display the description of the field, not the value. Short of bringing this over to a table, or changing the value is there a way I can bring this into my query?

[Rafaee_Mustafa]

Hi Lou,

UDF default values only shows code however you can fetch the description from  UFD1

Second, you can also use User Defined Values (Alt+Shift+F2) ---- > Search in Existing User-Defined Values

[kothandaraman_nagarajan]

Hi,

Please explain with an example.

Thanks & Regards,

Nagarajan

[Former Member]

So in this case I know how to pull from other disperate tables, just not description:.

SELECT T0."CardCode" AS "Cust Code", T0."CardName", T0."DocNum" AS "SO Number", CASE T0."U_KIC_ORDR_TYPE" WHEN 1 THEN 'Regluar' WHEN 2 THEN 'Blanket' END AS "Order Type", T1."firstName" AS "Salesperson",  T0."TaxDate",  T0."U_AIS_KIC_WhsRelDate", T0."DocDueDate", T3."WhsCode" AS "Whse", (SELECT T10."U_ShipVia" FROM "KIC_LIVE"."@AIS_KIC_TRUCKERS"  T10 WHERE T10."Code" =

T0."U_AIS_KIC_Trucker") AS "Carrier Name", T2."PymntGroup" AS "Payment Terms",  T0."U_AIS_KIC_FREIGHT", T0."U_AIS_Ship_Notes" FROM "KIC_LIVE"."ORDR"  T0 INNER JOIN "KIC_LIVE"."OHEM"  T1 ON T0."OwnerCode" = T1."empID" INNER JOIN OCTG T2 ON T0."GroupNum" = T2."GroupNum" INNER JOIN RDR1 T3 ON T0."DocEntry" = T3."DocEntry" WHERE T0."U_AIS_Tracking" NOT Like '%%101%%' AND T0."U_AIS_Tracking" NOT Like '%%999%%' ORDER BY T0."U_AIS_KIC_WhsRelDate"

In this case the description field I am trying to pull from is U_AIS_Tracking. I don't mind filtering from the codes but the thing I lack in this query is the description display in the select statement, in this case before T2."PymntGroup".