on 12-04-2014 8:20 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please explain with an example.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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".
User | Count |
---|---|
93 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.