Hi,
I am using FLS 11.
We do have an option to search text from database to search a particular text on invoice.
Query is can someone tell me how to use text captured in another field?
Say, for eg. I have 2 elements
1: characterString (which has strings found on invoice in specified region)
2: StaticText (which will use the above strings found and search in DB and return the value)
I have to use value of Character String element into static string element, and that value will be searched in DB?
To amke it more clear :
Scenario is : characterstring captures two strings from invoice : "string1" and "string2"
then these strings I would like to serach in DB and get proper name for it. So my query in static text would be :
select strings from tablename where strings like 'string1%' or strings like 'string2%' OR whatever condition.
So, in FLS what to write after like statement?
Let me know if I am clear else I can provide you more details.
Would appreciate your efforts!
Thanks,
Kalyani
I am using FLS 11.
We do have an option to search text from database to search a particular text on invoice.
Query is can someone tell me how to use text captured in another field?
Say, for eg. I have 2 elements
1: characterString (which has strings found on invoice in specified region)
2: StaticText (which will use the above strings found and search in DB and return the value)
I have to use value of Character String element into static string element, and that value will be searched in DB?
To amke it more clear :
Scenario is : characterstring captures two strings from invoice : "string1" and "string2"
then these strings I would like to serach in DB and get proper name for it. So my query in static text would be :
select strings from tablename where strings like 'string1%' or strings like 'string2%' OR whatever condition.
So, in FLS what to write after like statement?
Let me know if I am clear else I can provide you more details.
Would appreciate your efforts!
Thanks,
Kalyani
Comments
1 comment
You can get the value of an element by using Value, for example:
string test = elementname.Value;
Please sign in to leave a comment.