InfoQube IM - Community

Submitted by seanlu21 on 2017/02/23 07:46

Wah, i had sent several emails but now I found I can actually post here.... thats good,

Lets start with my current confustion for my 1st post:

I had imported an Ecco database,

I'd like to turn the 'Item' values into a new field so that I can edit it.

Is this possible to create a new field to fetch or copy/paste value/text from the 'Item' field ? but only for those items basis a filter?

Thank you.

Sean

Comments

Hi Sean and welcome to the IQ community web site !

You can easily copy the item field to another text field, but for the record you don't need to do that to edit, the item field is editable !

To copy it, there are many ways, here is a few:

Copy / paste in the grid
Select a bunch of items and in the Properties pane, in the other text field, enter =[item]
In the Manage field dialog, for the text field, enter =[item] as the row equation and press the refresh button (this will copy all the text of all items)
If you want to copy only those that meet a filter, create a grid, set its filter and once you have just the right items, use methods 1 or 2 above

HTH !

Pierre_Admin

IQ Designer

Thank you Pierre,

In your message, you said :

You can easily copy the item field to another text field, but for the record you don't need to do that to edit, the item field is editable !

Here is my understand and some question, please also help me :

- the reason i would like to create a new column for the 'item's data is that i had read one post before

mentioning that i can hide the 'item' and use another field

to work the same way as traditional database i used the before, however I still not able to figure that out.

what I mean is, for example i have flwg item in IQ:

example item : * Book_A is writen by Author_A from Country_A

* Book_A is bought by Mr_A on Date_a

* Book_A is bought by Mr_B on Date_b

* Book_B is writen by Author_B from country_B

* Book_B is bought by Mr_C on date_c

in my old familiar database system, I actually have 2 database to manage those info:

1. a Book Information , looks like this:

Name | Author | Origin

1. Book_A | Author_A | Country_A

2. Book_B| Author _B | coutry_b

and

2.. a borrowing history database, looks like follows:

Name | Borrower | Borrowed date

1 Book_A| Mr_A | Date_a

2. Book_A| Mr_B | Date_b

3.Book_A | Mr_d | date_d

4. Book_B | Mr_c | Date_c

etc

"Book Information" database acually have a 1-to-many or Many-to-1 relationship with "Book borrowwing history" database.

as I understand in 'IQ'... we still can achieve similar views by setup differen column you need to make different 'grid' to show

what I required.

However in old database I can simply link Book_A in DB1 to add borrowing records in DB2 for this book, but in IQ i need to

write all items in one file to view them by different 'grid', that means , say, I have to type the book's name in every borrowing records.

I believe you can tell me the best way to mimic what I described kind of relationship in old database concept here in IQ. pls guide me.

and for right now, I am trying to use a field's 'auto saved list' feature to try to same time.

but is it possible to achieve following grid/way of adding item as I wished:

Date_A

Book_1 | Mr_A |

Book_1 | Mr_B |

Book_2 | Mr_C |

Date_B

Book_1 | Mr_d |

let me explain what I expect from above looks of grid and what the problem i encountered :

1. I can achieve the above looking grid by 'drag column to group that column'

2. but I also like to 'Insert' a new item under the corresponding 'group', say if under "Date_A" group, I press 'insert', I

expect to insert/add a new item under 'Date_A' , BUT it automatically insert/add a new item on un-grouped , top item.

how can I do add a new item under a certain group resulting in that item automatically assigned that group's value in

the grouped 'column' ?

3. i also want to automatically assign the date+time to the "Borrowing Date" column, the time I add a item.

I tried this by write "=Now()" or "=int(Now)" in the 'default value' in field property. but the first code only work when I

double click the field.

I also can not find a complete post as how to write this kind of formula in IQ. pls tell me where I can learn it?

( for example I'd like to write a code in the 'source bar''s filter box : " [column1] <> 0 AND [column2] >= a specific date IF [column3] is "a TEXT" " etc.. how can i write a proper one ? )

Many thanks for your patience so far, I think I need to stop here for now.

I know I have typed without a good organized thought, but as I am not an IT guy and

and not an English native speaker, please forgive me and please help try to understand what I expect... thank you in advance.

To copy it, there are many ways, here is a few:

Copy / paste in the grid
Select a bunch of items and in the Properties pane, in the other text field, enter =[item]
In the Manage field dialog, for the text field, enter =[item] as the row equation and press the refresh button (this will copy all the text of all items)
If you want to copy only those that meet a filter, create a grid, set its filter and once you have just the right items, use methods 1 or 2 above

HTH !

----

sean lu

Hi Sean,

Let me release v92 and I'll write up something on how to use IQ in lieu of a relational database.

