• Locked Locked
  • Replies 0 replies
  • Subscribers 4 subscribers
  • Views 4143 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - Filtering on a Foreign property

Archive User
Offline

markW - Sunday, May 13, 2007 4:03 PM:

I have multiple scenarios where this applies, bu this is the first I encountered.  I would like to limit my return result to only the list I am interested in.  In this case I don't want dept mangers, only dept categories (see bold and italics below).  My Javascript query is below.  It is quite sensible that I recieved both managers and categories since they are both filtered by the Department list I created.  I suspect there is something I could add in the way of AML or Javascript to limit the response to only categories (or vice versa if someday needed).  However, I don't know how to build the query for a property which then has keyed name inside, as below.

<source_id keyed_name="Idea_Department_Managers
" type="List
">E1523A32C3D44949B26BF44965C407EC
</source_id>

Any suggestions / ideas ?

 ----------

var qryDist = new Item("Idea_Asses_Distribution_P2","get");
qryDist.setProperty("idea_assess_distribution_p2_name","3rd Idea","eq");
dept = qryDist.apply();

var filtvalItem = new Item("Filter Value","get");
filtvalItem.setProperty("filter",dept.getProperty("idea_assess_distribution_p2_dept"),"eq");
result = filtvalItem.apply();
writeResults(result.dom.xml);

--------------------


