may be i was not clear with the earlier question...
I added the fields parameters in the shortcode in order to show those fields in the table at that particular page.
I have a scenario where I have to show the tables at three different pages with different fields at each place.
Let me explain the scenario,
I have a field Father/Spouse in the db and have set the display column non zero in manage database fields. I can see the field in the table as expected. I have added a short code in some other page where the father/spouse name is not added, as I just wanted to show the first name, last name and cell no.
I would like my users to be able to search by first name, last name, cell no. But not by Father/spouse, because that field is not a part of that table and it won't work anyway. But unfortunately the Father/Spouse is listed in the search list drop down.
One way to get rid of that would be to set 0 in the display column in manage database fields but then it would lead to Father/Spouse fields missing in the search and sort drop down list for some other table in a different page.
Is there a work around for this?
Hope I am clear this time. :)