Have a great day !

Pierre_Admin

IQ Designer

Of course Pierre, I know I had put a lot questions there, but am very happy to hear you will look at it and help me with them, just please take your time Pierre, I will wait for you.

Have a nice day.

Regards

----

sean lu

Dear Pierre,

Hi, just remind you if you have time to reply or show me how on my previous question:

---qte--

Submitted by seanlu21 on Sat, 2017-02-25 16:02.

Thank you Pierre,

In your message, you said :

You can easily copy the item field to another text field, but for the record you don't need to do that to edit, the item field is editable !

Here is my understand and some question, please also help me :

- the reason i would like to create a new column for the 'item's data is that i had read one post before

mentioning that i can hide the 'item' and use another field

to work the same way as traditional database i used the before, however I still not able to figure that out.

what I mean is, for example i have flwg item in IQ:

example item : * Book_A is writen by Author_A from Country_A

* Book_A is bought by Mr_A on Date_a

* Book_A is bought by Mr_B on Date_b

* Book_B is writen by Author_B from country_B

* Book_B is bought by Mr_C on date_c

in my old familiar database system, I actually have 2 database to manage those info:

1. a Book Information , looks like this:

Name | Author | Origin

1. Book_A | Author_A | Country_A

2. Book_B| Author _B | coutry_b

and

2.. a borrowing history database, looks like follows:

Name | Borrower | Borrowed date

1 Book_A| Mr_A | Date_a

2. Book_A| Mr_B | Date_b

3.Book_A | Mr_d | date_d

4. Book_B | Mr_c | Date_c

etc

"Book Information" database acually have a 1-to-many or Many-to-1 relationship with "Book borrowwing history" database.

as I understand in 'IQ'... we still can achieve similar views by setup differen column you need to make different 'grid' to show

what I required.

However in old database I can simply link Book_A in DB1 to add borrowing records in DB2 for this book, but in IQ i need to

write all items in one file to view them by different 'grid', that means , say, I have to type the book's name in every borrowing records.

I believe you can tell me the best way to mimic what I described kind of relationship in old database concept here in IQ. pls guide me.

and for right now, I am trying to use a field's 'auto saved list' feature to try to same time.

but is it possible to achieve following grid/way of adding item as I wished:

Date_A

Book_1 | Mr_A |

Book_1 | Mr_B |

Book_2 | Mr_C |

Date_B

Book_1 | Mr_d |

let me explain what I expect from above looks of grid and what the problem i encountered :

1. I can achieve the above looking grid by 'drag column to group that column'

2. but I also like to 'Insert' a new item under the corresponding 'group', say if under "Date_A" group, I press 'insert', I

expect to insert/add a new item under 'Date_A' , BUT it automatically insert/add a new item on un-grouped , top item.

how can I do add a new item under a certain group resulting in that item automatically assigned that group's value in

the grouped 'column' ?

3. i also want to automatically assign the date+time to the "Borrowing Date" column, the time I add a item.

I tried this by write "=Now()" or "=int(Now)" in the 'default value' in field property. but the first code only work when I

double click the field.

I also can not find a complete post as how to write this kind of formula in IQ. pls tell me where I can learn it?

( for example I'd like to write a code in the 'source bar''s filter box : " [column1] <> 0 AND [column2] >= a specific date IF [column3] is "a TEXT" " etc.. how can i write a proper one ? )

Many thanks for your patience so far, I think I need to stop here for now.

I know I have typed without a good organized thought, but as I am not an IT guy and

and not an English native speaker, please forgive me and please help try to understand what I expect... thank you in advance.

--- unqte ---

Kind regards,

----

sean lu

Hi, Pierre,

Just want to see if you have time or if there is other resource I can approach on how to use IQ in lieu of a relational database ?

Kind regards

----

sean lu

Hi Sean,

A write-up on how to use IQ as a relational database is now on the high priority list.

Pierre_Admin

IQ Designer

A sample IQBase showing how to mimic relational database is being worked on right now.

See IQ as a Relational Database: Book Review Process

Pierre_Admin

IQ Designer

Thank you Pierre, I am reading this document now, it is great to have those information for me, thanks again.

By the way, I had found a, I think may be a mistake if I am not wrong , when I was reading all information in the forum, in the user manual node 128 description regarding "Equations", I attach the screen shot I take and I think the correct equation should be :

StartDate’s Row Equation: =[EndDate] - [Duration]
EndDate’s Row Equation: =[StartDate] + [StartDate]

instead of what written in the node 128.

Please tell me if I am wrong.

Kind regards,

----

sean lu

Thanks Sean, I updated the documentation !

Pierre_Admin

IQ Designer