Interpreting query graphics
To set up the conditions for your query and create the graphical query structure, you need to know how iBridge will interpret the graphics. This is explained below using a series of examples to explain how to set up increasingly complex queries.
Find all people who hold accounts, together with their accounts.
This will find all the people in the database who hold at least one account. The people, all their accounts and the Account Owner links between them will all be charted.
Find all the people who hold two or more accounts, together with their
This will find all of the people with at least two accounts. The people, all their accounts and the Account Owner links between them will be charted.
Find the people who hold accounts at different banks.
This will chart all the people who hold accounts at different banks. It will not chart the accounts themselves or the banks, nor will it chart the links.
Find all of the joint accounts.
This will find all of the accounts in the database that are held by more than one person. The accounts will be charted but the people who hold the accounts will not.
Find all check transactions in excess of 400.
For this query, you will need to add conditions onto the Check transaction link to indicate that you are looking for transactions greater than 400. The accounts and transactions will be charted.
Find all of the check transactions between Sharon Grainger and Phil
For this query, you will need to add conditions to each of the person entities to indicate that one of them must be called Sharon Grainger and the other must be called Phil Taylor. The accounts and Check Transaction links will be charted but the two people will not.
Find out if any of the people already charted from the database own any of the
accounts already charted from the database.
This query will not chart any additional people or accounts (they are not set to be charted) but will chart any Account Owner links between people and accounts that are already on the chart.