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 - How can we search for Data in federated Property?

vasant - Tuesday, June 12, 2012 2:34 AM:

Hello Experts,

I have a Property of DataType "federated" into an Item. I can set the value of this Property using "OnAferGet" Event.
I have TOC Access for this Item and this Property is Visible into TOCView of the Item.

Now When I try to Search for particular data of fedarated Property then it does not work.
I have Tested it using "Simple Search", "Advanced Search" and "AML Search" but not getting right result.

How can I Provide Search for Property of type "federated"??

Thanks & Regards,

Vasant



Brian - Tuesday, June 12, 2012 8:38 AM:

Hi Vasant,

I'd be pretty sure that you cannot search like that on Federated items.

Federated data does not have a field in the database. It is filled in only on the client side so there is nothing for the SQL query to search on.

If you need to search on it then you will need to populate a field with this data.

Cheers,

Brian.



aponceot - Tuesday, June 12, 2012 3:15 PM:

Hi,

 

I approve Brian on that, you can not search a federated property because it is only an element added to the xml result after the get action.

If you want to search on the property, you will need to sync your federated source with your item in order to have a field in the Aras database. To do that, I think you'll need to do the sync on before get, otherwise, if your data change on your foreign source, it will not be properly retrieve.