Where Clause in App Studio

[etz (eric)]

I’ve reviewed several threads in this forum regarding similar issues, but unfortunately none of the solutions addressed my specific problem.

In the PO Approval app, I’ve added a Panel Grid through App Studio and bound it to a BAQ. I’m attempting to apply a Where Clause to filter the results, but I suspect something is off with my clause syntax or configuration — when I preview the grid, it returns “No Records Available.”

Any guidance on what might be causing this or how to properly structure the Where Clause in this context would be greatly appreciated.

This is what I have done in App Studio:

1. I have created a Data View for the BAQ:
   

   

2. I added the Panel Grid:
   

   

3. I entered The Data View ID into the Grid Model section

4. I entered The BAQ ID into the Provider Model section
   

   

5. I entered my Where Clause
   

6. Result:
   

   

[Randy (Randy Stulce)]

Try putting it in the Where List instead as the where clause can be flaky.

[bparsons (Billy Parsons)]

Seconded, where clause has worked for us in the past but sometimes doesn’t. I’m sure it may just be user error on our part (incorrect formatting or something), but plugging them in the Where List works great:

[d_inman (David Inman)]

@etz

• I entered my Where Clause
  

Also, IIRC you don’t need the exclamation point here. I’d try it with a ? instead or just the single quotes and curly brackets.