Skip to main content
Answer

Initially, data won't show in generic inquiry.

  • January 26, 2023
  • 6 replies
  • 237 views

Forum|alt.badge.img+1

Hi,

My generic inquiry won’t display the data unless I pick anything from my parameter (Customer)first, then I need to delete it when I don’t need that filter yet. Given that the date is already specified, shouldn’t it display the data as soon as I open it?

I think this also causes my pivot table to not display anything.

Appreciate any help!

Best answer by aaghaei

Change the Schema to SOOrder.CustomerID and tick the select from Schema for customer parameter 

and filter as well change the customerCD

6 replies

aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • January 26, 2023

Your customer schema doesn’t look right as it is showing <new>. Please copy your parameters s and filters tab snip to see what is going on


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • January 26, 2023

Your customer schema doesn’t look right as it is showing <new>. Please copy your parameters s and filters tab snip to see what is going on

Thank you, here it is.


aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • Answer
  • January 26, 2023

Change the Schema to SOOrder.CustomerID and tick the select from Schema for customer parameter 

and filter as well change the customerCD


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • January 26, 2023

Change the Schema to SOOrder.CustomerID and tick the select from Schema for customer parameter

I got an error sir. This is my new parameter

and this is the new condition

also tried ticking ‘from schema’ here. same error

Thanks!


aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • January 26, 2023

In the Conditions you have not set the value1 to customer parameter


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • January 26, 2023

In the Conditions you have not set the value1 to customer parameter

Thank you so much sir!