Attention!

These forums are not monitored. We provide the discussions forum as a place for users of free extensions to help each other and find answers, not as a place for our staff to deal with urgent support issues. Our staff very rarely responds to forum posts. Occasionally we will respond to forum posts but responses are not guaranteed.

If you have an active subscription for a commercial extension and wish to receive support please login to your Artetics.com account and submit a ticket. The ticketing system is the best way for you to get assistance in a timely manner.

Thank you!

  Sunday, 07 June 2020
  1K Visits
0
Votes
Undo
Can a variable be used in the SQL statement for Art Data? e.g. data pulled from DB custom user field in WHERE.

sample SELECT `E_ID` AS 'EC',`Px_ID` AS 'PMS', `Category`,`Product`,`Quantity`, `Delivery_Info`, `PxFirst` AS 'First Name' FROM `_Event` WHERE `Current_Status` = 'Submitted' AND `ECP_ID` = $VAR

If yes - syntax?
Thanks
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.