MyLama Posted April 29, 2008 Share Posted April 29, 2008 Hi - To fish out custom field data for reporting purposes, is there any issue with adding a View based on a select statment to within the WHMCS DB itself? SELECT tblcustomfields.fieldname, tblcustomfieldsvalues.value,tblorders.userid,tblclients.lastname FROM tblcustomfields, tblcustomfieldsvalues, tblorders,tblclients WHERE tblorders.userid = tblclients.id AND tblcustomfields.id = tblcustomfieldsvalues.fieldid; etc etc....... Or is is something that is best done in a seperate DB? Maybe a stupid question, but I don't know the back end of this so well yet and I dont want adding a view to cuasse some weird effect. Thanks, MyLama 0 Quote Link to comment Share on other sites More sharing options...
MyLama Posted April 29, 2008 Author Share Posted April 29, 2008 In the above post, I just want to know if a view used for reporting purposes are best created in sperate DBs (I.e. will using the WHMCS DB drag down the DB, cause other issues, etc....) I wish the window for editing posts was a bit longer.... Thanks, MyLama 0 Quote Link to comment Share on other sites More sharing options...
MACscr Posted April 29, 2008 Share Posted April 29, 2008 I personally dont see any issues with creating new tables in the db 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.