Finder based on contains ""?

[dblackwe]

Because of client naming and multitendency rules, they silo SVMs, an SVM is named $cluster[AB]_$BU.  The AB is what node it lives on.  I am trying to do a filter by cluster and node name, but I can't figure out a way to do this.  I have $cluster, and I have $BU, determined through replace functions because of how they want that presented to end users.  However I don't have a way to find out if its on A or on B.  Any suggestions?

[dblackwe]

I almost have this.

I have custom filters now to do where blah like '%${variable}%', but in this case it doesn't work.

getVISANode(vserver1)

To find the name of the node I look for which node contians A vs which node contains B, the vserver if its supposed to be on node A has nameA_bu and B_ if its on B.  I have a function that looks for the A_ or B_ and returns just A or B (that is getVISANode(str)).  I have defined vserver1 in another step in this workflow, but I can't seem to use it inside my fucntion.  Any help would be very appricated.

[sinhaa]

@dblackwe

Provide your workflow dar file. Designer solutions are very tedious to work on with just words at your disposal.

sinhaa

[dblackwe · Accepted solution]

Sorry I wasn't able to explain myself well.  I actually solved this with a custome filter.

SELECT
vserver.name,
vserver.type,
vserver.uuid,
vserver.name_service_switch,
vserver.nis_domain,
vserver.language,
vserver.comment,
vserver.admin_state,
vserver.nfs_allowed,
vserver.cifs_allowed,
vserver.fcp_allowed,
vserver.iscsi_allowed,
cluster.primary_address AS 'cluster.primary_address'
FROM
cm_storage.vserver,
cm_storage.cluster
WHERE
cluster.id = vserver.cluster_id
AND vserver.name like '%${vserver_name}%'
AND (
cluster.name = '${cluster_name}'
OR cluster.primary_address='${cluster_name}'
)

and those variables are filled in in the search with functions