User Meta In WHERE Clause

Ah, good question ?? and easy solution:

related_company.post_author = {@user.ID}

That doesn’t seem to be quite it – let me clarify. For both Documents and Users, the related field for Company can be either unselected or blank. For a Document, if related_company is blank, it’s a public Document. If it’s selected, it should only be visible to a User of that Company.

Your solution seems to be pulling just those Documents owned by the current User. I want all Documents available to their Company. It would seem that the reference would be something like:

{@user.related_company.id}

Not sure if that’s a valid reference, though. Are all of the user meta fields available as Magic Tags? If so, how are they referenced?

I guess the thing I’m looking for is how to refer to the current user’s meta info? This seems like it should be something like:

@user.related_company
@user.meta.related_company

I’m browsing the wp_usermeta table directly and seeing the values that I want to use. I just don’t know how to refer to them in Magic Tags.

It may not be ideal, but I ultimately used another plugin (Shortcode Exec PHP) to be able to call some PHP directly and “wrap around” my Pods calls. Probably could have done it all in Pods, but for right now it was quicker and easier to do it this way.

Anything you can pass on about using Magic Tags for user metadata would be helpful. Thanks.

If you had a bi-directional relationship on the related_company back to users, you could use this:

related_company.users.ID = {@user.ID}

If not, then you could *maybe* use this, but be aware it will only work if you have related company set to a single-select. You may also need the latest patch from https://pods.io/latest/ that I’m committing shortly.

related_company.ID = {@user.related_company.ID}