I’ve got a Dashboard which contains the result of Generic Inquiries filtered by Customer, but I want to be able to select the customer by searching by postcode. So I need the Address.PostalCode column to be available on the Customer Selector that is displayed on my dashboard form.
My Customer Parameter is defined from Customer.AcctCD. I’ve tried defining a CacheExtension with a (non-persisted) custom field, but that wasn’t recognised. And I can’t work out what Graph is being used by the Dashboard.
Was going to post this as a question, but can answer it myself as I’ve found a solution:
- Create a database table with a column of the desired data type (AcctCD nvarchar(30))
- Create a DAC for that table (it’s a real table, so decorate with PXCacheName)
- Define the selector on the AcctCD field
- Amend the Dashboard parameter to use that table/field as the Schema Object / Field.
(This also works for Generic Inquiries, the table needs to be included as a Data Source but doesn’t need a join. The parameter can then have Schema Field set to myTable.AcctCD.)