any changes to K1000 database tables recently
Hi
select CUSTOM_2 FROM USER where ID = SUBMITTER_ID
earlier i was able to pull CUSTOM values from USER table now i dont see CUSTOM 1 to 4 values in the
USER table,
any idea which table stores these values
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
7 years ago
Yes, the custom fields are now in the USER_FIELD_VALUE table.
Comments:
-
thankss - rahimpal 7 years ago
-
can you help me to update this code
update HD_TICKET as T
set T.CUSTOM_FIELD_VALUE5 = (select CUSTOM_2 FROM USER where ID = SUBMITTER_ID) where
T.ID = <TICKET_IDS>;
earlier i used to get the user details by pulling the Custom2,Custom3,Custom4 colums now all are in the same table in FIELD_VALUE - rahimpal 7 years ago-
Your sub select statement should be:
select FIELD_VALUE from USER_FIELD_VALUE where FIELD_ID = 2 and USER_ID = SUBMITTER_ID
That will return the value of custom field 2 for the user. - chucksteel 7 years ago
