AnsweredAssumed Answered

Scripting find of text field with range of text

Question asked by asvaaland on Nov 14, 2018
Latest reply on Nov 14, 2018 by asvaaland

Hi.

 

I have a field Arcticle Number that some contains just numbers and some letters and numbers.

 

I am trying to build a search form with from asset - to asset using global fields and a calculation to ge the results from - to assets and all the records inbetween the start and end parameters.

 

My strugle is the assets that contain text does not show up. If I search for assets containing only numbers the searhc works fine and I get all the records in the range. Now when I do this with assets that contain or start with text I get no records found.

 

Using calculated field:

 

G_FromAsset  &  ".. or ..."  & G_ToAsset

 

 

Any comments on how I could get this search to work would be kindly appreciated.

 

Many thanks

Stian V

Outcomes