Subscribe
Accepted Solution

Natural key issue

Hey all,

 

I'm trying to get the list of exports for a given qtree using the actual_path.  I've got a query that runs fine in Toad, but doesn't run in WFA.

 

SELECT
  nfs_export.actual_path AS 'actual_path',
  export_path,
  qtree_id,
  ro_hosts,
  rw_hosts,
  root_hosts,
  vfiler.name AS 'vfiler.name',
  vfiler.ip_address,
  array.ip
FROM
  storage.nfs_export
LEFT JOIN
  storage.qtree ON qtree.id = storage.nfs_export.qtree_id
LEFT JOIN
  storage.vfiler ON vfiler.id = storage.nfs_export.vfiler_id
LEFT JOIN
  storage.array ON array.id = storage.nfs_export.array_id
WHERE
  export_path = ${qtree_path}
 

 

My error in WFA is:

 

Filter 'Filter exports by qtree' returned attributes does not contain all natural keys. Filter's returned attributes '[actual_path, export_path, ip, ip_address, qtree_id, ro_hosts, root_hosts, rw_hosts, vfiler.name]' , dictionary entry natural keys '[vfiler.name, export_path, vfiler.array.ip]'

 

I THINK I'm just missing vfiler.array.ip, but I can't figure out how to add it.  I tried adding it to vfiler.ip_address, but then I get the error:

 

Failed to execute filter 'Filter exports by qtree' with parameters: {qtree_path=/vol/rogertest_nfs_20150324142302/rogertest_000}

 

Can someone help me out?  Also, why do queries work in Toad and then fail in WFA?  Does Toad not care about the natural keys?

 

Thanks,

Roger

 

Re: Natural key issue

Nevermind..  I forgot quotes around my variable.

 

Here's the working filter.

 

SELECT
    nfs_export.actual_path AS 'actual_path',
    export_path,
    ro_hosts,
    rw_hosts,
    root_hosts,
    vfiler.name AS 'vfiler.name',
    array.ip AS 'vfiler.array.ip'
FROM
    storage.nfs_export
LEFT JOIN
    storage.qtree
        ON qtree.id = nfs_export.qtree_id
LEFT JOIN
    storage.vfiler
        ON vfiler.id = nfs_export.vfiler_id
LEFT JOIN
    storage.array
        ON array.id = nfs_export.array_id
WHERE
    export_path = "${qtree_path}"