Show values from custom table in views

toni bird
Home / MB Views / Show values from custom table in views

Custom Fields
Re-Envisioned › Support › MB Views › Show values from custom table in views

  • Creator
    Topic
  • August 28, 2020 at 11:48 PM #21512
    Resolved toni bird
    Participant

    Hi, Is it possible to show values that are stored in a custom table that is within wp database? thanks

  • Creator
    Topic
Viewing 7 replies - 1 through 7 (of 7 total)
  • Author
    Replies
  • August 29, 2020 at 9:28 AM #21518
    Long Nguyen
    Moderator

    Hi Toni,

    Yes, we can call a PHP function via the proxy mb in the view. Use this code to show values that are stored in the custom table.

    {{mb.rwmb_meta( $field_id, {'storage_type': 'custom_table', 'table': $table_name} )}}

    For more information, please follow this documentation https://docs.metabox.io/extensions/mb-views/#running-php-functions.

    August 31, 2020 at 7:48 AM #21543
    toni bird
    Participant

    Hi Long, thanks for your reply, I'm getting this error...?

    Fatal error: Uncaught Twig_Error_Syntax: Unexpected character "$" in "obra-single" at line 50. in C:\xampp\www\wp-content\plugins\meta-box-aio\vendor\twig\twig\lib\Twig\Lexer.php:295 Stack trace: #0 C:\xampp\www\wp-content\plugins\meta-box-aio\vendor\twig\twig\lib\Twig\Lexer.php(227): Twig_Lexer->lexExpression() #1 C:\xampp\www\wp-content\plugins\meta-box-aio\vendor\twig\twig\lib\Twig\Lexer.php(126): Twig_Lexer->lexVar() #2 C:\xampp\www\wp-content\plugins\meta-box-aio\vendor\twig\twig\lib\Twig\Environment.php(653): Twig_Lexer->tokenize(Object(Twig_Source)) #3 C:\xampp\www\wp-content\plugins\meta-box-aio\vendor\twig\twig\lib\Twig\Environment.php(750): Twig_Environment->tokenize(Object(Twig_Source)) #4 C:\xampp\www\wp-content\plugins\meta-box-aio\vendor\twig\twig\lib\Twig\Environment.php(447): Twig_Environment->compileSource(Object(Twig_Source)) #5 C:\xampp\www\wp-content\plugins\meta-box-aio\vendor\twig\twig\lib\Twig\Environment.php(362): Twig_Environment->loadTemplate('obra-single') #6 C:\xampp\www\wp-content\plugins\meta in C:\xampp\www\wp-content\plugins\meta-box-aio\vendor\twig\twig\lib\Twig\Lexer.php on line 295

    thanks again

    August 31, 2020 at 8:48 AM #21545
    Long Nguyen
    Moderator

    Hi Toni,

    You need to change variables $field_id and $table_name by your value.

    
{{mb.rwmb_meta( 'field_id', {'storage_type': 'custom_table', 'table': 'table_name'} )}}
    August 31, 2020 at 9:29 AM #21547
    toni bird
    Participant

    Hi Long, thanks for your reply,I've done that already, but then nothing is shown. maybe I am missing something?

    August 31, 2020 at 3:37 PM #21554
    Long Nguyen
    Moderator

    Hi,

    Please share the code that created the custom table and fields and the code in View. I will take a closer look and give a quick response.

    September 4, 2020 at 12:11 AM #21635
    toni bird
    Participant

    Hi Long Thanks for your reply, I will share that, we are revisiting the whole website for more clients changes and will get to this issue later next week... will keep that as standby for now.. thanks

    September 5, 2020 at 1:47 AM #21664
    toni bird
    Participant

    Hi , got it sorted with a different approach. many thanks

    cheers

  • Author
    Replies
Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.