Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Tuesday, November 26, 2024 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Scripting & Customization | New ThreadView:  Search:  
 Author  Thread: Custom Mainview Advanced Lookup....anyone ever done this?
Tom Smith
Posts: 13
 
Custom Mainview Advanced Lookup....anyone ever done this?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 05 Jul 06 4:21 PM
fiogf49gjkf0d
Any tips/ideas on how to go about doing this?
[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: Custom Mainview Advanced Lookup....anyone ever done this?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Jul 06 2:29 AM
fiogf49gjkf0d
Did you mean QuickFind ?
Yes, it's dead easy - create a new data form (bound to the MV primary table)
Add the fields you want to the form - ensure the form size is sized so that it only takes up min amount of room
Save the form and then manage lookups. Find your table and pick the lookup - edit that and set the View Name to the form you created earlier
Open your main view and on the properties select the QuickFindLookup and then select the lookup you created earlier. Save and release

Now, when you select QuickFind - it will show your new form - and you can fill in as much as you need - and SLX will automatically build the query
[Reply][Quote]
Tom Smith
Posts: 13
 
Re: Custom Mainview Advanced Lookup....anyone ever done this?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Jul 06 8:16 AM
fiogf49gjkf0d
Thanks Mike, I will try that!

Update....
===============================
I really meant the advanced lookup, like when you go Lookup ==> Accounts ==> Advanced Lookup
In old SalesLogix (5.), it was called the QBE view. In fact, the current SLX version still uses legacy views for the Contact, Account, Opp Advanced Lookups.

Now that we're creating custom mainviews, I was wondering if there is an SLX sanctioned way to do Custom advanced lookups. I could build a custom view that generates the SQL, or the resulting IDs, but that is a cumbersome process and not very flexible.

The way you suggested works only as a QuickFind (I think), and I might be able to live with it - still pretty slick, but I couldn't get it to work when called from Code, like

application.BasicFunctions.LookupItemWithConditionByID "Property:PropertyID", false, "", "", "", ""

OR

application.basicfunctions.DoInvoke "Lookup", "Property:PropertyID"
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/26/2024 7:30:14 AM