Topic: SQL Query with no id displayed?

Is it possible to write an SQL Query on a button to search specific records including the id but not display the id as MVDB does by default?

If I use a button and set the action on search, the id is seek but not displayed. If I write the SQL query including the id for edition, I see it in the grid...

I know we can hide a column using script but I would like to avoid doing so to keep it lightweight.

The form has multiple objects and specifically auto-loading grids + a search field for filtering each grid.

Re: SQL Query with no id displayed?

Good Morning Thierry,
Please look at the attached screen-shot.  Is this what you are meaning?
Whenever I have used the sqlsearch function, I have included the 'id' (to maintain the relationship) but have dropped it when outputting to the grid by adding the reserved word 'delete_col'
Maybe this helps.
Derek.

Post's attachments

Attachment icon tcoton.jpg 123.4 kb, 420 downloads since 2016-03-02 

Re: SQL Query with no id displayed?

This is exactly what I was looking for. Thank you very much.

There must be no space before "delete_col" otherwise it does not work wink