Catalog Item that displays Core_Country table values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2024 06:33 AM
I've looked at a few articles but have been unable to get the values of the core_country table to be visible on a catalog item variable. I can see the values in the table (231) which is an out of the box table from 2014 but keep getting no matches found. I've tried a reference type, list collector, lookup select box but no luck
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2024 07:10 AM
Since you can see the records on the core_country table, there shouldn't be a security issue with a Catalog Item variable. When you create a reference variable with this as the table and no reference qualifier (to start with at least), what do you see on the request form when you click the reference search icon (magnifying glass)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2024 07:43 AM
Hi Brad this was the initial way I set it up but just keep getting no matches found
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2024 09:52 AM
I don't know what that means. Share some screenshots of your variable setup and results.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-21-2024 12:34 AM - edited ‎10-21-2024 12:54 AM
Got it sorted it was a straight forward reference variable pointing to the country table but I added a read ACL for non-admins I can now see the countries on the catalog item impersonating a non admin user. Thanks