Thank you Harshpatel! This seems to get me closer, but not sure this will work for what I'm trying to accomplish.
Lets say these are my three xml entries that I wish to search against in my data (Looks like I can't use XML tags in my post, but imagine the blow in xml format)
Data
Protocol SFTP /Protocol
UserName sftpUser /Username
Password 12345 /Password
Port 22 /Port
AuthMethod Password /AuthMethod
Filename myFilename /Filename
/Data
Data
Protocol HTTP /Protocol
RemoteURL MyURL /RemoteURL
RemotePort 80 /RemotePort
SSL False /SSL
/Data
Data
Protocol FTP /Protocol
UserName ftpUser /Username
Password 12345 /Password
Port 22 /Port
TransferMode Binary /TransferMode
Directory myDirectory /Directory
Filename myFilename /Filename
/Data
I have a protocol dropDown menu defined that has a list of protocols, using the token $dropDownProtocol$. So on my intial search, I can run a search: "search Protocol = $dropDownProtocol$". This will pull up all results for the given protocol selected from the drop down. But at this point, I wish to created a custom search for each of the protocols available in my dropdown. This was one of the reasons I was trying to nest searches inside of the case statement, basically saying if the value is "SFTP", then run a search on Username/Password/Port/AuthMethod/Filename, if it's HTTP, run a search on RemoteURL/RemotePort/SSL. In reality, there are dozens of nodes in each data tag, all unique to the given protocol. I can't use wildcards because there are many extraneous fields I do not wish to add to my table. I also wish to order the table in a specific way.
Is there a way to create multiple strings based on conditional logic, and only apply the search I need based on the condition evaluating as True? Or, as an alternative, is there a way in the case statment I could build a searchString variable that contains an entire search string to be executed?
Thanks
... View more