Create List Method to Search by Field

4 views
Skip to first unread message

rnrstar

unread,
Sep 8, 2010, 5:04:38 PM9/8/10
to RISE
I'm trying to create a method that allows me to search a table by a
specific field. When I create a new List method I notice that in the
possible arguments all I have are data types rather than the fields
from my table which only appear in the possible return values.

As I understand it, that's where the "Filter by (where)" field comes
into play but I'm unsure about the syntax. If for example I drag "int"
from the left to the right under Possible arguments-Arguments and then
drag it down to the "Filter By" area and then drag the field I want to
search on from the "Return Values" pane I get the following:

@out.UsersID=@in.arg_Int

Is that correct or do I need quotes anywhere?...?

Also, under "Order by" can I put something like,

fieldname DESC

Once again, are quotes needed?

Help or examples on the syntax for these two fields would be
appreciated.

Thanks in advance.

rnrstar

unread,
Sep 10, 2010, 2:52:21 PM9/10/10
to RISE
I figured it out...once I put

@out.txtPhoneNumber=@in.arg_String

into the Filter by it worked.



On Sep 8, 2:04 pm, rnrstar <to...@zone0ne.com> wrote:
> I'm trying to create a method that allows me to search a table by a
> specific field. When I create a new List method I notice that in the
> possible arguments all I have are data types rather than the fields
> from my table which only appear in the possible return values.
>
> As I understand it, that's where the "Filter by (where)" field comes
> into play but I'm unsure about the syntax. If for example I drag "int"
> from the left to the right under Possible arguments-Arguments and then
> drag it down to the "Filter By" area and then drag the field I want to
> search on from the "Return Values" pane I get the following:
>
> @out.Users...@in.arg_Int
Reply all
Reply to author
Forward
0 new messages