Complicated Query Scenario Advice

RentProperty

Hi There...

I have a scenario where I need to Dynamic Query on multiple options for Multiple attributes on dropdown lists, as well as Relationships on that object... All Simultaneously. Very similar to how you would use filters in Excel to pick 1 or all instances of a entry meeting the requirements... And being able to do this for any number of the column filters.

Example:

Main Object --> Has attributes 1, 2 and 3. Each of these has 3 options. So:
Attribute 1: Option 1, Option 2, Option 3
Attribute 2: Option 1, Option 2, Option 3
Attribute 3: Option 1, Option 2, Option 3

It also has a Parent relationship to Object 2 (1 to many).
The name of Object 2 can be one of 5 Options (X, Y, Z, A, B).

So I want to know if it is possible or if anyone has any suggestions on how I would go about building a dynamic query/process using filers, etc to do for instance the following search:

Show me all Instances of Object 1 Where Attribute One = Option 1 or Option 2.
AND Where Attribute 2 = Option 2 or Option 3
AND Where Attribute 3 = Option 1 or Option 3
AND Where Object 1 Owns an instance of Object 2 where the Name of Object 2 CONTAINS (X or Y or or A)

Please let me know if any one has any suggestions or maybe did something similar! Any help or advise would be highly appreciated!

Thanks a Million!

Hein

rocketman

FIND Object1 WHERE Object1.att1=?'enter something' AND Object1.Att2=?'enter something' AND Object1.att3=?'enter something' AND COUNT Object2 WHERE (OBJECT2 IN Object1.ReferenceAtt AND (Object2.name='X' OR Object2.name='Y')) > 0

might be the odd ( or ) missing but this is the general idea. You can also substitute the 'X' and 'Y' with the same ?'enter something' format as in the first part of the query to get the user to input the desired search criteria.

In this type of query, if the user does not enter anything for Object 1, 2 or 3, AIM will ignore these and just search on what has been provided as input

RentProperty

Hi Rocketman!

Thanks for the prompt reply. I'll Definitely give it a shot... However
this still does not address my main problem being that i want to allow the end user to select more than one possible option for each attribute of Object 1. I.e. Show all Candidates where Education level is 1 or 2 or 3 and where Race is Caucasian or Black, or Indian and where Gender is male or female.

Hope that makes sense? 🙂

Kind Regards

Hein

tford

Have you looked at these sample BSVs?:

RentProperty

Oh My word TFord!!!

This is EXACTLY what I'm Looking for!! Thank You SOOOOO Much!! 🙂

Bit confused as to how to piece it together, but I'm sure I'll figure it out when playing around.

Thank you So much Guys! I Love this Aware IM Community!

Kindest Regards

Hein

RentProperty

Hi Tford, I've been playing around with this a bit...

Do You know if this is only possible to do with RegularUser objects? I need to give a system user the ability to do this but It won't show me the option to display that attribute in the SystemUser form, even though I have Defined the Relationship to the object I want to Search on.

mmm if this is the case then I guess I'll have to look for another solution.

Kind regards

Hein

pbrad

Hi,
In order to be available in SystemUser rules, the attribute has to exist in all objects that are in the business object group.

Cheers,
Pete

RentProperty

Hi Pbrad &Tford

Thanks for all the assistance... I'm making good progress.

Do you know if it is possible to implement the same logic for a relationship 1 level deeper but in the same query as the others attributes?

I.e.
I have an object Disability (used to define possible disabilities. In other words a list of options to choose from). I've added a peer relationship to Disability from my SystemUser as in the BSV examples you've sent previously.

I have an object Candidate.

I have an object CandidateDisability, where I define the detail of a disability for a specific candidate. A candidate can have 1 or many CandidateDisabilities. The name of the CandidateDisability is a selected...(Peer relationship to Disability)

ok.. Hope this makes sense... Now I want to be able to use a filter to select 1 or many Disabilities that I want to search for in Candidate using OR. I.e.
I want to see all Candidates who has a CandidateDisability WHERE the name of the Candidate Disability = any one of the selected Disabilities.

I've tried alot of different syntaxes but can't seem to get it right... In fact I don't even know if it's possible but It doesn't look so farfetched to me, so I can't see a reason why it won't be possible... I just cannot get it right.

I used the COUNT way You've previously suggested but keep getting Syntax error.

I Tried:

FIND Candidate WHERE COUNT (Candidate.CandidateDisability WHERE(CandidateDisability IN Candidate.CandidateDisability) AND Candidate.CandidateDisability.Name=LoggedInSystemUser.Selected_Disabilities))>0

But Keep on giving me Syntax Error ".".

Is my logic

completely of the beaten path?

Thanks for the help! Much appreciated!

Hein

tford

Try making a new Candidate attribute to calculate the info you are trying to count in the search. Then use the new attribut in your FIND.

RentProperty

Thanks for all the help everyone! I finally got it to work with a new Counter attribute as Tford suggested as well as a ProcessFlag. It works PERFECTLY now! 🙂

I can now search select multiple relationships and single attributes to filter on. Amazing... With a bit of effort there is literally nothing one cannot do in Aware IM. Very pleased.

Kind Regards

Hein