Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 3
Registered: ‎02-18-2013

Add schema into the Sales Logix queries....

Hi,

 

I want to know, if someone has added the database schema into the SLX web queries, like:

 

select * from sysdba.contact;
 --sysdba is the schema

 

I know that the groups are saved into the PLUGIN table but if I want to check the query used to load a group, in the DATA field, it is unreadable..., then I cannot add the "sysdba" prefix into the query.

 

Can someone help me please?

Thank you so much,

Liz.



Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Add schema into the Sales Logix queries....

sysdba user "owns" the SalesLogix db - why would you want to prefix the queries?

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Highlighted
New Member
Posts: 3
Registered: ‎02-18-2013

Re: Add schema into the Sales Logix queries....

Thank you RJLedger for answering my post.

 

Actually we have detected that adding the prefix (schema name) in each join helps to execute the queries quicker..., we have done this on our customized website,  but now we can do the same thing on SLX web.

 

Is there anyway to do this?

 

Thank you & best regards,

LIz.

New Member
Posts: 3
Registered: ‎02-18-2013

Re: Add schema into the Sales Logix queries....

Sorry, 

 

*but now we want to do this into SLX web.

 

 

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Add schema into the Sales Logix queries....

Not really without a TON of hacking.. and then I'm not sure you could get it all. Not really worth the effort.

 

What really needs to be done is to deal w/DB "tuning" in general.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html