Results 1 to 3 of 3

Thread: search - view sql statement

  1. #1
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default search - view sql statement

    Is it possible for me to find out the sql statement that is being performed by a basic search?

  2. #2
    anamikakhadwal's Avatar
    anamikakhadwal is offline Sugar Community Member
    Join Date
    May 2007
    Location
    India
    Posts
    82

    Default Re: search - view sql statement

    Hi,
    you can view it in include/ListView/ListViewdata.php in function getListViewData() by printing $main_query .


    thanks

  3. #3
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: search - view sql statement

    Quote Originally Posted by anamikakhadwal
    Hi,
    you can view it in include/ListView/ListViewdata.php in function getListViewData() by printing $main_query .


    thanks
    Thanks thats perfect

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 24
    Last Post: 2008-08-20, 08:19 PM
  2. Replies: 1
    Last Post: 2008-02-22, 04:25 PM
  3. Replies: 2
    Last Post: 2007-08-14, 08:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •