Forum Stats

  • 3,853,849 Users
  • 2,264,287 Discussions
  • 7,905,480 Comments

Discussions

FDMEE table - TBHV....

MattGli
MattGli Member Posts: 2
edited Aug 26, 2019 8:34AM in Financial Data Management

Hi,

Can you help me to identfy what is table name for - Complex Logic Criteria Account? I know that TBHVLOGICGROUP is for Logic Group, and TBHVLOGICITEM is for Logic Group Item but not sure what is for Complex Logic Criteria Account / Logic Criteria Value/

hope you can help

MattGli

Best Answer

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Aug 22, 2019 8:04AM Answer ✓

    It is a combination of tables TBHVLOGICITEM and TBHVLOGICITEMCRITERIA

    Cheers

    John

  • MattGli
    MattGli Member Posts: 2
    edited Aug 26, 2019 5:08AM

    Hi John, thank you for help : )

    Maybe you can also help how to clean/delate all items from: TBHVLOGICITEMCRITERIA table ? I cannot do this by sending empty file and so on

    Thanks Matt

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Aug 26, 2019 8:34AM

    Depends if you have access to a SQL IDE and FDMEE connection details, if so you could just delete simply delete all the records from the table.

    Alternatively you could create a custom script in FDMEE and use the API with the executeDML method, there is an example here , just change the SQL statement to delete all records.

    Make sure you want to definitely delete all records and have a backup.

    MattGliMattGli