Here you go i created a small def file for you load the users with the
users.arx file and let me know if you need any more information.
Regards,
Roney Samuel Varghese
On 6/25/07, brooksm <[EMAIL PROTECTED]> wrote:
Roney,
$Requester Name+$ LIKE ( 'Full Name' + "%" ) is one that I tried and
couldn't get the right behavior. I double checked the QBE Match field on
the
'Requester Name+' field and it is set to Leading.
Just so you know, using the solution above still gives me the same result
as
$Requester Name+$ = 'Full Name'
Any other ideas?
Thanks
Brooks
Roney Samuel Varghese wrote:
>
> Dear Brooks,
>
> The first set field should contain Requester Name+ LIKE 'Full Name' +
"%"
> if
> there is a match then use first matching request or else display a list.
> Hope this helps
>
> Also the requester name field should have a leading database search.
>
> Regards,
> Roney Samuel Varghese
>
>
> On 6/25/07, brooksm <[EMAIL PROTECTED]> wrote:
>>
>> Hi-
>> I'm trying to create the same kind of workflow that occurs on the
>> Requester
>> Name+ field in Help Desk (but without the AL Guides).
>> I've created a new form and I'd like to be able to enter the first few
>> characters of the Requester's Name and hit 'Enter' to pull up a list of
>> matches or populate the Requester Name field with the matching value.
>> I've
>> got the Active link set up fine, but I can't seem to get the 'Set Field
>> If'
>> syntax right. I can get $Requester Name+$ = 'Full Name' to work, but my
>> users really need to be able to do a LIKE search. Can someone help me
>> with
>> the correct syntax?
>>
>> Thanks
>> Brooks
>> --
>> View this message in context:
>>
http://www.nabble.com/Help-with-Active-Link-Set-Fields-Search-Qualification.-tf3979186.html#a11296302
>> Sent from the ARS (Action Request System) mailing list archive at
>> Nabble.com.
>>
>>
>>
_______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgARSlist:"Where
>> the Answers Are"
>>
>
>
_______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
>
--
View this message in context:
http://www.nabble.com/Help-with-Active-Link-Set-Fields-Search-Qualification.-tf3979186.html#a11296727
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
char-set: UTF-8
#
# File exported Mon Jun 25 17:47:07 2007
#
begin schema
name : Test:Requester
core-version : 2
upgrade-version: 0
num-fields : 9
timestamp : 1182815194
owner : Demo
last-changed : Demo
default-vui : Default Admin View
num-vuis : 1
export-version : 10
schema-type : 1
next-field-id : 536870912
archive : 0\0\0
arch-time : 0\0\0\0
arch-from :
audit : 0\0\0\
vui {
id : 536870912
name : Default Admin View
label : Default Admin View
timestamp : 1182814742
vui-locale :
vui-type : 1
owner : Demo
last-changed : Demo
display-prop : 1\20\4\18\Default Admin View\
}
field {
id : 1
name : Request ID
datatype : 4
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814743
owner : Demo
last-changed : Demo
maxlength : 15
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 0\1
permission : 3\1
permission : 4\1
display-instance : 536870912\16\20\4\10\Request
ID\61\40\18\60\40\1\3\41\2\1012\2500\19799\4900\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483640\231\6\0\143\40\4294967295\21\41\2\0\&
display-instance :
400\6862\2400\151\41\2\7425\0\18787\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\170\40\0\
}
field {
id : 2
name : Submitter
datatype : 4
fieldtype : 1
create-mode : 1
option : 1
timestamp : 1182815194
owner : Demo
last-changed : Demo
maxlength : 254
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 3\1
permission : 4\1
display-instance : 536870912\16\20\4\16\Requester Name
+\61\40\30\60\40\1\3\41\2\1012\5000\34874\7200\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483641\231\6\0\143\40\4294967295\21\4&
display-instance :
1\2\0\400\11925\2200\151\41\2\12487\0\30937\2100\65\41\2\0\0\0\0\66\41\2\31500\0\33862\2100\170\40\0\
}
field {
id : 3
name : Create Date
datatype : 7
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814743
owner : Demo
last-changed : Demo
permission : 3\1
permission : 4\1
display-instance : 536870912\16\20\4\11\Create
Date\61\40\23\60\40\1\3\41\2\1012\7500\26212\9800\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483642\231\6\0\143\40\4294967295\170\40\0\&
display-instance :
21\41\2\0\400\7200\2300\151\41\2\7762\0\22162\2100\65\41\2\0\0\0\0\66\41\2\22837\0\25199\2100\
}
field {
id : 4
name : Assigned To
datatype : 4
fieldtype : 1
create-mode : 2
option : 2
timestamp : 1182814743
owner : Demo
last-changed : Demo
maxlength : 254
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 4\1
display-instance : 536870912\16\20\4\11\Assigned
To\61\40\30\60\40\1\3\41\2\1012\10000\29137\12100\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483643\231\6\0\143\40\4294967295\21\41\2&
display-instance :
\0\400\6637\2100\151\41\2\7200\0\25200\2100\65\41\2\0\0\0\0\66\41\2\25762\0\28124\2100\170\40\0\
}
field {
id : 5
name : Last Modified By
datatype : 4
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814743
owner : Demo
last-changed : Demo
maxlength : 254
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 4\1
display-instance : 536870912\16\20\4\16\Last Modified
By\61\40\33\60\40\1\3\41\2\1012\12500\34199\14800\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483644\231\6\0\143\40\4294967295\21&
display-instance :
\41\2\0\400\9562\2300\151\41\2\10125\0\30150\2100\65\41\2\0\0\0\0\66\41\2\30825\0\33187\2100\170\40\0\
}
field {
id : 6
name : Modified Date
datatype : 7
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814743
owner : Demo
last-changed : Demo
permission : 4\1
display-instance : 536870912\16\20\4\13\Modified
Date\61\40\23\60\40\1\3\41\2\1012\15000\26999\17300\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483645\231\6\0\143\40\4294967295\170\4&
display-instance :
0\0\21\41\2\0\400\8212\2300\151\41\2\8775\0\22950\2100\65\41\2\0\0\0\0\66\41\2\23625\0\25987\2100\
}
field {
id : 7
name : Status
datatype : 6
fieldtype : 1
create-mode : 2
option : 1
timestamp : 1182814743
owner : Demo
last-changed : Demo
enum-value : New
enum-value : Assigned
enum-value : Fixed
enum-value : Rejected
enum-value : Closed
default : 0
permission : 3\1
permission : 4\2
display-instance :
536870912\18\20\4\6\Status\64\6\1\61\40\0\60\40\1\3\41\2\1012\17500\35887\19400\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483646\231\6\0\230\4\46\5\0\New\1\Assign&
display-instance :
ed\2\Fixed\3\Rejected\4\Closed\143\40\4294967295\21\41\2\0\400\4162\1900\151\41\2\4725\400\34875\1800\65\41\2\0\0\0\0\66\41\2\0\0\0\0\170\40\0\
}
field {
id : 8
name : Short Description
datatype : 4
fieldtype : 1
create-mode : 1
option : 1
timestamp : 1182814743
owner : Demo
last-changed : Demo
maxlength : 254
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 3\1
permission : 4\1
display-instance : 536870912\16\20\4\17\Short
Description\61\40\50\60\40\1\3\41\2\1012\20000\45224\22100\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483647\231\6\0\143\40\4294967295\2&
display-instance :
1\41\2\0\400\11137\2100\151\41\2\11700\0\41287\2100\65\41\2\0\0\0\0\66\41\2\41850\0\44212\2100\170\40\0\
}
field {
id : 15
name : Status History
datatype : 4
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814742
owner : Demo
last-changed : Demo
permission : 3\1
permission : 4\1
}
end
begin schema
name : Test:Users
core-version : 2
upgrade-version: 0
num-fields : 9
timestamp : 1182814633
owner : Demo
last-changed : Demo
default-vui : Default Admin View
num-vuis : 1
export-version : 10
schema-type : 1
next-field-id : 536870912
archive : 0\0\0
arch-time : 0\0\0\0
arch-from :
audit : 0\0\0\
vui {
id : 536870912
name : Default Admin View
label : Default Admin View
timestamp : 1182814631
vui-locale :
vui-type : 1
owner : Demo
last-changed : Demo
display-prop : 1\20\4\18\Default Admin View\
}
field {
id : 1
name : Request ID
datatype : 4
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814632
owner : Demo
last-changed : Demo
maxlength : 15
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 0\1
permission : 3\1
permission : 4\1
display-instance : 536870912\16\20\4\10\Request
ID\61\40\18\60\40\1\3\41\2\1012\2500\19799\4900\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483640\231\6\0\143\40\4294967295\21\41\2\0\&
display-instance :
400\6862\2400\151\41\2\7425\0\18787\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\170\40\0\
}
field {
id : 2
name : Submitter
datatype : 4
fieldtype : 1
create-mode : 1
option : 1
timestamp : 1182814633
owner : Demo
last-changed : Demo
maxlength : 254
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 3\1
permission : 4\1
display-instance :
536870912\16\20\4\9\Submitter\61\40\30\60\40\1\3\41\2\1012\5000\29024\7200\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483641\231\6\0\143\40\4294967295\21\41\2\0\40&
display-instance :
0\6075\2200\151\41\2\6637\0\25087\2100\65\41\2\0\0\0\0\66\41\2\25650\0\28012\2100\170\40\0\
}
field {
id : 3
name : Create Date
datatype : 7
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814632
owner : Demo
last-changed : Demo
permission : 3\1
permission : 4\1
display-instance : 536870912\16\20\4\11\Create
Date\61\40\23\60\40\1\3\41\2\1012\7500\26212\9800\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483642\231\6\0\143\40\4294967295\170\40\0\&
display-instance :
21\41\2\0\400\7200\2300\151\41\2\7762\0\22162\2100\65\41\2\0\0\0\0\66\41\2\22837\0\25199\2100\
}
field {
id : 4
name : Assigned To
datatype : 4
fieldtype : 1
create-mode : 2
option : 2
timestamp : 1182814632
owner : Demo
last-changed : Demo
maxlength : 254
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 4\1
display-instance : 536870912\16\20\4\11\Assigned
To\61\40\30\60\40\1\3\41\2\1012\10000\29137\12100\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483643\231\6\0\143\40\4294967295\21\41\2&
display-instance :
\0\400\6637\2100\151\41\2\7200\0\25200\2100\65\41\2\0\0\0\0\66\41\2\25762\0\28124\2100\170\40\0\
}
field {
id : 5
name : Last Modified By
datatype : 4
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814632
owner : Demo
last-changed : Demo
maxlength : 254
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 4\1
display-instance : 536870912\16\20\4\16\Last Modified
By\61\40\33\60\40\1\3\41\2\1012\12500\34199\14800\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483644\231\6\0\143\40\4294967295\21&
display-instance :
\41\2\0\400\9562\2300\151\41\2\10125\0\30150\2100\65\41\2\0\0\0\0\66\41\2\30825\0\33187\2100\170\40\0\
}
field {
id : 6
name : Modified Date
datatype : 7
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814632
owner : Demo
last-changed : Demo
permission : 4\1
display-instance : 536870912\16\20\4\13\Modified
Date\61\40\23\60\40\1\3\41\2\1012\15000\26999\17300\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483645\231\6\0\143\40\4294967295\170\4&
display-instance :
0\0\21\41\2\0\400\8212\2300\151\41\2\8775\0\22950\2100\65\41\2\0\0\0\0\66\41\2\23625\0\25987\2100\
}
field {
id : 7
name : Status
datatype : 6
fieldtype : 1
create-mode : 2
option : 1
timestamp : 1182814633
owner : Demo
last-changed : Demo
enum-value : New
enum-value : Assigned
enum-value : Fixed
enum-value : Rejected
enum-value : Closed
default : 0
permission : 3\1
permission : 4\2
display-instance :
536870912\18\20\4\6\Status\64\6\1\61\40\0\60\40\1\3\41\2\1012\17500\35887\19400\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483646\231\6\0\230\4\46\5\0\New\1\Assign&
display-instance :
ed\2\Fixed\3\Rejected\4\Closed\143\40\4294967295\21\41\2\0\400\4162\1900\151\41\2\4725\400\34875\1800\65\41\2\0\0\0\0\66\41\2\0\0\0\0\170\40\0\
}
field {
id : 8
name : Short Description
datatype : 4
fieldtype : 1
create-mode : 1
option : 1
timestamp : 1182814633
owner : Demo
last-changed : Demo
maxlength : 254
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 3\1
permission : 4\1
display-instance : 536870912\16\20\4\17\Short
Description\61\40\50\60\40\1\3\41\2\1012\20000\45224\22100\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483647\231\6\0\143\40\4294967295\2&
display-instance :
1\41\2\0\400\11137\2100\151\41\2\11700\0\41287\2100\65\41\2\0\0\0\0\66\41\2\41850\0\44212\2100\170\40\0\
}
field {
id : 15
name : Status History
datatype : 4
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1182814631
owner : Demo
last-changed : Demo
permission : 3\1
permission : 4\1
}
end
char-set: UTF-8
#
# File exported Mon Jun 25 17:47:15 2007
#
begin active link
name : TestReq:AddName
timestamp : 1182815083
export-version : 10
owner : Demo
last-changed : Demo
actlink-order : 0
wk-conn-type : 1
schema-name : Test:Requester
actlink-mask : 2
actlink-focus : 2
enable : 1
actlink-query : 4\6\1\2\2\0\
action {
set-field : [EMAIL PROTECTED]:Users\1\2\4\7\1\2\3\1\99\2\2\4\1\%\1\4\
}
object-prop : 2\60016\4\1\0\60017\4\1\0\
end
CHAR-SET windows-1252
SCHEMA "Test:Users"
FIELDS "Assigned To" "Create Date" "Last Modified By" "Modified Date" "Request
ID" "Short Description" "Status" "Status-History" "Submitter"
FLD-ID 4 3 5 6 1 8 7 15 2
DTYPES CHAR TIME CHAR TIME CHAR CHAR ENUM CHAR CHAR
DATA "" 1182814668 "Demo" 1182814668 "000000000000001" "1st user Entrry" 0
"1182814668Demo" "Roney Varghese"
DATA "" 1182814691 "Demo" 1182814691 "000000000000002" "2nd user Entry" 0
"1182814691Demo" "Ron Edwards"
DATA "" 1182814709 "Demo" 1182814709 "000000000000003" "3td Entry" 0
"1182814709Demo" "Ronny Rebello"
DATA "" 1182814722 "Demo" 1182814722 "000000000000004" "4th Entry" 0
"1182814722Demo" "Garron Christie"
