where to find table for custom field in a custom module?

I created a custom field inside a custom module, The custom field is working as expected and changes were made to its value when I edit it inside the edit part of the module for testing. But what I want to do is to update the value of the custom field using a custom SQL code. I was able to identify the table name for the module but when I checked the fields inside it the custom field I created was nowhere to be found. So I would like to know where exactly is my custom field holding the values saved in it, if not inside the module table. Also, I was able to change the values inside the module table using my custom SQL code but I just can't find where my custom field is placed in the database.

Thank you

Parents
  • Hi Rodolfo,

    Look for <PackageKey>_<CustomModule>_cstm table.

    In an example for my custom "Issues" module, it could be like; pck_issues_cstm.

    Best Regards

    Tevfik Tümer

    Developer Support Engineer

  • Hello Tevfik ,

    Thank you so much, that did it. Though I would like to know where can I find this sort of information in the documentation for 6.5? Also, from what I've read, it was modulename_cstm and it seems that is why I wasn't able to retrieve any information.

    Kind Regards,

    Rodolfo Tuble

Reply
  • Hello Tevfik ,

    Thank you so much, that did it. Though I would like to know where can I find this sort of information in the documentation for 6.5? Also, from what I've read, it was modulename_cstm and it seems that is why I wasn't able to retrieve any information.

    Kind Regards,

    Rodolfo Tuble

Children