This topic is locked

Advanced Search

3/4/2009 6:24:19 PM
ASPRunnerPro General questions
W
wisdom2009 author

Team,
Again thank for this forum that help us and thank For Asprunnerpro I love this application.
Ok, I have a form where users can add information and the form has field that depend on other field, example, I have field IssieType depend on Team and Team depend on agentName, when a user login the agentname automatically populate and also the team and a dropdown menu for Issue type and Team because agent can be in different team.
My agent is on the advanced search when I want search only by team and Issue type, when I open the Advance search page, the team on Issue Type field are in dropdown menu, when I changed it modify my Adding page.
how can keep the dropdown menu on adding page and change it as text field on advanced search, know when I do it does agent the adding page.
Thanks

J
Jane 3/5/2009

Hi,
I recommend you to create aliases in your SQL query on the Edit SQL query tab.

Here is a sample:

select field1,

field1 as field1_search,

field2,

field2 as field2_search,

...

from TableName


Then check off field1_search and field2_search on the advanced search only on theChoose fields tab and set up these fields as text on the "Edit as" settings dialog on the Visual Editor tab.

W
wisdom2009 author 3/5/2009

Thanks Jane, i will give it a try.
Thank you again