In which table or file location are 'My Searches' stored?

[Jacob Vos]

I lost a SQL query that was stored in 'My Searches'. There is a database backup, but: in which table are 'My Searches' stored? Going through the tables, I didn't find one with a name that would let me think about stored searches. Or are my searches stored elsewhere?

[Eve]

'My searches' are usually stored in C:\Users\<username>\AppData\Roaming\Sparx Systems\EA\Search Data\EA_Search.xml

[Jacob Vos]

@Eve: Thank! Found it. Strange: the XML-file contains my 'lost' query, and has another query with exactly the same name (but other GUID).

[Eve]

Maybe you've effectively hidden your original query by adding another with the same name. Anyway, glad you've found your query.