How to search for Initial Code value?

[chrvi]

Hi,

I've populated a method's Initial Code but I can't use Advanced search (searching Method Details) to find it. If it were Behavior field I'd obtain the object immediately. However, for the Initial Code field it doesn't work.

Does anybody know another way of searching for initial code values?

Thanks.

Radek

[thomaskilian]

Generate the source and use Notepad++

[Ronaldo Juliatto]

Well... one year and a half later, I redo the question:

- Is it possible to search for a word in the "Initial Code" field through the Model search not using SQL?
- And also: is it possible to search for a word in a Linked Document also not using SQL?

I am afraid the answers to these questions are still "No", and I sure don't have anything against SQL... the problem is that I wanted to add these searches to the 'Extended' predefined search profile, and did not want to code all this search in SQL.

Would anybody have a clue to do this?

Thanks in advance

Ronaldo Juliatto

[Dorian Workman]

Could you please post your SQL query for searching for a string inside a Linked Document?  It would be very useful to me.

Thanks.

[Geert Bellekens]

Dorian,

I'm afraid the content of the linked documents is stored in a binary format in the database. (t_document.BinContent)
So it won't be possible to query them.
If you really need this then you will need to write a small program that uses the API to get the linked documents in a string format, and then search in those strings.

Geert

[Dorian Workman]

Thanks Geert, that's disappointing to hear though.

I'm no programmer; has anyone out there already written this program (wishful thinking perhaps)?

Thanks.

[Dorian Workman]

As an aside, we use Linked Documents heavily for tables.  If Element's Notes field would support tables, our need would go away.  I've already submitted a feature request for table support in Element Notes fields.  I hope it happens soon, because the more time that passes, the more Linked Docs we will eventually need to convert.

Any word from the Sparxians on when we might get this table support please?  :-/

Thanks!