Location of “duration” for SQL

  • Created an SQL query (through wpdata tables) to have user log in history feed into a table. Cannot locate the “Duration”? It populates on pages (See url) through shortcode so I know it’s there somewhere, but I can’t seem to find how to fetch it from the data base?

    I’ve tried;
    wp_fa_user_logins.duration
    wp_fa_user_logins.Duration
    wp_fa_user_logins.DURATION
    wp_fa_user_logins.login_duration
    wp_fa_user_logins.login_Duration
    wp_fa_user_logins.login_DURATION

    All result in same error(s); MySQL said: Unknown column ‘wp_fa_user_logins.duration’ in ‘field list’

    Pulls all other queries into table such as; username, time_login, time_logout, etc. etc. just fine. (Note: in the “WP data tables” GUI after selecting the wp_fa_user_logins table, it also does not show under the available “sql columns” – but I can manually enter it if I can find it.

    Any assistance on how to call it from the DB is greatly appreciated.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Faiyaz Alam

    (@faiyazalam)

    @greg3 there is no column “duration” in the DB table.

    I am generating this virtual column during run time.
    You can find the SQL query in the php file:
    plugins/user-login-history/inc/admin/class-admin-login-list-table.php

    Hope this helps.

Viewing 1 replies (of 1 total)
  • The topic ‘Location of “duration” for SQL’ is closed to new replies.