Method:Classic General Q&A

Re: Typed in Selection List example needed

Method_Russell — Wed, 21 May 2014 13:02:07 GMT

Hi Robert,

Yes, the Build Selection List filter is equivalent to a SQL IN clause, and that's how it's parsed. There are other parts of Method that can be closer to pure SQL, such as filtering tables, grids, and reports.

For more information, please see this article: http://www.methodintegration.com/method/kb.aspx?folder=methodcrm&article=Using-filter-with-script&id=272 and this webinar: https://www.youtube.com/watch?v=D1D6QWdXG0I&list=PLG5Qmoh21vN4Od1mRtrDoY6NyPabWApjx

-Russell

Re: Typed in Selection List example needed

robert.cowart — Tue, 20 May 2014 19:40:15 GMT

I will try this. Is this a SQL IN () clause? Are you parsing the commas into ',' and adding ( and ) on the ends? That must be what you are doing because in another filter I have the following working fine: RecordID > 0 AND Class IN ('<City>','_National'). "Build Selection List" must be editing my list thusly.

Re: Typed in Selection List example needed

Method_Russell — Tue, 20 May 2014 19:09:05 GMT

Hi Robert,

You're almost there. You can remove the apostrophes from your Type In list, the list should be in comma separated format instead of SQL format. For example:

karen.a,valerie.c,robert.c,peter.i

-Russell

Typed in Selection List example needed

robert.cowart — Tue, 20 May 2014 17:08:49 GMT

I need to unlock a screen field only for specific users by name. I have a conditional statement with Build Selection List based on Session User Name. I use Type In with the list of users I want to have the condition return true for. I have a list of users, such as: 'karen.a','valerie.c','robert.c','peter.i' in the Value 2 input area to the right of Type In. I know that the Session User Name is correct (used Show Message) but the list is not properly executing the SQL "IN" statement to evaluate the Selection List expression.

Can someone please give me an example of a working selection list? There isn't a single example of a manually typed in list on the Method site or forum. I tried putting my list inside a () but that didn't fix it.

Help!