Dynamic Pulldown not populating with fields coming from automatic lookups

[wpreston]

The Sideview Report Builder (and subsequent dynamic dropdowns that I've tried to create) will pick up the fields I've defined in props.conf/transforms.conf, but does not pick up any fields that are defined by an automatic lookup. For instance, I have a "User-ID" field that I extract from the logs, and I have an automatic lookup based on User-ID that creates the "Full-Name" field. So when the dropdown box populates, I get the User-ID field in the dynamic dropdown box, but not the Full-Name field.

I've run the search macro that is used in the Sideview Report Builder to get the data for the Fields dynamic dropdown box (get_fields_for_report_pulldowns). If I append that to the end of a normal search, it does show the fields that come from an automatic lookup, they just don't show up in a dynamic dropdown. How can I get the fields from automatic lookups to be present in the dynamic dropdown box?

[sideview · Accepted solution]

Well Pulldown modules are regularly used to display both kinds of fields in various apps so I know that there is no fundamental problem here or fundamental difference between the treatment of each kind of field.

However I think what's happening is that your props.conf/transforms.conf extractions are scoped at the system level so that they run for all searches across all apps, whereas your automatic lookup configuration is instead scoped at the app level.

I will bet that you're testing out the search language in the app where the automatic lookups are defined, and the macro is finding the fields just fine, and then you're testing the Sideview Report Builder in the Sideview utils app (of course), and the automatic lookup config just does not run in that app context.

Can you check whether this is the case?

[sideview]

Great to hear. 😃

[wpreston]

This was exactly the problem. Thank you for your answer!