Re: [equinox69] Unable to search database by createdBy.Fullname (in separate user table)
Hi,
The simplest way to handle allow dealers to search the admin for their own inventory is to have them search using their own user number created by CMS Builder.
Next, you can add a custom advanced search field to the inventory section:
Admin > Section Editors > Inventory
- open the searching tab.
- on the 2nd line of the textbox, add this:
User #|createdByUserNum|match
- save and go to the Inventory section. You should now see an "advanced search >>" link.
- click it and use the "User #" field to show results just for that user number.
You can see which user number is assigned to each user in the User Accounts section. Just mouse over "modify" for a user and the url in the status bar will include the users num.
I will pass this along as a feature request so that searching by createdBy.Fullname would be possible.
If anyone else has any other ideas/suggestions to accomplish the same thing, please post.
Cheers,
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/