+3I created a GI that pulls data from a custom table. The GI is working perfectly. I want to add a filter to the GI so that I can use the filter in the Mobile App. The GI is working in the Mobile App.
When I go to the Parameters tab in the GI, there are no fields available to select:
Here are some print screens of the GI in case anything looks like it is missing:
This is the result of viewing the GI:
I don’t do GI’s often, so I don’t know what is wrong.
Best answer by bwhite49
In the GI conditions add this. Replace AcctCD with your field
+7
+3I selected the customer number field and tried to save. I get an error that Name cannot be empty. After selecting the Schema field, there still is nothing in the Name drop down.
+12The name field can’t have any spaces. It’s a unique ID that you need to define as Nick mentions. So name should = “CustomerID” not “Customer ID.” “Customer ID” should be the display name.
+3There are no fields to select in the Name column drop down. I just typed in UsrCustomerID and it let me save it. I though it had to be available in the drop down list.
Now I just have to figure out how to allow the results grid to show everything UNLESS there is a value in the parameter condition.
Condition
The filter works great now. Any tips on how to not filter records unless there is a value in the parameter field?
+12In the GI conditions add this. Replace AcctCD with your field
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.