Hi Frank,
>>> An I think, I can not use %%USER%% in a view.
You are correct! $$USER$$ is a WP Data Access environment variable and is not available in your view. But you can use it in the where clause of your publication.
Does this help?
Thanks,
Peter
Thank you,
>>But you can use it in the where clause of your publication.
>>Does this help?
Sorry. No is doesn’t help. The query is very complex (with UNION and a subselect), so I have 3 places for the $$USER$$ in a where clause.
Is there a plan for the future to implement querys? Just like the plugin WPTABLES, what I use for this.
Regards
Frank
Have you considered making a view from your query and using it in your publication? I don’t know your query so I can’t recommend a district solution.
No, the query is too much complex.
Regards
Frank
Hi,
>>> Is there a plan for the future to implement querys?
Yes, this is planned. But effectively this would be the same as creating a view, like Charles mentioned. Can you share the query? Can we help somehow?
Please use the contactform on the plugin website if you prefer to share information in private.
Thanks,
Peter
