search form with field not on grid

Questionssearch form with field not on grid
Ed K asked 1 month ago

Is there a way to create a search form against fields that do not exist on the grid.  Example:

  • Order header
  • Order detail lines (include ITEM column)

Grid only includes columns from Order Header, but we need to include search form to filter only Orders that contain item number in it’s details.

SQL would be something like:

select orderNumber, orderStatus

from orderHeader

where orderNumber in (select detailNumber from orderDetail where¬† detailItem like [search_item] or [search item] = ‘ ‘)

 

2 Answers
Ed K answered 1 month ago

Also, will need a way to pass the filtered item value to subgrid(s)

Abu Ghufran Staff answered 4 weeks ago

Currently this level of WHERE clause is not supported. You need to have this field in select query to use filter.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Your Answer

6 + 16 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?