Customer application-newly added NW data items in the list view are not having index

Nextworld Platform
1

Hi Team,
We’ve added the below fields in the Customers field in our layout’s list view. We can’t see the filters for these fields and we cannot see them in Indexes too.
Is there any limitation on these?

  • Tax Exempt Permit Number
  • Credit Limit
  • Send Customer Statements

Thanks

2

Hi Ambika!
The most likely reason a field isn’t available to filter on is because the table backing the application has “Index Query Restriction” enabled on the Indexes page. This flag being enabled means that only fields that are part of an index may be filtered on.
If the table’s customization pattern allows it, you can customize the table and add the fields you want to an index or create a new index. This should allow you to filter on the added fields.
Can you confirm the table the application is over has the Index Query Restriction flag enabled, and if so, that adding custom indexes allows filtering?

3

Thanks Samuel. Yes, “The Index Query Restriction” is enabled. When I customized the table and checked, I noticed that the fields, I mentioned above are a part of CustomerFields data item group and not a direct field, so I was unable to add them.
These CustomerFields, when I open in the table definition, I can’t see the option to add Index.

Can you please let me know how to proceed further. Thanks again.

4

You won’t be able to put the index on the Data Item group’s table as that just defines a list of fields to pull into other tables.
You can add the fields you want to the table definition’s fields list, then add them to an index. There shouldn’t be problems with having a data item on the table and in a data item group on the table.