How can I tell what that startup form is on a solution? (without the Servoy GUI). I need to write a SQL query to know what the first form is that will show on the solution.
I see that there is a first_form_id in the servoy_solutions table, but that appears to always be null…so where else is that property stored?
Hi scott,
If you don’t tell Servoy what form to open first it will open the first form in the list (alphabetically).
To tell Servoy which form you want to open first you go to Solution Settings (Menubar > File > Solution Settings) set the correct form.
I guess then you will find that first_form_id column filled.
Hope this helps.
I have several solution where the startup form is specified, but the first_form_id in the servoy_solutions table is always null
Okay, now you’ve done it! You’ve made me go look inside the repository.
This will get your form name when it is set.
SELECT p2.property_value
FROM servoy_solutions s,servoy_elements e,servoy_element_properties p,servoy_element_properties p2
WHERE s.solution_id=e.solution_id AND e.element_id=p.element_id AND p.content_id=245 AND p2.element_id=p.property_value AND p2.content_id=37 AND
solution_name='fillHereYourSolutionName'
GROUP BY p2.property_value, p2.content_id,p.revision, e.revision
ORDER BY p.revision, e.revision desc
LIMIT 1;
Hope this helps.
Thank you very much! I appreciate your help.
Oh, you can drop the GROUP BY line.
I needed that for testing my query.
This is sufficient:
SELECT p2.property_value
FROM servoy_solutions s,servoy_elements e,servoy_element_properties p,servoy_element_properties p2
WHERE s.solution_id=e.solution_id AND e.element_id=p.element_id AND p.content_id=245 AND p2.element_id=p.property_value AND p2.content_id=37 AND
solution_name='fillHereYourSolutionName'
ORDER BY p.revision, e.revision desc
LIMIT 1;
Also keep in mind this will get the data of the latest revision.
So if you rollback your solution and still keep the newer releases in your repository then it will still use the latest revision.