/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


any changes to K1000 database tables recently

03/24/2017 1101 views
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

j4Jiw4.png

0 Comments   [ + ] Show comments

Comments


All Answers

2
Yes, the custom fields are now in the USER_FIELD_VALUE table.
Answered 03/24/2017 by: chucksteel
Red Belt

  • thankss
  • 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
    • 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.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