-<Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema">
-<Body>
-<Result>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="FE5E2C48E60E467188B06EFC399AD5E9
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Department_Managers
" type="List
">E1523A32C3D44949B26BF44965C407EC
</source_id>
<major_rev>A
</major_rev>
<label>Fredrica Finance
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Fredica Finance
" type="Filter Value
">FE5E2C48E60E467188B06EFC399AD5E9
</config_id>
<sort_order>3
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:09:13 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:09:13 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Fredica Finance
" type="Filter Value
">FE5E2C48E60E467188B06EFC399AD5E9
</id>
<filter>Finance
</filter>
<keyed_name>Fredica Finance
</keyed_name>
<behavior>float
</behavior>
<value>Fredica Finance
</value>
</Item>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="A8DF50EA8325446588B76FAB099541DA
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Department_Managers
" type="List
">E1523A32C3D44949B26BF44965C407EC
</source_id>
<major_rev>A
</major_rev>
<label>Freddie Finance
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Freddie Finance
" type="Filter Value
">A8DF50EA8325446588B76FAB099541DA
</config_id>
<sort_order>4
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:09:13 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:09:13 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Freddie Finance
" type="Filter Value
">A8DF50EA8325446588B76FAB099541DA
</id>
<filter>Finance
</filter>
<keyed_name>Freddie Finance
</keyed_name>
<behavior>float
</behavior>
<value>Freddie Finance
</value>
</Item>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="657D750C35F241FFAF6B841493EAB392
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Categories_P2
" type="List
">AABC5EA78F664E82A122BC65DE84DB7E
</source_id>
<major_rev>A
</major_rev>
<label>Budget Analysis
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Budget Analysis
" type="Filter Value
">657D750C35F241FFAF6B841493EAB392
</config_id>
<sort_order>14
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:43:54 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:43:54 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Budget Analysis
" type="Filter Value
">657D750C35F241FFAF6B841493EAB392
</id>
<filter>Finance
</filter>
<keyed_name>Budget Analysis
</keyed_name>
<behavior>float
</behavior>
<value>Budget Analysis
</value>
</Item>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="89932508F2064A30B5E29DF4B3DFE3D7
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Categories_P2
" type="List
">AABC5EA78F664E82A122BC65DE84DB7E
</source_id>
<major_rev>A
</major_rev>
<label>Purchase Order Rqmts
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Purchase Order Rqmts
" type="Filter Value
">89932508F2064A30B5E29DF4B3DFE3D7
</config_id>
<sort_order>15
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:43:54 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:43:54 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Purchase Order Rqmts
" type="Filter Value
">89932508F2064A30B5E29DF4B3DFE3D7
</id>
<filter>Finance
</filter>
<keyed_name>Purchase Order Rqmts
</keyed_name>
<behavior>float
</behavior>
<value>Purchase Order Rqmts
</value>
</Item>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="918B082BE38446278B916EF69136E75E
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Categories_P2
" type="List
">AABC5EA78F664E82A122BC65DE84DB7E
</source_id>
<major_rev>A
</major_rev>
<label>Funding Options
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Funding Options
" type="Filter Value
">918B082BE38446278B916EF69136E75E
</config_id>
<sort_order>16
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:43:54 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:43:54 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Funding Options
" type="Filter Value
">918B082BE38446278B916EF69136E75E
</id>
<filter>Finance
</filter>
<keyed_name>Funding Options
</keyed_name>
<behavior>float
</behavior>
<value>Funding Options
</value>
</Item>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="3F2EFBD64A014FE4B8F6ABC20DEA76E3
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Categories_P2
" type="List
">AABC5EA78F664E82A122BC65DE84DB7E
</source_id>
<major_rev>A
</major_rev>
<label>Revenue Collection Options
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Revenue Collection Options
" type="Filter Value
">3F2EFBD64A014FE4B8F6ABC20DEA76E3
</config_id>
<sort_order>17
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:43:54 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:43:54 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Revenue Collection Options
" type="Filter Value
">3F2EFBD64A014FE4B8F6ABC20DEA76E3
</id>
<filter>Finance
</filter>
<keyed_name>Revenue Collection Options
</keyed_name>
<behavior>float
</behavior>
<value>Revenue Collection Options
</value>
</Item>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="768B75D8C20649B6A46570B9498871E3
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Categories_P2
" type="List
">AABC5EA78F664E82A122BC65DE84DB7E
</source_id>
<major_rev>A
</major_rev>
<label>Revenue Scheduling
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Revenue Scheduling
" type="Filter Value
">768B75D8C20649B6A46570B9498871E3
</config_id>
<sort_order>18
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:43:54 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:43:54 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Revenue Scheduling
" type="Filter Value
">768B75D8C20649B6A46570B9498871E3
</id>
<filter>Finance
</filter>
<keyed_name>Revenue Scheduling
</keyed_name>
<behavior>float
</behavior>
<value>Revenue Scheduling
</value>
</Item>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="9D2BC1FDC0AB46A8B4021733429B467A
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Categories_P2
" type="List
">AABC5EA78F664E82A122BC65DE84DB7E
</source_id>
<major_rev>A
</major_rev>
<label>Finance Overall Rating
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Finance Overall Rating
" type="Filter Value
">9D2BC1FDC0AB46A8B4021733429B467A
</config_id>
<sort_order>19
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:43:54 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:43:54 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Finance Overall Rating
" type="Filter Value
">9D2BC1FDC0AB46A8B4021733429B467A
</id>
<filter>Finance
</filter>
<keyed_name>Finance Overall Rating
</keyed_name>
<behavior>float
</behavior>
<value>Finance Overall Rating
</value>
</Item>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="1E18803631BA4D00BADADBC16E6387CF
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Categories_P2
" type="List
">AABC5EA78F664E82A122BC65DE84DB7E
</source_id>
<major_rev>A
</major_rev>
<label>Finance Recommendations
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Finance Recommendations
" type="Filter Value
">1E18803631BA4D00BADADBC16E6387CF
</config_id>
<sort_order>20
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:43:54 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:43:54 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Finance Recommendations
" type="Filter Value
">1E18803631BA4D00BADADBC16E6387CF
</id>
<filter>Finance
</filter>
<keyed_name>Finance Recommendations
</keyed_name>
<behavior>float
</behavior>
<value>Finance Recommendations
</value>
</Item>
-<Item type="Filter Value
" typeId="BCC8053D365143A18B033850EFE56F3C
" id="3B7323BF731E46CC82043E750ADBC2FB
" page="1
" pagemax="1
" itemmax="10
">
<is_current>1
</is_current>
<generation>1
</generation>
<source_id keyed_name="Idea_Categories_P2
" type="List
">AABC5EA78F664E82A122BC65DE84DB7E
</source_id>
<major_rev>A
</major_rev>
<label>Finance Rejection Warning
</label>
<created_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</created_by_id>
<config_id keyed_name="Finance Rejection Warning
" type="Filter Value
">3B7323BF731E46CC82043E750ADBC2FB
</config_id>
<sort_order>21
</sort_order>
<new_version>0
</new_version>
<permission_id keyed_name="List
" type="Permission
">1224D81E8DBD4B08B78404E769004EFF
</permission_id>
<modified_by_id keyed_name="Innovator Admin
" type="User
">30B991F927274FA3829655F50C99472E
</modified_by_id>
<modified_on>05/08/2007 04:43:54 PM
</modified_on>
<is_released>0
</is_released>
<created_on>05/08/2007 04:43:54 PM
</created_on>
<classification>/*
</classification>
<not_lockable>0
</not_lockable>
<id keyed_name="Finance Rejection Warning
" type="Filter Value
">3B7323BF731E46CC82043E750ADBC2FB
</id>
<filter>Finance
</filter>
<keyed_name>Finance Rejection Warning
</keyed_name>
<behavior>float
</behavior>
<value>Finance Rejection Warning
</value>
</Item>
</Result>
</Body>
</Envelope>

 

 


RobMcAveney - Sunday, May 13, 2007 8:56 PM:

Hi Mark -

Properties in AML that contain a 32 character GUID and have keyed_name and type attributes are know as item properties, meaning they point to another item.  These properties can be "expanded" to have not just the id, but the full item.  So in your example, this:

<source_id keyed_name="Idea_Categories_P2" type="List">AABC5EA78F664E82A122BC65DE84DB7E</source_id>

can be expanded to this:

<source_id keyed_name="Idea_Categories_P2" type="List">
  <Item type="List" id="AABC5EA78F664E82A122BC65DE84DB7E">
    ...
  </Item>
</source_id>

 Your query would then look something like this in AML:

<Item type="Filter Value" action="get">
  <filter>Finance</filter>
  <source_id>
    <Item type="List" action="get">
      <name>Idea_Department_Managers</name>
    </Item>
  </source_id>
</Item>

In Javascript, you would do this to get the same results: 

var qryDist = new Item("Idea_Asses_Distribution_P2","get");
qryDist.setProperty("idea_assess_distribution_p2_name","3rd Idea","eq");
dept = qryDist.apply();

var filtvalItem = new Item("Filter Value","get");
filtvalItem.setProperty("filter",dept.getProperty("idea_assess_distribution_p2_dept"),"eq");
var listItem = new Item("List","get");
listItem.setProperty("Idea_Department_Managers");
filtervalItem.setPropertyItem("source_id",listItem);
result = filtvalItem.apply();
writeResults(result.dom.xml);

The above should work just fine and is an acceptable way of doing things.  However, since this is a relationship (with List as the parent and Filter Value as the child), the more common way to do this would be from the top down, like this in AML:

<Item type="List" action="get">
  <name>Idea_Department_Managers</name>
  <Relationships>
    <Item type="Filter Value" action="get">
      <filter>Finance</filter>
    </Item>
  </Relationships>
</Item>

 and like this in Javascript :

var qryDist = new Item("Idea_Asses_Distribution_P2","get");
qryDist.setProperty("idea_assess_distribution_p2_name","3rd Idea","eq");
dept = qryDist.apply();

var listItem = new Item("List","get");
listItem.setProperty("Idea_Department_Managers");
var filtvalItem = new Item("Filter Value","get");
filtvalItem.setProperty("filter",dept.getProperty("idea_assess_distribution_p2_dept"),"eq");
listItem.addRelationship(filtvalItem);
result = listlItem.apply();
var filtvalResult = result.getRelationships();

I hope that was wasn't too much info.  Let me know if you need clarification.

Rob 


AbhishekSrivastava - Saturday, March 19, 2016 3:09 AM:

Hi Rob ,

i make a list Vendor type and filter list Vendor name and put into an item type.

Now when i select vendor type then value automatic comes in vendor name but i want if single value comes in vendor name then no need to select it just automatically select.

So is there any field event required.

Kindly help

Thank You

Abhishek Srivastava

 

Copyright © 2025 Aras. All rights reserved.