Method Community

Im trying to get  So No from below table witch has the serial numbers seperated with space if it has more than one.

can anyone tell me how can i use 'Like'  or  'content' Operators  and retrive the SO NO

Hi There Kumara,

Judging from the way youve copied the Data here, Im going to assume you have the data presented in a grid, which is great! It helps us make this one process a little more efficiently.

A few questions for you; First, are all the individual Serial Numbers unique? specifically, when you search for a serial number, are you Always expecting only one result? Second, when querying the table, will you or your user always know the entire Serial Number? or just a portion of it?

Assuming that the individual Serials are Unique, and the user will always know one of the Serial Numbers in its entirety, the best way would be to utilize a Loop Through Grid Action with a Nested Conditional Statement, which checks that the 'Serial NO' field Contains a particular value. 

The Above Screenshot is an example of a button which will retrieve a value in a scenario similar to yours. The Important part here is the Conditional Statement, which checks if Value from Row - Serial Number Contains my chosen serial number. If it does, then it processes the Third Action, which in my example enters the Name of the rows Item into a value on screen. You can shoose any action for this step (ie assign to Action result etc...)

If you want me to break down any particular part of this any further, let me know and Ill be happy to help out.

Thanks Kumara.

-Ben

Hi Ben

thanks for the quick respond.

acturly this data is not in the grid controller. i just want to select it from the table stright.

this serial No are uniq if it has only one serial in one feild i can retrive it but if it has more than one with the space between i cant retive it using normal rettrive from table option. 

ex : as you can see in raw 7 serial number feild it has many serial NO if i seach with one of it ( 3594401) it need to identify that and give me the SO NO as a return.

thanks in advance

Hi Kumara,

In the case your are just querying the table directly, Most of the logic in my above post still holds true. The only major differences being that in Action 1, you would use a Start Loop through Table  action, rather than a loop through grid, and you would also need to add a 'Retrieve value from table' action somewhere after the Conditional Statement. 

Again, the most important part here is the Start Conditional Statement action. 

In my example, the 'LicenseNo' is similar in format to your SerialNo field. I added data that contains values like

• Abc123 bcb234 123abc
• xyz567 lol101 method123

If I search specifically for '123abc' using the above logic, only the first record will be returned.

-Ben