Meta Box

Hey Long,

Ok I see now. Thanks for that information.

Great thank you

Nevermind, the below is working! Is there a way to choose which fields I want to display in the Block? My goal is to replicate how the Query Loop block works in the editor so that I can insert each custom field value into its own container.

function my_featured_callback( $attributes, $is_preview = false, $post_id = null ) {
    global $wpdb;
    $ids = $wpdb->get_col( "SELECT ID FROM job_openings WHERE featured_job = 1" );

    if ( empty( $ids ) ) {
        echo 'There are no posts';
    } else {
        $query = new WP_Query( [
            'post_type' => 'job-opening',
            'post__in'  => $ids,
        ] );
        // Do something
        // The Loop
        while ( $query->have_posts() ) {
            $query->the_post();?>
            <h2><?the_title(); ?></h2>
            <?
            $company_name_value = rwmb_meta( 'company_name', '', get_the_ID() );
            $location_value = rwmb_meta( 'location', '', get_the_ID() );
            $jo_job_type_value = rwmb_meta( 'jo_job_type', '', get_the_ID() );
            $date_posted_value = rwmb_meta( 'date_posted', '', get_the_ID() );

            echo $company_name_value;
            echo $location_value;
            echo $jo_job_type_value;
            echo $date_posted_value;
        }
    }
}

Hey Long,

Yes please see it below.

// function for featured jobs and custom fields
function my_featured_callback( $attributes, $is_preview = false, $post_id = null ) {
    $field_value = rwmb_meta( 'field_id', '', $post_id );
    $args = array(
        'meta_key'   => 'field_id',
        'meta_value' => $field_value,
        'post_type'  => 'job-opening',
        'tax_query' => array(
            array(
                'taxonomy' => 'department',
            ), 
        ),
        // filter to posts where switch = 1
        'key' => 'featured_job',
        'value' => 1,
        'compare' => '=',
        'type' => 'NUMERIC',
    );

    $query = new WP_Query( $args );
    
    // The Loop
   while ( $query->have_posts() ) {
	    $query->the_post();
        echo 'the loop is working';
	    echo '<li>' . get_the_title() . '</li>';?>
        
        <p>
            <strong>Company:</strong> <?= rwmb_get_value( 'company_name' ) ?>
        </p>
        <p>
            <strong>Location:</strong> <?= rwmb_get_value( 'location' ) ?>
        </p>
        <p>
            <strong>Job Type:</strong> <?= rwmb_get_value( 'jo_job_type' ) ?>
        </p>
        <p>
            <strong>Company Logo:</strong> <?= rwmb_get_value( 'jo_comp_logo' ) ?>
        </p>
        <p>
            <strong>Date Posted:</strong> <?= rwmb_get_value( 'date_posted' ) ?>
        </p>
        <?php 
    }

    wp_reset_postdata();
}

I also came across this https://docs.metabox.io/extensions/mb-custom-table/#query-posts-with-wp_query and my custom fields should be in a custom table. So in this case, is the following format preferred? First get the posts where featured_job = 1

global $wpdb;
$ids = $wpdb->get_col( "SELECT ID FROM your_table WHERE featured_job = 1" );

if ( empty( $ids ) ) {
    echo 'There is no posts';
} else {
    $query = new WP_Query( [
        'post_type' => 'job-opening',
        'post__in'  => $ids,
    ] );
    // Do something
}

Hey Long,

Thanks for your reply and help.

Using your information I've created a callback function in functions.php

I tried to adapt it to get two field values per post (company name and location). Would this work?

function my_featured_callback( $attributes, $is_preview = false, $post_id = null ) {
    $company_name_value = rwmb_meta( 'company_name', '', $post_id );
    $location_value = rwmb_meta( 'location', '', $post_id );
    $args = array(
        'post_type' => 'job-opening',
         'tax_query' => array(
            array(
                'taxonomy' => 'department',
                'field'    => 'slug',
                'terms'    => 'featured-jobs',
            ), 
        'meta_key'   => array('company_name', 'location')
        'meta_value' => array($company_name_value, $location_value)
    );
    $query = new WP_Query( $args );

Next, how would I get this to display in the Gutenberg Query Loop? Or should I create a new block that can be inserted into the gutenberg editor?

Thanks again,
Fergal